… parallelized purge: in MySQL 5.5 there is an option to have a single separate dedicated purge thread and in MySQL 5.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple purge threads too, although…=barracuda innodb_file_per_table max_connections=2000 table_cache=2000 Percona Server 5.1 Results For better presentation let’s also…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… into two bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql workload But at the… 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_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp…
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
… that’s gone. As of MySQL 5.5, the query cache mutex isn’t hit at all if query_cache_type is zero. We made… 5.5, and instead backported the 5.5 fix to our 5.1 branch and replaced our fix. There are some other query cache improvements in MySQL 5.5…, that changes the thread‘s status in SHOW PROCESSLIST to “Waiting on query cache mutex” when the query cache mutex is taken. This…
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…=0 , to disable flushing of neighborhood pages (not available in MySQL 5.5.8). The problem with flushing neighborhood pages is that it…_threads=8 innodb_read_io_threads=8 innodb_io_capacity=500 max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql.sock…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…for Percona MySQL University in Raleigh,NC, Tuesday 29th of January I have created the outline of improvements available in MySQL 5.6…Mutex” – Data Dictionary Cache – Improved Adaptive Flushing – Page Cleaner/Separate Flush Thread – Group Commit for Binary Log – Fight Cache Coherence and False …
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql-5.5.28/usr/sbin/mysqld… /usr/local/percona/mysql-5.5.28/usr/sbin/mysqld) | | | ->10.10% (7,135,744B) 0x3ECF60677B: start_thread (in /lib64/libpthread-2.5.so) | | | ->10…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… things which need to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which….0-35-generic Architecture | CPU = 64-bit, OS = 64-bit Threading | NPTL 2.15 SELinux | No SELinux detected Virtualized | No virtualization…
Post: Announcing Percona Server 5.5.24-26.0
June 1, 2012 By 9 Comments
… cache enabled could crash with glibc detected memory corruption. This bug was introduced in MySQL 5.5.18 and Percona Server inherited it from MySQL…. Bug fixed #997496 (Alexey Kopytov). Variable `thread_statistics` was a reserved word in Percona Server 5.5. As a result, the server variable…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…be allocated but it is a lot larger problems with MySQL 5.5 with addition of user variables, stored procedures, prepared statements etc…Dictionary cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0 + 0) Threads …
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… upgrading from MySQL 5.0 or 5.1 prior to version 5.1.24. A fix for a MySQL bug (#27877) …. Bug Fixes When adding a table to the cache, the server may evict and close another if … and stopping the Slave SQL thread. Bugs Fixed #813587 / #51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized values …
