…=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3…() directly instead of using InnoDB heap allocation. This may improve write … to indicate an incomplete result set. Bug fixed #1185040. The INNODB_…expand too fast around 500KB tablespace size. Bug fixed #1169494. Fixed the RPM…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… designed to look solely at vCache performance under some different sets of MySQL configuration parameters. For example, given that the front-end… = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size…size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql… TokuDB comes with good settings out-of-box, but…
Post: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
January 19, 2007 By 17 Comments
… Right ? Wrong. In fact setting tmp_table_size is not enough as MySQL also looks at max_heap_table_size variable and uses lower value… tmp_table_size and max_heap_table_size ChangeSet@1.2358, 2007-01-03 14:45:26+03:00, ted@ted.mysql.internal +7 -0 BUG #4291: max_heap…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, …size 664 alloc’d ==9090== at 0x4C28FDF: malloc (vg_replace_malloc.c:236) ==9090== by 0x6B70A62: mem_heap… in mutex_get_waiters and mutex_set_waiters. Interestingly, there are comments next …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual,…set_connectionblogpercona.commanual character_set_databaseblogpercona.commanual character_set_filesystemblogpercona.commanual character_set_resultsblogpercona.commanual character_set_serverblogpercona.commanual character_set_systemblogpercona.commanual character_sets… max_heap_table_…
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
… 9 sec mysql tables in use 2, locked 2 8316 lock struct(s), heap size 1948088, 10008317 row lock(s) MySQL thread id 53173… sec fetching rows mysql tables in use 1, locked 1 9417 lock struct(s), heap size 915896, 696679 row lock(s) MySQL thread id 53173, OS thread handle 0x7ff75963b700, query id 3929840 localhost root Updating update sbtest set…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL…heap_table_size variable which allows you to limit size…) | +——————————-+ | 126984 | +——————————-+ 1 row in set (0.98…
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
… ACTIVE transactions alone would be misleading. There is a whole set of applications which run quite fine while having ACTIVE measured… id 1224980800 3 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 1720, query id… no 1098, OS thread id 1229596992 3 lock struct(s), heap size 368, 1 row lock(s), undo log entries 2 In…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… modify the same row: node1 mysql> set autocommit=off; Query OK, 0 rows affected (0.00 sec) node1 mysql> select * from autoinc; +—+——-+ | i… Warnings: 0 node1 mysql> SHOW ENGINE INNODB STATUS\G … ———— TRANSACTIONS ———— … —TRANSACTION 83B, ACTIVE 50 sec 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id 3972, OS thread…
