…maintain checksum consistency during regular operations and is not ACID compliant. MyISAM and InnoDB may perform differently under concurrency, which this benchmark…/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory … CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts …
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…’t start if the XtraDB changed page tracking was enabled and variable innodb_flush_method was set to ALL_O_DIRECT. Bug… the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently… needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path separator between the directory and file name components in…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… we need to and align the partition correctly. We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then… InnoDB, it will be caught by ZFS and the data will be read from the other drive in the mirror. Better availability and… solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS the impact is up front and the backups…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…safe bet that MySQL is up and running. That said, there are plenty of other MySQL and OS-level status…imagine the performance being all that fantastic, and I could see network latency wreaking havoc with MySQL‘s …up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to …
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you… MySQL hot backups for all versions of Percona Server, MySQL, MariaDB, and Drizzle. It performs streaming, compressed, and incremental MySQL backups. Percona’s enterprise-grade commercial MySQL…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… 3rd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug… allocated calling calloc() directly instead of using InnoDB heap allocation. This may improve write performance for high levels of concurrency. Bug fixed…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
… modern versions of InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster And from the manual: http://dev.mysql.com/doc/refman/5.5/en/innodb-performance-recovery.html…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
…from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP …non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The …CREATE TABLE …. SELECT – It is not supported to perform such type of statements http://mysqlopt….
