June 19, 2013

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

database optimizer. The SSB benchmark consists of four sets of queries. Each set is known as a “flight”. I have labeled each query asmy.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

… improves InnoDB scalability on read-only workloads, especially when the default glibc… database when using rpm on server upgrade, even if the database…option was set in the [client] section of the my.cnf. Bug fixed #… that caused InnoDB to misclassify internal read operations as synchronous when …

Post: Percona Server for MySQL 5.5.30-30.2 now available

… improves InnoDB scalability on read-only workloads, especially when the default glibc… database when using rpm on server upgrade, even if the database…option was set in the [client] section of the my.cnf. Bug fixed #… that caused InnoDB to misclassify internal read operations as synchronous when …

Post: Replaying database load with Percona Playback

my.cnf configuration so all parameters are set to their default values. We have two servers, PROD and DEV. PROD is the database… identical copy of the data, using DEV as slave of PROD or taking an xtrabackup …Second try, add 2GB of InnoDB Log Files (innodb_log_file_size=1G, innodb_log_files_in_group=2…

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

my.cnf), but I think it’s even worse that the case-sensitivity only matters some of the time. That strikes me asInnoDB table.” The documentation also tells us that we can keep our FT indexes up to date by setting innodb

Post: How to recover a single InnoDB table from a Full Backup

innodb_fast_shutdown=0 and therefore merging all the insert buffers. # innobackupex –defaults-file=/etc/my.cnfset FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries DISCARD TABLESPACE; Copy the salaries.ibd files from the backup to the database

Post: A quest for the full InnoDB status

… several transactions kill the database performance resulting in …innodb-status-file option set in your my.cnf. This will make InnoDB to write the full status output into innodb…/usr/sbin/mysqld –defaults-file=/etc/mysql/my.cnf In my case the…(deleted) The entries are presented as symbolic links from …

Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80

…a tiny startup database server without all …information, please read…] [Optional] Set Percona server to startup …InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES | [...] mysql> SELECT “Hello World!” AS…it in /etc/mysql/my.cnf If you setup…

Post: How Percona does a MySQL Performance Audit

my bearings on the server as a whole, and now I’m ready to see what’s up with the database…. Nov19 ? 1-11:17:30 /usr/libexec/mysqld –defaults-file=/etc/my.cnf –basedir=/usr –datadir=/var/db/mysql –user=mysql …so it’s hard to read. If the InnoDB buffer pool is set to 22GB, it’s much easier to see…

Post: Shard-Query EC2 images available

InnoDB DEFAULT CHARSET=latin1 COMMENT=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; DatabaseInnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb