… line is shorter and neater. In my case here is the properties file in use for my Percona Server 5.6.10… this generally only works if you have used the exact same name (in this case, parent_id) in the child and parent… Metadata File The format of the metadata file is XML-based. I have included the metadata file I used to properly link…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… amounts of data are examined. Conclusion In some cases MyISAM is faster than InnoDB, but usually only … InnoDB tests, a 64GB buffer pool was used. O_DIRECT was used so, there was no caching of …_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…here. The plugin writes its output in json format, and supports writing it directly to a file… differences between either output option, or between using the plugin or enabling the general log. …not enough to understand why that is the case. Maybe someone more knowledgeable in MySQL internals …
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
… a bit and expanded to fit (hopefully) a 6 hour format. Expect a lot of down and dirty hands-on work…. Expect high level over view of PXC architectures with use cases (and anti-use cases), as well as a practical look at what configuring… usually bad idea. If you’ve considered an architecture that uses standard MySQL async replication with any kind of circular replication…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
…-stalk come in handy, but if you’ve used them, you know it can be a daunting …the simplest: the ‘raw’ log parser. If you specify –format rawlog, then the tool expects the input to …number of times they appear in processlist. In this case, I extracted the first snapshot from each *-processlist capture…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… MySQL as if it were using SSD storage or to just use an optimized HDD storage … Time-based flushing has been disabled. In this case, both systems produce better performance when the …A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… OLTP workloads in the CPU and IO-bound cases. For this test we used a PowerEdge R720 box with a fast PCI… small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and Percona Server…_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads = 8…
Post: Percona XtraBackup 2.1.2 for MySQL available for download
May 18, 2013 By 4 Comments
…release in the 2.1 series. Bugs Fixed: Using Perl’s DBD::MySQL package for server …-info option to fail. Bug fixed #1180672. The format of xtrabackup_galera_info was missing the ‘:’ separator…innobackupex –slave-info being ignored in such a case. Bug fixed #1180662. Low values for wait_timeout…
Post: Percona Server 5.5.30 with TokuDB for MySQL
April 24, 2013 By 26 Comments
… the adoption when it was distributed only in a binary format with a proprietary license. So I went and built Percona… in case you want to try it out for yourselves. It’s available from our TESTING download area. The source code used…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… to Barracuda file format using new InnoDB plugin recently released by Oracle. First thing I’ve tried was DYNAMIC row format. After 3… optimizations and I’ve tried to convert this table using COMPRESSED row format. This time conversion took 1,5 hours and results… many other indexes aside from PRIMARY, but for some other cases it could make sense to try other page sizes (not…
