June 18, 2013

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table_size…

Filed Under: Insight for Developers Tagged With:

Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit

November 24, 2011 By 2 Comments

… what kind of goodies does Helgrind find on MySQL server. Let’s take a… is 0 bytes inside a block of size 800000 alloc’d ==9090==    at 0x4C28FDF: …table_state) (sql_show.cc:6238) ==9090==    by 0x6A5E0C: JOIN::exec() (sql_select.cc:1863) ==9090==    by 0x6A7D72: mysql_select(THD*, Item***, TABLE…

Filed Under: MySQL

Post: Researching your MySQL table sizes

March 17, 2008 By 28 Comments

… sizes so here it goes: Find total number of tables, rows, total data in index size for given MySQL Instance SELECT count(*) tables, concat(round(sum(table…; +——–+——————–+——-+——-+——-+————+———+ | tables | table_schema | rows | data | idx | total_size | idxfrac | +——–+——————–+——-+——-+——-+————+———+ | 48 | cacti | 0.01M | 0.00G | 0.00G | 0.00G | 0.72 | | 17 | mysql | 0…

Filed Under: Insight for DBAs Tagged With: , ,

Post: MySQL Server Memory Usage

May 17, 2006 By 21 Comments

… as full table scans, sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size of memory… chunk at once others, for example tmp_table_size is rather maximum amount of memory MySQL will allocate for this operation. Note it… to changing various variables. For example you may find out increasing sort_buffer_size from 1MB to 4MB and 1000 max_connections…

Filed Under: Insight for DBAs Tagged With: , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…: mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_myisam_stopword Create Table: CREATE TABLE `innodb_… this record but InnoDB cannot find it at all? I suspect that … set innodb_ft_min_token_size to 4. Thus, when InnoDB …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: High-Performance Click Analysis with MySQL

December 22, 2008 By 13 Comments

…the blue_clicks column record only blue clicks; to find out non-blue clicks you subtract one from …size. You have to write a little more complex queries, but that’s often justified by a large reduction in table size… work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, …

Filed Under: Insight for Developers Tagged With: , , , ,

Post: Find unused indexes

June 30, 2012 By Leave a Comment

…mysql. After some runs we can start to analyze the information on INDEX_STATISTICS table. mysql> SELECT * FROM INDEX_STATISTICS; +————–+————+————–+———–+ | TABLE_SCHEMA | TABLE…similar data estructure and size. Conclusion We’ve learnt how to find unused indexes using …

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…my 5.6 instance is 128MB – smaller than the size of my DIR data. So, with all of …rebuild the table. -rw-rw—-. 1 mysql mysql 98304 Feb 20 18:57 FTS_0000000000000025_ADDED.ibd -rw-rw—-. 1 mysql mysql 98304…other I_S tables, I do find that the number of rows in I_S.innodb_ft_index_table is changing,…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

… ./worker >> /dev/null 2>&1 < /dev/null done; Where to find the images Amazon ID Name Arch Notesami-20b74949 shard-query…-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-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…

Filed Under: MySQL

Post: Aligning IO on a hard disk RAID – the Benchmarks

June 9, 2011 By 13 Comments

…, not different MySQL configurations, I didn’t try out different MySQL versions or …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… from proper alignment. You can find scripts and plain data here on…

Filed Under: MySQL
« Older Posts
Newer Posts »