June 20, 2013

Post: Percona Server for MySQL 5.5.30-30.2 now available

MySQL version 5.5.30-30.2[/caption] Percona is glad to announce the release of Percona Server for MySQL 5.5.30-30…read_view_open_now() which is another problem originally reported as upstream bug #49169. …). UDF/configure.ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). …

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

… state before updating. This caused some problems for some users, especially if automatic …). UDF/configure.ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). …Hrvoje Matijakovic). Release notes for Percona Server for MySQL 5.5.30-30.2 are available in our online documentation…

Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2

problem: 1) memory allocation is an costly operation and if memory allocator has scalability problems (like allocator from glibc) this will notably slowdown MySQL… allocators. Observations: = MySQL 5.5.30 – throughput of MySQL 5.5.30 with glibc …MySQL 5.6.10 – in autocommit mode 5.6.10 has no problem

Post: The write cache: Swap insanity tome III

… need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache…160 18893 17002 6 5 83 6 0 Fri Mar 22 10:03:30 UTC 2013 1 2 291992 324640 138836… were cached and the write cache was causing the problem. It happened that the setting vm.dirty_ratio was…

Post: Benchmarking Percona Server TokuDB vs InnoDB

…drops are quite concerning, and it might be a problem for some users. Now, I understand that my…-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for …_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size…

Post: Upgrading MySQL

… version – Upgrade of MySQL 5.0.30 to 5.0.32 is generally likely to expose less issues than 5.0.30 to 5.0.86. The… compatibility between version and so you can run MySQL 5.0 database with MySQL 5.1 with no problems in most cases. When storage type changes, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL

Post: How to debug long-running transactions in MySQL

… the processlist. The steps I use to debug this problem are as follows. First, I identify which transaction is … into a query log, and examine the log. In MySQL 5.1 and newer with the InnoDB plugin, it’s easy … session and run it in a loop with a 30-second sleep in between. Notice that it self-purges …

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

… tested three configurations: Config 1: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all default settings… from MySQL 5.5.30, which performs significantly better on the repeat warm runs. Just to be sure it wasn’t a disk problem, I pointed the MySQL 5.6.10 at the MySQL 5.5.30 data directory.  Tthe speed was essentially…

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

… Search in MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In part 1, we… with name, address, and the like. We are using MySQL 5.5.30 and MySQL 5.6.10 with no configuration tuning other than to set… set innodb_ft_min_token_size to 1. Otherwise you’ll run into the same problem as our Mr. Smith here. [This…

Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1

MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1…-cache=512 –net_read_timeout=30 –net_write_timeout=30 –backlog=128 MyISAM / InnoDB:…enough. Perhaps there is still a problem with InnoDB mutexes. READ_KEY_POINT…