… easily runable ? Well just use 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 ‘/tmp/dump.sh’; Query…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… unsigned not null default 0; Query OK, 300024 rows affected (13.28 sec… 23 rows in set (0.00 sec) mysql> select count(*) from salaries where emp_no = 10001; +———-+ | count(*) | +———-+ …shell script to create snapshots and uploaded it here. By no means it is perfect, you can use…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… full table scan. Not all queries are going to be affected same way, for example point select reading single page should not… as we show here. Benchmarks were done using this script: The benchmark run with following simple shell script: [root@DB10 ~]# for i in 1….4009695919sec. The script creates specified amount of tables and does specified number of inserts going to random tables. I used default MySQL…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… of query execution, normally hidden from everyone’s eyes. Currently it’s used by …, we can begin. Open command line (shell) on the server and go to… include/my_time.h patching file scripts/mysqldumpslow.sh patching file sql-common/…_parse.cc patching file sql/sql_select.cc patching file sql/sql_show…
