… over in both directions. Aside from MySQL Cluster, which is more special-purpose,…ALTER TABLE, for example). The benefit is that you have another server with all the …select table_schema, table_name, page_type, count(*) from information_schema.innodb_buffer_pool_content group by 1, 2, 3 into outfile…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
…OUTFILE ‘/tmp/tbl1.txt’; LOAD DATA INFILE ‘/tmp/tbl1.txt’ INTO TABLE tbl2; instead of: INSERT INTO tbl2 SELECT * from tbl1; INSERT … INTO OUTFILE…SELECT you may execute this transaction in READ-COMMITTED isolation mode. Other workarounds are less general purpose. For example…
Post: Mass killing of MySQL Connections
May 21, 2009 By 30 Comments
… into situation when I need to kill a lot of connections on MySQL server – for example…way to do it just using MySQL with a few commands: mysql> select concat(‘KILL ‘,id,’;') from ….00 sec) mysql> select concat(‘KILL ‘,id,’;') from information_schema.processlist where user=’root’ into outfile ‘/tmp/a….
Post: Using INFORMATION_SCHEMA instead of shell scripting
November 24, 2008 By 7 Comments
…INTO OUTFILE to create very simple shell script: mysql> select concat(“mysqldump “,table_schema,” “,table_name, ” >> “,table_schema,”.sql”) from tables where engine=’innodb’ into outfile…
Post: Using Multiple Key Caches for MyISAM Scalability
November 26, 2008 By 8 Comments
… fixed with new Key Cache in MySQL 4.1, and indeed previously it did not even scale with one… multiple key caches for the same table, for example caching even/odd key blocks or something similar,…min 31.68 sec) Pass this via SELECT INTO OUTFILE or pipe it to mysql directly as explained here to create …
