By JortK on January 23, 2010
So you get MySQL or other applications using too much memory on the box or OS behaving funny and using more memory for cache and pushing application to the swap. This causes swapping and causes performance problems. This much is obvious. But how bad is it ? Should you count it same as normal Disk [...]
Posted in MySQL | Tagged MySQL, performance, swap
By JortK on January 21, 2010
Read the complete article on the MySQL Performance Blog
Posted in MySQL | Tagged backup, compress, innodb, MySQL
By JortK on January 18, 2010
Posted in MySQL | Tagged connect, MySQL, ssh, tunnel
By JortK on January 9, 2010
Some great articles on how to improve the performance of your MySQL Server: Optimize slow queries with mk-query-digest Use delayed flushing table_cache negative scalability How innodb_open_files affect performance Use of table_cache Thanks to MySQLPerformanceblog.com!
Posted in MySQL | Tagged flushing, innodb, MySQL, performance, sql
By JortK on November 28, 2009
Just came across this great article with 20 best practices when using MySQL: MySQL best practices. Be sure to check them, the following items are in the article: Optimize Your Queries For the Query Cache LIMIT 1 When Getting a Unique Row Get Suggestions with PROCEDURE ANALYSE() Prepared Statements Split the Big DELETE or INSERT [...]
Posted in MySQL | Tagged best practices, cache, database, db, MySQL, query, select, show
By JortK on December 22, 2008
Because I’m running a project which has a relative large database (tables with 70.000.000 records in them), I wanted to know which was faster in performance, MyISAM or InnoDB. Currently I’m using MyISAM, and I’m running into some performance and stability issues. First, I’ve created a table with a few columns:
Posted in MySQL | Tagged benchmark, database, innodb, myisam, MySQL, performance, sql, storage engines
By JortK on December 11, 2008
We all know about cron, an easy way to schedule certain processes, like truncating your log tables in your MySQL database every week. With MySQL 5.1 the guys at MySQL introduced a new cool feature: The MySQL Event Scheduler ! With the Event Scheduler you can schedule tasks that you want to perform on your database. [...]
Posted in MySQL | Tagged cron, database, event scheduler, MySQL, scheduler
By JortK on December 10, 2008
Sometimes it can be useful to put data in a temporary tables, it is really a way to speed up large and heavy queries. You can create a temp table in MySQL with the following syntax: CREATE TEMPORARY TABLE `TestTempTable` ( testcolumn INT NOT NULL) Now you can fill the temporary table with everything you [...]
Posted in MySQL | Tagged howto, MySQL, tables, temp, tutorial
By JortK on August 31, 2008
Today I was playing around with some MySQL statements, because I ran into a problem that I wanted to list my database tables. I found out about the MySQL SHOW statements, and I’ve found out that they can be very usefull! That why I will describe some of the usefull ways to use the SHOW [...]
Posted in MySQL, Uncategorized | Tagged How to, MySQL, show
By JortK on July 23, 2008
Today I was making some queries on a database with a lot of records. The table I was making the query on had 25.000.000 records. The performance of the query I’ve made was terrible, the structure was as follows (fake column names used): SELECT * FROM t_posts WHERE id IN (SELECT id FROM t_topics WHERE [...]
Posted in MySQL | Tagged exists, in, MySQL, performance, query