Conditional joins in MySQL
One way to do a “Conditional Join” in MySQL is by using a “LEFT JOIN”. Create a “LEFT JOIN” for each condition and combine the results into one column using an “IF” statement by the “SELECT” expression
Monitoring your MySQL errors
Great tutorial on how to monitor your MySQL Server for errors.
New OLAP Wikistat benchmark: Introduction and call for feedbacks
Article about a new benchmark.
How to use MySQL cluster
MySQL Cluster can be used as a general purpose transactional storage engine, but if you convert all your InnoDB tables to it and connect your application straight to it you may not see the performance you were hoping for. This is because MySQL Cluster was originally designed for real-time telecommunications applications (such as RADIUS servers). It has slowly been modified to become more general purpose and improvements are being made every day but there are still some performance considerations which go with this. In some cases tweaking your schema and/or queries can help performance dramatically, so I shall try and outline some of things to watch for here.
innodb_file_per_table, shrinking table spaces and the data dictionary
INNODB has some irritating gotchas that makes disk space management hard. In 2002ish INNODB, added innodb_file_per_table to get around allot of these issues, but it does not fix everything.
10x Performance Improvements in MySQL – A Case Study
Slideshow with tips on how to improve the performance of your MySQL server
SHOW TEMPORARY TABLES
I had this patch for a while where one can get listing of both session and global temporary tables across all sessions. It really helped lot of times to understand the bottlenecks of some of the temporary table issues as MySQL never exposed them in the form of SHOW TABLES.
Fun with Table Functions
Great tricks on how to use table functions.
Join on overlapping date ranges
Query example how to join data with overlapping date ranges.
Beware of implicit casting
Ever so often a query provides a “bad” execution plan. Adding a missing index can many times solve the problem. However, not everything can be solved with an index. I wish to highlight the point of having an implicit cast, which negates the use of an index on MySQL.
What is CHECK TABLE doing with InnoDB tables?
Find out in this article what CHECK TABLE is doing with InnoDB table.
Related posts:
- Great tips to improve your MySQL performance Some great articles on how to improve the performance of...
- The 20 best practices when using MySQL Just came across this great article with 20 best practices...
- The reason why swapping is bad for MySQL performance So you get MySQL or other applications using too much...
- A MySQL mojo leaves Oracle Ever since Oracle closed on its acquisition of MySQL, the...
- How to compress your InnoDB Backup Read the complete article on the MySQL Performance Blog Playing...
Related posts brought to you by Yet Another Related Posts Plugin.
[...] here to see the original: 11 MySQL resources you must read! Share and [...]