… used to hold the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed… bitmap file name could stop the server starting if the innodb_data_home_dir variable didn’t have the path separator at… bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… than InnoDB. Like the queries in Flight #3 that are faster using MyISAM, Q4.3 examines very little data. It seems that InnoDB…/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb…=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… bitmap file name could stop the server starting if the innodb_data_home_dir variable didn’t have the path separator at… used to hold the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed… occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… work best with InnoDB, with MyISAM you’ll have to start the snapshot while holding a “flush tables with read lock” and the flush operation will take some time to complete. Compression ZFS can compress data on the fly… a drive, instead of crashing InnoDB, it will be caught by ZFS and the data will be read from the other drive in…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves. …you’re not that familiar with, I’d suggest reading over the manual’s description of how replication …-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap …
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…most, and which are candidates for dropping (why keep old data if you don’t need to?). I get up … unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A` ( `id` int(…? Feel free to answer via the comments. Thanks for reading!
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_file… #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…=3306 innodb_status_file=0 innodb_data_file_path=ibdata1:100M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log…innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb_read_io_threads = 8 innodb…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… here is the basic approach: data = fetchCache(key) if (data) { return data } data = callExpensiveFunction(params) storeCache(data, key) return data Memcached is a very popular (…there are no reads from disk. However, there is write activity stemming from the fact that this is using InnoDB under the…
