INFORMATION_SCHEMA, in particular by favorite TABLES table is not only helpful … INTO OUTFILE to create very simple shell script: mysql> select concat(“mysqldump “,table_schema,” “,table_name, ” >> “,table_schema,”.sql”) from tables where engine=’innodb…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… and only works with shell access to the server which is not always the case. Interesting enough MySQL Allows you to SET… dealing with MySQL variables in automated way a lot more convenient would be extending INFORMATION_SCHEMA.GLOBAL_VARIABLES Currently as of MySQL 5.5… querying of variable global value Right now I can select: mysql> select @@global.sort_buffer_size; +—————————+ | @@global.sort_buffer_size | +—————————+ | 2097152…
Comment: Mass killing of MySQL Connections
May 29, 2009 By 30 Comments
… database. SELECT ‘OPTIMIZE TABLE ‘, CONCAT(TABLE_SCHEMA, ‘.’, TABLE_NAME, ‘;’) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘World’; — . To execute: shell> mysql –skip-column-names < optimizeworld.sfs | mysql
