… share my experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from… for the test (5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL data structures… line for switching between file and socket for output): plugin-load=AUDIT=libaudit_plugin.so audit_offsets=6464, 6512, 4072, 4512…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… new target database: mysqladmin create orig_old Load the schema into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure..._old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE… disclosure, here are the versions I was using on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing… has been loaded by the cold test already. The buffer pool and adaptive hash index are cold for the cold test. All tests were… this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the InnoDB tests, a 64GB buffer…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… backups. The write load is not excessive so a single server can easily handle the write load of all the MySQL instances. The… level was less than half of xfs for the tpcc test and that’s maybe just normal. We didn’t try… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… situations where even under just a moderate load on the host system, DRBD can end …. If you’re just setting up a test environment to get familiar with the technology, … in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… as the buffer pool pages were loaded from disk. Replaying Queries Working with … percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name…production database backup to our test database so that our test database was consistent before …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test….so used by the PAM Authentication Plugin couldn’t be loaded with Perl and Python clients when plugin-dir option was… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate…innodb_flush_neighbor_pages=none command line to load 10x dataset: ./bin/linkbench -D dbid=linkdb -D… config/MyConfig.properties -l command line to run test for 10x dataset: ./bin/linkbench -D requesters=64 …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about differences between results we have rerun tests on…_type=OFF performance_schema=0 warmup To warmup server and load data and indices to the buffer pool we use following…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…and a minimally tuned MySQL 5.6 instance running the memcached plugin. Here are some details about the test: Minimal hardware (vBox…< 10; $i++) { for ($i = 0; $i < 100000; $i++) { $obj = $cache->load(“key_$i”); } } $totalTimeFetch = $timer->stop(); $avgTimeFetch = $totalTimeFetch / 1000000; While …
