… to some high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default is 128K. Some people…` ( `grp` int(10) unsigned NOT NULL, `slack` varchar(50) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00 sec…, with 3 runs and averaged results. MySQL 5.1.21-beta was used for tests. mysql> select count(*) from dt2 where slack…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… stored in overflow pages. COMPACT became the default after MySQL 5.0.3 and has a more compact …=BARRACUDA (don’t forget to set it in my.cnf!): SET GLOBAL innodb_file_format=BARRACUDA; One caveat: … a null-operation like this: ALTER TABLE `t1` ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=16; …
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…my tests: computer 1: My.ini [client] port=3306 [mysql] default-character-set=latin1 [mysqld] port=3306 basedir=”C:/Program Files/MySQL/MySQL…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… the limited MySQL command output. First one is that you can have innodb-status-file option set in your my.cnf. This will…). First be sure to run SHOW ENGINE InnoDB STATUS at least once. Then see what MySQL process ID is: garfield ~ # ps ax | grep [m]ysqld 11886 ? Ssl 0:01 /usr/sbin/mysqld –defaults-file=/etc/mysql/my.cnf In my…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
….g. to have the same set of storage engines or default paths): (garfield:~/work) % env VISUAL=/bin/cat mysqlbug…mysql-5.0.51a/ mysql-5.0.51a/bdb/ mysql-5.0.51a/bdb/Makefile.in mysql-5.0.51a/bdb/btree/ mysql…logging. If you don’t specify it in my.cnf file, the remaining part of the configuration will…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_TABLES by default. You were probably caught out because we don’t do it in the server defaults but in the default my.cnf file that we ship. It’s also done by the Windows installer and some of our connectors by default. This… configuration overall. Views are my own. For an official Oracle view, consult a PR person. James Day, MySQL Senior Principal Support Engineer, Oracle
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…you more information, this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections=600 connect_timeout=…timeout=15 max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set=utf8 default-storage-engine=InnoDB bulk_insert_buffer_size=…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… it tries to enter InnoDB. The default value is 500…” What this …mysql> CREATE TABLE test_table ( -> id int -> ) ENGINE=InnoDB; — 0 Tickets Used Query OK, 0 rows affected (0.36 sec) mysql…-time=300 –mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings: innodb…
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 …=4 wsrep_sst_method=xtrabackup # default is mysqldump, mysqldump/rsync/xtrabackup 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…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… table by mask: xtrabackup –defaults-file=/etc/my.reg.cnf –backup –tables=tpcc.order_line* –target-dir=/data/vadim/mysql/export/ xtrabackup: tables regcomp… special option “export” xtrabackup –defaults-file=/etc/my.reg.cnf –prepare –export –use-memory=8G –target-dir=/data/vadim/mysql/export/ xtrabackup Ver 0…_line_2` (`ol_supply_w_id`,`ol_i_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Next step is to remove created .ibd file…
