…MySQL manual, especially the…timeoutblogpercona.commanual locked_in_memoryblogpercona.commanual …lower_case_file_systemblogpercona.commanual lower_case_…levelblogpercona.commanual optimizer_search_depthblogpercona.commanual optimizer…commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
… The MySQL manual doesn’t fall into this trap, but if you search … positioned, which is a worst-case scenario for spinning disks. This … and told you to ignore the ratio and in fact, ignore Key_read_requests altogether…in MySQL to guide your decisions. It is also not the be-all and end-all of MySQL…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… familiar for me to use the example of search engine marketing. I’ll do that throughout this article… database in a little meta-table. Then your script can figure out which files it can ignore…. your application in advance. What about partitioning in MySQL 5.1? I know there are some cases when it …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…, friends, queues, click tracking, search, paginated displays — we’…tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_…ignore. The above process may look like a static recipe that you can just mechanically execute, and in some cases…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
… “binary search” Note …mysql> insert ignore into test2 select * from test where id>250; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> insert ignore…in cases you’ve want to recover deleted rows or dropped table. I should also mention at Percona we offer assistance in MySQL…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… directly from a snapshot (and binary logs for point in time recovery) in case of that ‘Oops’ moment? Let me show you quickly… Position Binlog_Do_DB Binlog_Ignore_DB mysql-bin.000022 336796712 Using the coordinates above, I can start searching for the position of… snapshot now – in case you missed to skip the DROP statement! I know for a fact that for every MySQL restart, the logs…
