… patch from MariaDB. This feature adds atomic write support for directFS filesystem on Fusion-io devices… could cause a memory leak if query cache was used together with InnoDB. Bug fixed #… the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password …
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…The write load is not excessive so a single server can easily handle the write load of all the MySQL … maybe it is related to better raid controller write cache use. Even the fairly slow gzip-1 …other drive in the mirror. Better availability and disk usage On purpose, I allocated mirror pairs …
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path separator between the…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can…it doesn’t though.) Why don’t you try writing a SQL query optimizer and see how easy it…in a suboptimal form. Q: Doesn’t the primary key solution for random selection only work when the …
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… share my experience in this post. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from… details are clearly explained here. The plugin writes its output in json format, and supports writing it directly to a file, or… why that is the case. Maybe someone more knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of…
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… Savings on disk space and network bandwidth Automatic backup verification Higher uptime due to faster restore time XtraBackup makes MySQL hot backups… Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL Support contracts include support for XtraBackup. We…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… the keys with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql…_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
…, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA… replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide access to government data. The…… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you … own caveats, but you can also gain a lot from write set replication. If the application gets really popular, sooner or later you have to think about write scalability, and implement sharding ultimately. I will give a talk…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… create orig_old Load the schema into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table..._old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE…_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE…
