…. Bug fixed #1050654. Fixed the upstream bug #68999 which caused compiling Percona Server to fail on CentOS 5 and Debian squeeze… #1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… MDEV-3915). Bug fixed #1172090. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the InnoDB… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 20, 2013 By 13 Comments
… IBM computer, it came “bundled” with the software (OS and compilers); no option. You paid lots for a service contract (vaccuum… where a migration was virtually a rewrite. (Today moving from MySQL to/from Oracle/MSSql/etc is even more painful.) And…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of… leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery, this would… up on tmpfs. Bug fixed #1086978 (Alex Yurchenko). Issues with compiling Galera on the ARM architecture has been fixed. Bug fixed…
Comment: MySQL performance: Impact of memory allocators (Part 2)
March 22, 2013 By 12 Comments
Could Jemalloc improve performance no MySQL 5.6 on Windows 64-bit? How could we use Jemalloc on Windows 64-bit without compiling MySQL 5.6 source code with it? Thanks! Great article!!
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… need the table id to find indexes of the table. mysql> select * from SYS_TABLES WHERE NAME=’sakila/actor’; +————–+—–+——–+——+——–+———+————–+——-+ | NAME | ID… 1. Compile the dictionary parsers make dict_parsers 2. Split ibdata1 with page_parser ./page_parser -f /var/lib/mysql/ibdata1 3… of the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path/to/SYS…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
After compiling Percona Server with TokuDB, of course I wanted to compare …=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 3, 2013 By 10 Comments
…://blog.ulf-wendel.de/2013/toying-with-peclmysqlnd_memcache-and-mysql-5-6-memcache-innodb/ HandlerSocket vs Memcache is hard to… apples and oranges, means different server version. HS does not compile with MySQL 5.6 (yet). If you compare HS @ 5.5… features… see also http://de.slideshare.net/nixnutz/nosql-in-mysql Independent YCSB results would be interesting but require significant time…
Post: InnoDB in self-compiled MySQL 5.1
September 13, 2007 By 9 Comments
If you like to compile MySQL from sources by yourself, for different needs, like debugging, testing … issue. What I usually do to fast compile and test is ./configure –prefix=/dir/to/mysql make make install and then, for… MySQL 3.23 with great performance | NO | NO | NO | +————+———+———————————————————–+————–+—-+————+ 4 rows in set (0.00 sec) By default InnoDB is not compiled…
Post: Rebuilding MySQL with same options
April 8, 2010 By 4 Comments
… the system with custom compiled MySQL. How to upgrade to the new MySQL Options while preserving as much of original compilation options as possible if original build scripts are not available ? MySQL distribution…
