… information about how Shard-Query will perform on each database. To do the…_row_length: 241 Data_length: 1616904192 Max_data_length: 0 Index_length: 539279360…tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a cluster from 1 to…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…once others, for example tmp_table_size is rather maximum amount of memory MySQL will allocate for …like to see. Monitor how the value changes so you know memory requirements with current settings and…increasing sort_buffer_size from 1MB to 4MB and 1000 max_connections increases peak memory …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table…how to align files properly. 4. Partition table and file system properly aligned; sunit/swidth set…
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 –max…
Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
December 19, 2012 By Leave a Comment
…how to proceed. The first step to be able to analyze your GRA files is to add a binlog header to…MySQL replication log [root@node2 mysql]# mysqlbinlog -vvv GRA_3_3-bin.log /*!40019 SET @@session.max_insert_delayed_threads=0*/; /*!50003 SET…Table_map: `sakila`.`actor` mapped to…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
…. The questions I tried to answer are how much slower 5.6…tmp/mysql_sandbox5610.sock –mysql-user=msandbox_rw –mysql-password=msandbox –oltp-table-size=1000000 –num-threads=1 –oltp-read-only=on –init-rng=on –max…MySQL Sandbox sets explicitly but yet this is likely course of action for many MySQL…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…mysql> SHOW PROFILE; +——————————+————+ | Status | Duration | +——————————+————+ . . . | copy to tmp table | 184.694432 | . . . +——————————+————+ 18 rows in set (0.00 sec) mysql> SET…Max…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…MySQL Server. set userstat_running=1 and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql…Tmp_table # 0% (4k) Tmp_table_on_disk There is a lot of interesting you can find out from this header but in relation to…
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-socket=/tmp/mysql…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…tables‘, ’102′ ‘Com_update’, ’15146253′ ‘Com_update_multi’, ’0′ ‘Connections’, ’263413′ ‘Created_tmp_disk_tables‘, ’0′ ‘Created_tmp_files’, ’4001′ ‘Created_tmp_tables…mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max…
