… queries which you already looked at using LIKE statement. As default table format for slow_log is CSV with no indexes typical… is possible, with exception of TRUNCATE query. Which just recreates table which should be fast. Interesting enough however what would happen… aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The other handly…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
I mentioned earlier that IO scheduler CFQ coming by default in RedHat / CentOS 5.x may be not so good … user=root default_table_type=MYISAM innodb_buffer_pool_size=3G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb… max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=2048
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache_size = 100M default_table_type = MYISAM log_long_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache_size = 100M default_table_type = MYISAM log_long_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…). my.cnf is [mysqld] user=root binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool…=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_size=64M transaction_isolation=REPEATABLE-READ local-infile=1 At…
Comment: FreeBSD tests
August 4, 2006 By 15 Comments
…=$FSPATH \ –basedir=$BASEPATH \ –max_connections=3000 \ –max_connect_errors=10 \ –table_cache=2048 \ –max_allowed_packet=1M \ –binlog_cache_size=1M…_size=0 \ –ft_min_word_len=4 \ –default_table_type=MYISAM \ –transaction_isolation=REPEATABLE-READ \ –tmp_table_size=64M \ –skip-locking \ –server-id=1…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…DEFAULT NULL, `l_commitDATE` date DEFAULT NULL, `l_receiptDATE` date DEFAULT NULL, `l_shipinstruct` char(25) DEFAULT NULL, `l_shipmode` char(10) DEFAULT… | id | select_type | table | type | possible_keys | key |…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…: SYS_TABLES: CREATE TABLE `SYS_TABLES` ( `NAME` varchar(255) NOT NULL default ”, `ID` bigint(20) unsigned NOT NULL default ’0′, `N_COLS` int(10) default NULL, `TYPE…) unsigned default NULL, `TYPE` int(10) unsigned default NULL, `SPACE` int(10) unsigned default NULL, `PAGE_NO` int(10) unsigned default NULL, PRIMARY KEY (`TABLE_ID…
Comment: COUNT(*) vs COUNT(col)
April 25, 2007 By 45 Comments
…default ’1′, `comment_agent` varchar(255) NOT NULL default ”, `comment_type` varchar(20) NOT NULL default ”, `comment_parent` bigint(20) NOT NULL default… | id | select_type | table | type | possible_keys …
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
… | id | select_type | table | type | possible_keys | key |…DEFAULT ”, `GovernmentForm` char(45) NOT NULL DEFAULT ”, `HeadOfState` char(60) DEFAULT NULL, `Capital` int(11) DEFAULT NULL, `Code2` char(2) NOT NULL DEFAULT…
