Interviewing people for our Job Openings I like to ask them a basic question - if you have a server with 16GB of RAM which will be dedicated for MySQL with large Innodb database using typical Web workload what settings you would adjust and interestingly enough most people fail to come up with anything reasonable. So I decided to publish the answer I would like to hear extending it with basics of Hardware OS And Application optimization.I call this Innodb Performance Optimization Basics so these are general guidelines which work well for wide range of applications, though the optimal settings of course depend on the workload.

{mos_sb_discuss:27} One of the first things I tried to do in Rails was to figure out how to make a nice, generic website that anyone could update. After about sixteen iterations I’ve finally stumbled on one that I think will finally work.

{mos_sb_discuss:27} Anyone who’s spent more than 5 minutes on the MySQL documentation will realise it leaves a lot to be desired.  The same goes for many of the 3rd party apps latched onto this platform which offer mediocre functionality and anything beyind the basic comes at a huge premium. Well here’s a set of 20 resources, tools, articles that hope to break that and bring it all under one roof.  Enjoy.

{mos_sb_discuss:27} If you’ve ever wished you could see MySQL’s EXPLAIN output formatted as a tree, now you can. MySQL Visual Explain transforms EXPLAIN output into a hierarchical view of the query plan, which is significantly easier to read and understand.

To be honest I’m not a big fan of Stored Procedures, At least not in the form they are currently implemented in MySQL 5.0

In this short video tutorial you will learn on how to create a database, execute a command under the Mysql monitor. Understand how syntax and queries are working with the database, see the effect of the rows and columns.  

{mos_sb_discuss:27} "Ha," an email from a colleague started, "I think you can finally admit that MySQL is ready to compete with the big boys!" I rolled my eyes and let out a skeptical "uh huh." His email continued, "Check out Version 5. They now have views, stored procedures, and triggers."

{mos_sb_discuss:27} Sounds harder than it is–especially when reading the official docs. Frankly you just got synchronize two DBs, tell the one (”master”) to write a log and the other (”slave”) to read it. In detail it looks like the following:

{mos_sb_discuss:27}  Most server administrators know that the MySQL relational data base management system (RDBMS) is a highly flexible piece of software and comes with a wide range of startup options that can be used to modify its behavior. What most don't know, however, is that the standard MySQL client comes with an equally large number of startup options, some of which are extremely useful in daily MySQL interaction. While these options are not "secret" per se, they remain largely unused, even though they can significantly ease the process of server interaction.

{mos_sb_discuss:27} Database backups can be made in two ways: by copying the data directory directly (eithermanually or by means of the mysqlhotcopy  script on Unix) or by using the mysqldump  tool to write out a SQL file that will replicate your database.