… How MySQL 5.6 Makes Query Optimization Easier” for more tips on the 5.6 optimizer[/caption] While preparing the webinar… same “SELECT one_indexed_column” query in MySQL 5.6.10. This turned into a really nice exercise for checking the….6), reducing the executing time by almost 5 times. Pro tip: make sure you always check the Handler status variables for…
Comment: What to tune in MySQL Server after installation
July 23, 2007 By 118 Comments
[...] What to tune in MySQL Server after installation 10 Tips for Optimizing MySQL Queries (That don’t suck) [...]
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… components to give our customers reliable backups? Think about the 10 example outages listed above. Each tool has it’s strong… anywhere with disk space and writes out binlog files sequentially. Tips/Tricks (how we run this): Ensure it stays running, restart… cost effectively store long term backups with little additional work Tips/Tricks: –add-header=x-amz-server-side-encryption:AES256 to…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
… category large portion of table may be scanned to find 10 rows. So index on (category_id, date_created) will be… them for positions. So instead of query with LIMIT 1000,10 you will have WHERE position between 1000 and 1009 which… will be just 5 in this case. Many of the tips I’ve mentioned here work for ORDER BY without LIMIT…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… This time I’d like to share a quick tip on how mk-query-digest allows you to slice…Query_time distribution # 1us # 10us ################################################################ # 100us ######### # 1ms # # 10ms # # 100ms # # 1s ### # 10s+ # 160847 The stats here are aggregated per all queries…
Post: Why you don't want to shard.
August 6, 2009 By 34 Comments
… While the IO system can be improved with a RAID 10 controller w/battery backed write cache, the slave delay problem… users and some servers are overloaded while others are not.(Tip: There are a few famous cases of both (a) bad… is going to be in the course – “XtraDB: The top 10 enhancements”, and in Part 3 “XtraDB: The top…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
… recovery case I worked on yesterday, here’s a quick tip – having a database backup does not mean you can restore…. InnoDB would internally store integers in 4-bytes rather than 10 bytes if it were stored as a sequence of characters… 0x31EB1F9C and ran “bgrep 31EB1F9C /dir” – there were only like 10 other matches across the 4 gigabytes of pages, some of…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…, so it wasn’t load. It was probably crossing a tipping point in the data size, or something like that. It… location. Here’s what I found: # User@Host: webuser[webuser] @ [10.14.82.196] # Thread_id: 3329398998 Schema: app_db # Query… Rows_read: 0 # administrator command: Quit; # User@Host: webuser[webuser] @ [10.14.82.196] # Thread_id: 3329398985 Schema: app_db # Query…
Comment: Speeding up GROUP BY if you want aproximate results
April 9, 2008 By 24 Comments
… crc32(tag) -> ORDER BY count DESC -> LIMIT 10 -> ; +————+——-+————+——————-+ | tag | count | crc32(tag) | BINARY crc32(tag) | +————+——-+————+——————-+ | spanish … will group together. Thanks for the initial tip though, it’s made a 30 …
Post: Amazon Web Services and HP Keynotes at Percona Live MySQL Conference and Expo
February 14, 2013 By 1 Comment
…, successful project, cautionary story, quick tip, or demonstration. Submissions will be reviewed and the top 10 will present during the one-hour…
