…. 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…
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…
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: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…) There are several advantages to self-compiling: When using the latest version of Valgrind, even compiled ‘out of the box’ (i.e…. (For example, Percona Server 5.5 source can be debug-compiled by using ‘./build/build-binary –debug ..’). Valgrind Massif needs the…) 0x728DAA: Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona…
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
… be as easy as stopping MySQL, updating symlinks or your my.cnf basedir, starting MySQL and running mysql_upgrade. Unlike package managers, you… other dependencies i.e. mysql-libs dependency for postfix, crontab, etc on RHEL based distros. Custom Built Binaries (compile your own) Specialized…, compiling custom MySQL binaries takes a third of the options. If you develop and integrate custom features or patches, need to alter MySQL…
