Percona's MySQL & InnoDB performance and scalability blog
…a whole, and now I’m ready to see what’s up with the database. The first step is to find…a bunch of other things I’ll look at, including checking for default users in the mysql.* tables, running mk-duplicate-key-checker to find…
…of 5-10 minutes. To understand things affecting recovery time you better to understand how Innodb recovery works. When Innodb recovers from logs it finds…of log files as Innodb needs to flush database pages to the tablespace before it can overwrite matching log records in…
…a ;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 16403 n bits 72 index `PRIMARY` of table…of previous statements. For complex deadlock investigations you might need to look at the log files to find…in this case database pages will not be equal to total size of…
…of values. You can put these into the database in a little meta-table…to handle this now. You can have the clicks column record the total, and the blue_clicks column record only blue clicks; to find…
…of commodity no one has something like it. Q35: I believe this is a somewhat trivial question, but it’s hard to find a good answer to…table on a separate computer, maybe a replication slave. Can you make the reorganization run in a…
…to find out how to make InnoDB FTS blazingly-fast, but simply to get a sense of how it works compared to traditional MyISAM FTS. We’ll get to performance in…
…tables ? In a lot of cases you have to guess and test, you can’t get information of how…to find the cause in most cases. It is not as straightforward as it should be and I’m very hopeful future releases of…
…how to align files properly. 4. Partition table and file system properly aligned; sunit/swidth set during mkfs. No…a difference here and improves performance up to 15% in case of 8 threads running concurrently. Because the customer was running a database…
…to your friendly consultant, or do any of a number of other things. Decoupling things is very helpful sometimes. Let’s see how to…in the report because it matches –limit. # pct total…DATABASES sets the “no index used” flag, did you? Now we both do! This is just a brief introduction to…
…find it later, plus it is quite handy in a way it presents information: SELECT CONCAT(table_schema, ‘.’, table_name), CONCAT(ROUND(table…to the query so it works whatever database you have active. It does not work with MySQL before 5.0 still of…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.