Loading ...Sometimes we have some special need for a stored procedure to call another to do something. That is fine, but what if the second stored proc failed for some reason? Maybe you want to halt the first stored procedure (the caller) and not proceed with the work until the problem is verified and resolved. So [...]
If you have multiple database servers with strange names, or if you have to hop over multiple machines to connect to any mysql database server, then you know what a pain it can be to administer such a setup. Thanks to some scripting, you can automate such tasks as follows: Create an expect script: /path/to/sshmysql.exp [...]
MySQL instance running an Infobright engine mysql> explain SELECT COUNT(ac.UID) FROM ACTIVE ac JOIN ALL a; +—-+————-+——-+——+—————+——+———+——+———+——-+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +—-+————-+——-+——+—————+——+———+——+———+——-+ | 1 | SIMPLE | ac | ALL | NULL | NULL | NULL | NULL [...]