… columns that you recommend that I remove and that had performance consequences. I join 2 tables to together plus my WHERE… combination in a test environment. Another tip, turn off caching on your testing environment MySQL that way the queries are re-executed… records, you may have better results just by tweaking the MySQL config settings rather than spending time optimizing your queries, especially…
Comment: Do you always need index on WHERE column ?
August 29, 2007 By 17 Comments
[...] is another blog written by MySQL consultants based in Europe. This blog is focussed more on the performance tuning tips for MySQL. Great resource to learn the various settings and variables in MySQL that can be used to [...]
Comment: What to tune in MySQL Server after installation
June 29, 2007 By 118 Comments
… of MySQL… A lot of times i found a LAMP server with the MySQL server poorly configurated.There are a lot of tips, for example enable and tune the query cache, that can enhance the performance of MySQL.Here is a…
Post: Why you don't want to shard.
August 6, 2009 By 34 Comments
…to shard. Optimize everything else first, and then if performance still isn’t good enough, it’s time … busy tables, and move them onto their own MySQL server. Partition-by-function keeps the architecture … some servers are overloaded while others are not.(Tip: There are a few famous cases of both (a…
Comment: How we work on High Performance MySQL Second Edition
November 12, 2007 By 12 Comments
… be reading about something that could give me a huge performance increase only to find the disclaimer at the end that… some of our own tricks both inside and outside of mysql for this purpose such as making clever use of distributed… really deep voodoo with mysql binlogs, but I am hoping the second edition will give a lot more tips for when high…
