June 19, 2013

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

May 22, 2013 By Leave a Comment

…compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine.  In my testing I discovered that innodb_old…KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_…

Filed Under: Benchmarks, MySQL Tagged With: , , , , , , ,

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

… InnoDB 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-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb-flush-log…

Filed Under: MySQL

Comment: MySQL File System Fragmentation Benchmarks

July 9, 2008 By 28 Comments

… my.cnf file used and the computer hardware specs that produced this benchmark. I am interested in general, innodb, … Files/MySQL/MySQL Server 5.0/” datadir=”C:/Program Files/MySQL/MySQL Server 5.0/Data/” default-character-set=latin1 default-storage-engine=INNODB #default-storage-engine=MyISAM …

Filed Under: Benchmarks Tagged With: ,

Comment: When is it a time to upgrade memory ?

December 9, 2009 By 11 Comments

…information, this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections=600 connect_timeout=30 wait_timeout=15 max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set=utf8 default-storage-engine=InnoDB…

Filed Under: Insight for DBAs Tagged With:

Comment: How to start a Percona XtraDB Cluster

February 28, 2013 By 10 Comments

here is my.cnf file for my 3 nodes: [mysqld] wsrep_provider=/usr/lib64/libgalera_smm.so … binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1 I could run /etc/init.d/mysql start –wsrep…

Filed Under: Percona Software, XtraDB Cluster

Post: Copying InnoDB tables between servers

July 31, 2009 By 11 Comments

… xtrabackup –defaults-file=/etc/my.reg.cnf –backup –tables=tpcc.order_line* –target-dir=/data/vadim/mysql/export/… remote server you have to run MySQL server ® with XtraDB6 storage engine, you can take one … (`ol_supply_w_id`,`ol_i_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Next step is to remove…

Filed Under: Percona Software Tagged With: , , , , ,

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

February 26, 2013 By 1 Comment

…the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was the only storage engine with support…) DEFAULT NULL, `details` text, PRIMARY KEY (`id`), FULLTEXT KEY `full_name` (`full_name`,`details`) ) ENGINE=InnoDB DEFAULT CHARSET…lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: What to tune in MySQL Server after installation

September 29, 2006 By 118 Comments

…default key_buffer_size even with large data set but it will crawl with default innodb_buffer_pool_size. Also Innodb… of storage engines, while …MySQL distribution contains bunch of sample my.cnf files which may be great templates to use. Typically they would already be much better than defaults…

Filed Under: Insight for DBAs Tagged With:

Post: Updated msl (microslow) patch, installation walk-through!

April 20, 2008 By 17 Comments

… same set of storage engines or default paths): (garfield:~/work) …mysql-5.0.51a) % ./configure ‘–disable-shared’ ‘–with-server-suffix=-community’ ‘–without-embedded-server’ ‘–with-ndbcluster’ ‘–with-innodb‘ ‘–with-csv-storage-engine‘ ‘–with-archive-storage-engine…specify it in my.cnf file, the…

Filed Under: Percona Software Tagged With: