… 20M rows 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… files were sized at 4G. The configuration and dataset sizes were chosen, so that the dataset completely fits in memory, and…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
… small row size, containing 1638400 rows. Now lets lock all rows in this table and see how long does it take: mysql> begin… exactly same amount of memory: History list length 5 Total number of lock structs in row lock hash table 6092 LIST OF… of locked rows should take half GB of memory, which is small fraction of memory used on serious systems. Furtermore you would…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…concurrently because Sysbench should run completely in memory and use a lot of CPU …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-socket=/tmp/mysql…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail to start on…-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…Memory ##################################################### Total | 23.59G … Locator Size Speed …MySQL configurations, I didn’t try out different MySQL…size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql…explicit MEMORY tables use in the benchmarks ? As otherwise you also need to boost tmp_table_size to deal with implicit memory tables. innodb_file_per_table…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… 0 @ 2.20GHz Memory: 192GB Storage: Very Fast PCIe Flash Card Filesystem: ext4 Software OS: CentOS 6.3 MySQL Version: 5.6… = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…also need other resources such as network IO or memory to store temporary table, but let us ignore them for a …? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) …0 12.83M 324.99 0 32.65k 0 # Query size 294.90M 14 783 158.14 621.67 149….
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
… join_init_cache(THD *thd,JOIN_TAB *tables,uint table_count) 14185 { … snip … 14268 cache->length=…is the greater of the join_buffer_size or the size that’s been determined to be …memory for each join. If you execute this and nothing bad happens, you might be seeing this bug: http://bugs.mysql…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…-tables-count=16 –num-threads=16 –oltp-table-size=25000000 run Results: Load time for regular tables: 19693 sec, for compressed tables: 38278 sec. Compressed tables… fully in-memory CPU-bound workload. command to run: ./sysbench –test=tests/db/oltp.lua –oltp-tables-count=16 –oltp-table-size=5000000 –oltp-read-only=on –rand-init=on –num-threads=16 –max-requests=0 –rand-type=uniform –max-time=1800 –mysql…
