… downfall of InnoDB throughput down to ~1500 insert/sec (and counting) while TokuDB remained steadily around 20000 insert/sec. I inserted…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… two in what is now a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL… a database’s ability to optimize queries for a star schema. A star schema presents some unique challenge to the database optimizer…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log tells us why the IO… new table on the master: mysql> create table test.t (id int not null auto_increment primary key); Executing SHOW TABLES…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…caption id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL …
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… the table structures: mysqldump –no-data orig > /tmp/orig.schema.sql Create the new target database: mysqladmin create orig_old Load… into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare…’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` IMPORT TABLESPACE;’) AS _ddl…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are going to be…
Post: Private, custom Percona MySQL Training
June 7, 2013 By Leave a Comment
…caption id=”" align=”alignright” width=”320″] Alexei Rodriguez presenting at PLMCE13[/caption] …
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… amount of ram prevents double caching by the file system vs the InnoDB caching. However, limited ARC size also limits ZFS…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…caption id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL …
Comment: Neat tricks for the MySQL command-line pager
June 3, 2013 By 13 Comments
On *nix systems, before your sql statement enter: \P more or \P less
