… Dimitri was using 8 tables with 1M rows each (about 2.1GB) for his tests… –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point…UPDATE QPS test sysbench –num-threads=<1..1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… were conducted with approximately 78GiB of data (32 tables, 10M rows each) and a 4GiB buffer pool. The cache devices were… MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench –num-threads=32 –test=tests/db/oltp.lua –oltp_tables_count=32…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… dataset. We can easily fill TokuDB tables with 1bln of rows on this SSD, and projected InnoDB performance on this size…=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-requests=0 –num-threads=32…
Comment: ORDER BY ... LIMIT Performance Optimization
July 10, 2008 By 100 Comments
… id,state from states”; $rss=mysql_query($sqls) or die(mysql_error()); $num_rowss=mysql_num_rows($rss); $count=1; while($num_rowss && $datas=mysql_fetch_assoc($rss)) { $state… DESC, rand()”; $rsc=mysql_query($sqlc) or die(mysql_error()); $num_rowsc=mysql_num_rows($rsc); $checkonlyonetime=1; // header while($num_rowsc && $datac=mysql_fetch_assoc($rsc)) // loop…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
September 11, 2009 By 57 Comments
… use count this not will give you true result. in this case you have to use mysql_num_rows or SQL_CALC_FOUND_ROWS , mysql_num_rows runs very slow. we have only one option it is SQL_CALC_FOUND_ROWS. if…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…test=tests/db/parallel_prepare.lua –oltp-tables-count=16 –num-threads=16 –oltp-table-size=25000000 run …tables: 38278 sec. Compressed tables are create as: ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8, with…init=on –num-threads=16 –max-requests=0 –rand-type=uniform –max-time=1800 –mysql-user=root …
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
…lib/mysql/ib* files, while sysbench generates read/write activity: Screen0: root@localhost:~# sysbench –num-…mysql# /etc/init.d/mysql restart After the restart all InnoDB tables are reachable: mysql> select count(*) from sbtest; +———-+ | count(*) | +———-+ | 1000000 | +———-+ 1 row…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
… type | possible_keys | key | key_len | ref | rows | filtered | Extra | +—-+————-+———-+——-+—————+—————+———+————————-+——-+———-+————-+ | 1 | SIMPLE | supplier | index … MySQL 5.5 is as follows: SELECT o.*, count(*) as num_…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…mysql_query($query) or die(‘Query failed: ‘ . mysql_error()); // retrive result while ($line = mysql_fetch_array($result, MYSQL_NUM)) { } // Free resultset mysql…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… Warnings: 0 mysql> SELECT COUNT(*) FROM test_table; — 3 Tickets Used +———-+ | COUNT(*) | +———-+ | 3 | +———-+ 1 row in set (0.00 sec) mysql> UPDATE test…–num-threads=16 –max-requests=0 –oltp-dist-type=uniform –max-time=300 –mysql-user=root –mysql-socket=/var/lib/mysql/mysql….
