…_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group…=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… sysbench –num-threads=32 –test=tests/db/oltp.lua –oltp_tables_count=32 \ –oltp-table-size=10000000 –rand-init=on –report-…run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G …
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… difference. However…. 1. If you have uneven reads across the DB (most appearing in one section …latest writes etc ), it will… to read from a partitioned table, as, depending on the size of the partitions, the whole partition can be cached, as… Mysql can fire off one thread per partition (at least I have seen this happen in a MyIsam environment on similar sized…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just …Com_admin_commandsblogpercona.commanual Com_alter_dbblogpercona.commanual Com_alter_db_upgradeblogpercona.commanual Com_alter_eventblogpercona.commanual Com_alter_functionblogpercona….
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…=mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql-password=msandbox –mysql…=mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_big –oltp-table-size=17600000 –mysql-user=msandbox –mysql-password=msandbox –mysql…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… captured with the ‘tee’ command. $ cat one.ini [default] user=mysql db=ontime_one password= port=5029 column=date_id mapper=hash…, performance can be improved significantly: $ cat shards.ini [default] user=mysql db=ontime password= port=5029 column=date_id mapper=hash gearman….Year); The performance of the following queries depends on the size of the date range: — Q8.0 SELECT dest.CityName, COUNT…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections but yet MySQL… Buffer pool size 7864319 Buffer pool size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old database pages 3046376 Modified db pages 23419…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… table: sysbench –test=oltp –oltp-table-size=20000000 –mysql-table-engine=innodb –mysql-socket=/tmp/mysql_sandbox5524.sock –mysql-db=test –oltp-table-name=sbtest_20m… 5.5.23 DROP TABLE implementation is MySQL 5.5.15, the version of MySQL used for benchmarking the new DROP TABLE… or as pronounced as compared to MySQL. Conclusion The new DROP TABLE related fixes in MySQL >= 5.5.23 have certainly reduced…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
There is a lot of discussions whenever running MySQL storing data on NFS is a good idea. There is … today using Sysbench: sysbench –test=oltp –oltp-table-size=10000000 –db-driver=mysql –mysql-user=root –mysql-db=sbsmall –init-rng=1 –max-requests=100000000 –max… number, though it mainly was because of contention issues in MySQL 5.0 rather than any NAS issues. This number was…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… key significantly fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with primary… only those portions of them which are accessed frequently. The size of this “working set” can greatly depend on application and… everything itself. Especially when using a CMS where DB structure is prepdefined A: MySQL Server will not automatically define any indexes for…
