… Table and the new DROP Table in MySQL >= 5.5.23 work, I would like to mention quickly, that how drop table in MySQL …rows table: sysbench –test=oltp –oltp-table-size=20000000 –mysql-table-engine=innodb –mysql-socket=/tmp/mysql_sandbox5524.sock –mysql-db=test –oltp-table-name=sbtest_20m –max…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
… multi-table sysbench allow to load data in parallel, so let’s load in 16 tables in 16 parallel threads, 25,000,000 rows in each tables. That gives about 6GB of data per table (uncompressed) and 96GB of data in…-table-size=5000000 –oltp-read-only=on –rand-init=on –num-threads=16 –max-requests=0 –rand-type=uniform –max-time=1800 –mysql-user…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…row *************************** Name: post_channel Engine: InnoDB Version: 10 Row_format: Compact Rows: 278987416 Avg_row_length: 75 Data_length: 20975714304 Max…Comment: 1 row in set (0.02 sec) The table is approximately 30GB in …not available in MySQL 5.5 (different version is added back in MySQL 5…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…in RAID10. I used 10mil row table which would look as following in terms of data and index size: mysql> show table…
Post: Database access Optimization in Web Applications.
September 12, 2006 By 10 Comments
…running SELECT * FROM tbl to count amount of rows in the table (no joking). Sometimes you would see …domain = ‘mysql.com’; will return only one row while may require to scan hundreds of thousands of rows (…adding index on rank column maxes this query to use 10 rows to return 10 rows – exactly what we’…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
…ran small (1M rows) benchmark so data was well fitting in memory and…=oltp –mysql-socket=/tmp/mysql_sandbox5610.sock –mysql-user=msandbox_rw –mysql-password=msandbox –oltp-table-…max-time=300 run For single thread MySQL 5.5 is 11% faster than MySQL 5.6. If you disable Performance Schema in MySQL…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table… locked_in_memoryblogpercona….max_tmp_tablesblogpercona.commanual Max_used_connectionsblogpercona.commanual max_user_connectionsblogpercona.commanual max_write_lock_countblogpercona.commanual memlockblogpercona.commanual min_examined_row…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…rows in set (0.11 sec) As you can see table…mysql> select count(*) from cbool where c1NULL; +———-+ | count(*) | +———-+ | 1048576 | +———-+ 1 row in…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…row affected (0.00 sec) mysql> SELECT * FROM test_table; — 1 Ticket Used +——+ | id | +——+ | 1 | +——+ 1 row in set (0.00 sec) mysql> INSERT INTO test_table…-threads=16 –max-requests=0 –oltp-dist-type=uniform –max-time=300 –mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run …
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
… *************************** 1. row *************************** Name: test_innodb Engine: InnoDB Version: 10 Row_format: Compact Rows: 1069 Avg_row_length: 199 Data_length: 212992 Max_data…row in set (0.00 sec) When at certain point you will see Innodb Free space to become non zero: mysql> show table…
