I already wrote about Sysbench and MySQL tunning scripts. Those articles can be found HERE and HERE. Now lets do some tests and lets see the dependance from write cache …
Category: MySQL
Test your sql skills online
Very nice 5 questions quiz about SQL performance http://use-the-index-luke.com/3-minute-test/
MySQL Performance – Howto – part 1 (high performance tuning scripts)
Often the server admin has little control over the applications which uses MySQL and it is hard to find the bottlenecks. This blog post can’t bring the peace in the …
MySQL – Update one table from another
If you need to update one table with information from another table, you can use next query. UPDATE sourceTable s, destTable d SET d.something = s.something WHERE d.fieldId = s.idUPDATE …
Reducing ibdata1 – howto
One of the biggest mistakes you can make with MySQL is to leave its default configuration. It will work, but not as it should. For example, default MySQL installation (5.0x) …
Manual MySQL update on RHEL/CentOS
If you’re using RH based distros, you’ll probably notice that their habbit is to keep the same software versions in one release. For example, if you need PHP on CentOS …
MySQL Workbench
MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project. MySQL Workbench will be available as a …
HowTo recover MySQL root password
By default, MySQL Server will be installed with root superuser without any password. You can connect to MySQL server as root without requiring password or by keying in blank password. …
SysBench on CentOS – HowTo
If you want to test server performance, you can think about SysBench. SysBench is a modular, cross-platform and multi-threaded benchmark tool for evaluating OS parameters that are important for a …
Basic MySQL operations I
In this post, I will present few basic commands for MySQL administration. You’ll see how to create a database, create user, assign a database for specific user, etc. First I …