…’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about…-table-size=1000000 –rand-init=on –report-interval=1 –rand-type=uniform –forced-shutdown=1 –max-time=120 –max-requests=0 –percentile=99 –mysql-user…-table-size=1000000 –rand-init=on –report-interval=1 –rand-type=uniform –forced-shutdown=1 –max-time=120 –max-requests=0 –percentile=99 –mysql-user…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…for all of the benchmarks on both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL used was…-table-size=10000000 –rand-init=on –report-interval=1 –rand-type=pareto \ –forced-shutdown=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… is faster, but you should look into the steady decline of InnoDB throughput. Eventually it will drop to the level 14000… –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-requests=0…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…), size of the buffer pool is the same – 30GB. So now we explore the IO-bound scenario. Percona Server 5.5 outperforms MySQL… innodb_log_buffer_size=128M innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table innodb_read_io_threads…_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
…, mysql tunning script gives below results for temp table , server has 4G ram, which almost uses, as many sites of both…max_heap_table_size & tmp_table_size) , what values you experts are recomended ? TEMP TABLES Current max_heap_table_size = 128 M Current tmp_table_size = 128 M Of 21559 temp tables,…
Post: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
January 19, 2007 By 17 Comments
… table size and avoid mix-up of tmp_table_size and max_heap_table_size ChangeSet@1.2358, 2007-01-03 14:45:26+03:00, ted@ted.mysql.internal +7 -0 BUG #4291: max_heap_table_size affects creation of disk-based temporary table fix: the new system variable memory_tmp_table_size is…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
…of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot of…of the first 500 max_connections + 1 for every 20 max_connections over 500, capped at 2000 Same thing. What number of max…per_table =1 Great! We found it is better choice in 95%+ of installations innodb_log_file_size …
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… grow up to max_packet_size per connection) are all connection buffers and so if you close connection MySQL can clean them up… MEMORY tables you can create both as permanent and temporary. There is a max_heap_table_size variable which allows you to limit size of MEMORY tables… it should be and I’m very hopeful future releases of MySQL, MariaDB or Drizzle bring improvements in this space allowing us…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
…MySQL configuration, we quite often want to know how various buffer sizes are used. This matters because some buffers (sort_buffer_size…max size” and the corresponding buffers are allocated only as big as needed (key_buffer_size). There are many examples of…,JOIN_TAB *tables,uint table_count) 14185 { …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…instances of MySQL on the same files in the data directory, and refusing to shut down MySQL…-table-checksum tool from Percona Toolkit can generate table checksums, and the pmp-check-pt-table-…makes it difficult to handle max_connections problems (the use of fixed-size connection pooling, for example,…
