Percona's MySQL & InnoDB performance and scalability blog
…MySQL 5.6, MyISAM was the only storage engine…to find out how to make InnoDB FTS blazingly-fast, but simply to get a sense of how it works compared to…to work. First, let’s check …mysql> optimize table dir_test_innodb; +———————-+———-+———-+———-+ | Table | Op | Msg_type | …
… type of queries to …checking query cache for query | 0.000007 | | checking privileges on cached | 0.000003 | | checking permissions | 0.000005 | | sending cached result to…how Active MQ uses MySQL when in HA mode. In HA mode there are two Active MQ servers, both try to… ENGINE=InnoDB; When using MySQL…
…how it would compare to Innodb storage engine – old timer in this space. Does it add choice to… applying to optimizes certain types of queries with MySQL, it is not easy to …to checking number of rows in result set and LIMIT implementation – these can optimized but not by use of MySQL Storage Engine…
…some spinning done, at least for some types of locks where conflicts will be frequent…. is hard to see how small indexes really are. [-] No “using index” Falcon always have to check the… MySQL Storage Engine level for MySQL – reading rows in their physical order can be applied to most storage engines,…
…ENGINE=InnoDB DEFAULT CHARSET=latin1 Please note field SPACE. For table actor it is equal to 15: mysql…_TYPE 2 current defined types…How let’s connect actor.ibd from sakila database taken from some MySQL…To refrain from such error ibdconnect does check if the space_id is already used. It will refuse to…
…to be slower than tables with short rows. I was interested to check… ) ENGINE=MyISAM…mysql [localhost] {msandbox} (test) > explain select max(t1+0) from t99v1; +—-+————-+——-+——-+—————+——+———+——+———-+————-+ | id | select_type | table | type…to how…
…ENGINE=MyISAM Test data has been created with following script (which creates 10M records): mysql_connect(“127.0.0.1″, “root”); mysql…check, how long it’d take if we’ll try to use two separate queries: mysql…
…to satisfy foreign key conditions (have column child table is referencing and have it of proper type and indexed): mysql> set foreign_key_checks…ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> create table parentx(i int) engine… have any better idea how to Hijack innodb Foreign …
… slower because MySQL needs to examine more query plans. The storage engine needs to maintain, calculate … I’m going to explain the different types of duplicate indexes and how to find and remove… performance. Checking the schemas periodically to catch this duplicates can help us to maintain a good…
…typed in by different developers. Supporting different comments is especially important as many application put extra information in the comments to…allowing you to strip comments when checking query… Query Cache Storage Engines MySQL Query Cache now…it hard to understand how exactly MySQL Query Cache …
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.