… from show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
… large innodb database, do I have to export databases from mysql and import them in Percona server or can I use mysql…? 2. What’s the advantage of using Percona server over MySQL? 3. I am using CentOS for my servers but i develop…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables… as MYISAM) with innodb tables within the same transaction. The same issue can arise if slave host is using different storage engine…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… likely not hitting a bottleneck caused by compression. If I use SSD for L2ARC, I’ll need to do the same… for a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the filesystem. I took…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
We’ve been using ZFS on FreeBSD for backup and production for a few … write buffering, so make sure these are turned off in InnoDB.
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… 2.1 version to 2.1.3 if you’re using the Percona XtraBackup with Percona XtraDB Cluster. This release is… MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 22, 2013 By 32 Comments
Hi Vadim, I can confirm the steady downfall of InnoDB throughput down to ~1500 insert/sec (and counting) while TokuDB … steadily around 20000 insert/sec. I inserted around 100Million rows using Tokutek’s iibench.py for the benchmark on a 2…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…). As expected, there is a slowdown for write operations when using the InnoDB version. But there is also a slight increase in… this is using InnoDB under the hood (redo logs, etc). Based on the above numbers, here are the relative differences: InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20% higher (~.06…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… = 2 innodb_log_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… for any InnoDB table. If explicitely defined its `NAME` is PRIMARY. If the primary key is not defined InnoDB will use a unique secondary index as the primary. If there is no any unique index InnoDB will create… make sense it is still zero. If you know how InnoDB uses `PREC` please let me know. mysql> select * from SYS_COLUMNS…
