…mysql> SHOW PROFILE; +——————————+————+ | Status | Duration | +——————————+————+ . . . | copy to tmp table | 184.694432 | . . . +——————————+————+ 18 rows in set (0.00 sec) mysql…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…/tmp/constitution.txt | sed -e’s/ /n/g’ > words I am going to perform…the entire set multiple times. mysql> load data infile ‘/tmp/words’ into table words (chars); Query…a degree. mysql> select min(id),max(id) from words; +———+———+ | min(id) | max(id) | +———+———+ | 1 | 3088896 …
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…rows are the worst case for performance. Optimal mathematical performance requires operations on reduced sets. Keep… speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s …_tmp_74082863` GROUP BY 1 –POST EXEC: DROP TABLE IF EXISTS `aggregation_tmp#74082863` ; Edit *MIN/MAX …
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…replication to perform system optimization,…mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql… ______ # total min max avg 95% …) Full_scan # 0% (10k) Tmp_table # 0% (4k) Tmp_table_…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… key_buffer=750M join_buffer=10M max_heap_table_size=50M tmp_table_size=64M max_allowed_packet=16M table_cache=1800 record_buffer=10M sort_buffer_size=24M read_buffer_size=9M max… solved it for us. Sorry for mentioning this on a mysql performance blog. I think what you have to say here on…
Comment: MySQL Performance on Memory Appliance
February 11, 2009 By 23 Comments
… –max-requests=100000 –test=oltp –mysql-table-engine=innodb –oltp-table-size=1000000 –mysql-socket=/tmp/mysql.sock –mysql-db=test –mysql-user=root –mysql-password=… 100000 Threads started! Done. OLTP test statistics: queries performed: read: 1400014 write: 500005 other: 200002 total: 2100021 …
Post: read_buffer_size can break your replication
June 6, 2012 By 12 Comments
…DATA INFILE: MasterA (test) > LOAD DATA INFILE ‘/tmp/data’ INTO TABLE t; Query OK, 4510080 rows affected (26…max_allowed_packet; Increase max_allowed_packet on master; the first event ‘mysql-bin.000002′ at 74416925, the last event read from ‘./mysql… read_buffer_size will not increase your performance…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
…max_connections=255 query_cache_size=8M table_cache=510 tmp_table_size=13M thread_cache_size=12 myisam_max_sort_file_size=100G myisam_max…tables: 1 Open tables: 64 Queries per second avg: 1.615 ————– Please suggest me how to increase the performance…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… I tested MySQL-5…max_allowed_packet=1M max_connections=3000 max_heap_table_size=64M max_prepared_stmt_count=1000000 query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp_table… of performance drop…
Comment: What to tune in MySQL Server after installation
June 29, 2009 By 118 Comments
Please Anyone suggest me how to increase the performance of my MYSQL server. Day by day the number of slow queries are… Flush tables: 1 Open tables: 64 Queries per second avg: 1.615 max_connections=255 query_cache_size=8M table_cache=510 tmp_table_size=13M thread_cache_size=12 myisam_max_sort_file_size=100G myisam_max…
