June 20, 2013

Post: Percona Server for MySQL 5.5.30-30.2 now available

April 10, 2013 By 10 Comments

…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). …

Filed Under: MySQL

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

April 24, 2013 By Leave a Comment

… 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…

Filed Under: MySQL, Percona Software

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

April 15, 2013 By

…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…

Filed Under: Benchmarks, MySQL, Percona Software Tagged With: , , , , , ,

Post: The write cache: Swap insanity tome III

April 19, 2013 By 5 Comments

… 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…

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , ,

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

…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…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Post: Upgrading MySQL

January 5, 2010 By 24 Comments

… 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…

Filed Under: Insight for DBAs, MySQL

Post: How to debug long-running transactions in MySQL

March 8, 2011 By 6 Comments

… 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 …

Filed Under: Insight for DBAs, MySQL

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

March 11, 2013 By 7 Comments

… 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…

Filed Under: MySQL Tagged With: , , , , ,

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

March 4, 2013 By 7 Comments

… 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…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1

January 8, 2007 By 117 Comments

…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…

Filed Under: Benchmarks Tagged With: ,
« Older Posts