June 19, 2013

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

… to MySQL 5.6.10, both with default settings using only the InnoDB storage engine.  In my testing I discovered that innodb_old_blocks… built the keys with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket…=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb…

Post: Shard-Query EC2 images available

…,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer… way you can verify the numbers in my next blog post. I will compare performance of various cluster sizes on both storage engines.

Comment: MySQL File System Fragmentation Benchmarks

…insert throughput as in this benchmark. Could you post the my.cnf file used and the computer hardware specs that produced …5.0/Data/” default-character-set=latin1 default-storage-engine=INNODB #default-storage-engine=MyISAM sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION” max…

Comment: When is it a time to upgrade memory ?

… the database latency. To give you more information, this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql… wait_timeout=15 max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set=utf8 default-storage-engine=InnoDB bulk_insert_buffer_size=8M…

Comment: How to start a Percona XtraDB Cluster

here is my.cnf file for my 3 nodes: [mysqld] wsrep_provider=/usr/lib64/libgalera_smm.so …_threads=4 wsrep_sst_method=xtrabackup # default is mysqldump, mysqldump/rsync/xtrabackup binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2…

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

… as possible (e.g. to have the same set of storage engines or default paths): (garfield:~/work) % env VISUAL=/bin/cat mysqlbug | grep…’ ‘–with-ndbcluster’ ‘–with-innodb’ ‘–with-csv-storage-engine‘ ‘–with-archive-storage-engine‘ ‘–with-blackhole-storage-engine‘ ‘–with-example-storage-engine‘ ‘–with-federated-storage-engine‘ ‘–without-bench’ ‘–with-zlib-dir=bundled… enables the logging. If you don’t specify it in my.cnf file, the remaining part of the configuration will not matter…

Post: Copying InnoDB tables between servers

… can just specify table or table by mask: xtrabackup –defaults-file=/etc/my.reg.cnf –backup –tables=tpcc.order_line* –target-dir=/data… to prepare backup, but with special option “export” xtrabackup –defaults-file=/etc/my.reg.cnf –prepare –export –use-memory=8G –target-dir=/data… remote server you have to run MySQL server ® with XtraDB6 storage engine, you can take one of our binary builds with 5…

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

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

Post: What to tune in MySQL Server after installation

… MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how many people fail to provide… global variables. These variables depend on hardware and mix of storage engines, while per session variables are typically workload specific. If you… of sample my.cnf files which may be great templates to use. Typically they would already be much better than defaults if you…