…mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…OS partition mirror) and I limited the ARC size to 4GB. I don’t want…the snapshot while holding a “flush tables with read lock” and the flush…data that doesn’t compress well showed a compression ration of 1.70 with… is a very interesting solution for MySQL backup servers. All backup solutions have…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… related output from show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap size 440760, 799203 row lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… Server showed fairly close results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5… –num-threads=<1..1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report-interval=1 –rand-type… –num-threads=<1..1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report-interval=1 –rand-type…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… – SSD config) which shows the most consistent …mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…. So TokuDB shows about 2.8x better throughput, and on data size: InnoDB table: 58GB and 244.980.192 records TokuDB table: 15GB and… run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…, unlike anything you find in standard async MySQL replication. It is my belief that the …size of the transactions, which translates into number of unique key lookups into the certification index, which is a hash table… came from this node because ‘Flow snt’ shows a message sent as soon as flow …
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and Percona Server shows much better… innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io… sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… with different buffer pool sizes. Results are pretty interesting. I used modified Sysbench table for these tests because original table as initially created… RAID10. I used 10mil row table which would look as following in terms of data and index size: mysql> show table status like “sbtest” \G…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow it… it reflect natural state of the table as it would be in the production over time: mysql> show table status like “post_channel” \G… size including indexes which is way more than buffer pool size and OS cache which is available. I run CHECK TABLE on this table…
