September 2006 - MySQL Performance Blog

What to tune in MySQL Server after installation

September 29, 2006 By Peter Zaitsev 118 Comments

My favorite question during Interview for people to work as MySQL DBAs or be involved with MySQL Performance in some way is to ask them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised how many people fail to provide any reasonable answer to this [...]

Filed Under: Insight for DBAs Tagged With: Tips

APC or Memcached

September 27, 2006 By Peter Zaitsev 23 Comments

A while back I did Cache Performance Comparison for LAMP Stack. Looking at this data you can see memcached is about 5 times as slow as APC, and this is with tests done on localhost – with network difference is going to be larger, even with fastest network. Such latency can add up especially if [...]

Filed Under: Insight for Developers Tagged With: LAMP

Life Beyond MySQL

September 27, 2006 By Peter Zaitsev 3 Comments

When I was leaving MySQL I wrote I will be doing some Web projects on my own, besides doing MySQL Consulting. I think some people thought I am just using that as an excuse and really I will only do consulting. So I’m pretty happy to announce my first project. NNSEEK Is NewsGroup search engine, [...]

Filed Under: Events and Announcements Tagged With: About This Blog

Test Drive of Solid

September 22, 2006 By Vadim Tkachenko 5 Comments

Not so long ago Solid released solidDB for MySQL Beta 3 so I decided now is time to take a bit closer look on new transactional engine for MySQL. While my far goal is the performance and scalability testing before I wanted to look at basic transactional properties such as deadlock detection, select for update [...]

Filed Under: Uncategorized Tagged With: Bugs, InnoDB

EuroOSCON 2006 – High Performance FullText Search

September 22, 2006 By Peter Zaitsev 4 Comments

I’m now back from EuroOSCON 2006 which was the reason I was not posting for a while. Pretty interesting event, even though it looks like it is getting less geeky compared to OSCON in US I visited two years ago – a lot of presentations now shifted to philosophical, political and business issues. I however [...]

Filed Under: Events and Announcements Tagged With: Conferences, FullText Search

Database access Optimization in Web Applications.

September 12, 2006 By Peter Zaitsev 10 Comments

This is pretty simple approach I often use called to optimize web application performance if problem happens with few pages. If we have “everything is slow” problem looking at slow query logs may be better start. So what could you do ? Look at the information shown on the page which comes from database. This [...]

Filed Under: Insight for Developers Tagged With: Tips

Alternatives of PHP ?

September 9, 2006 By Vadim Tkachenko 28 Comments

When I loaded GigaBytes of XMLs into mysql database with PHP script, I was thinking about PHP alternatives. Why do I need that ? 1. PHP is slow – I’m speaking about area of data processing and implementation of algorithms 2. No good cli debugger – I’m just tired of debugging with ‘echo’ and ‘var_dump’ [...]

Filed Under: Insight for Developers Tagged With: Tools

Why Index could refuse to work ?

September 8, 2006 By Peter Zaitsev 15 Comments

Have you ever seen index which refused to be used even if there is every reason for it to work (from the glance view):

mysql> explain select * from article where article_id=10;
+----+-------------+---------+------+---------------+------+---------+------+-------+-------------+
| id | select_type | table   | type | possible_keys | key  | key_len | ref  | rows  | Extra       |
+----+-------------+---------+------+---------------+------+---------+------+-------+-------------+
|  1 | SIMPLE      | article | ALL  | PRIMARY       | NULL | NULL    | NULL | 93490 | Using where |
+----+-------------+---------+------+---------------+------+---------+------+-------+-------------+
1 row in set (0.00 sec)

mysql> explain select * from article where article_id=10;

+----+-------------+---------+------+---------------+------+---------+------+-------+-------------+

+----+-------------+---------+------+---------------+------+---------+------+-------+-------------+

+----+-------------+---------+------+---------------+------+---------+------+-------+-------------+

1 row in set (0.00 sec)

Why on the earth index would not be used you would think, even if MySQL is mentioning it in “possible keys” ? Should you try to force it ?

Filed Under: Insight for DBAs Tagged With: Tips

Internals of InnoDB mutexes

September 7, 2006 By Vadim Tkachenko 4 Comments

InnoDB uses its own mutexes and read-write locks instead of POSIX-mutexes pthread_mutex*, the main reason for that is performance, but InnoDB’s implementation isn’t ideal and on modern SMP boxes can cause serious performance problems. Let’s look on InnoDB mutex (schematic for simplification):

Filed Under: Insight for DBAs Tagged With: InnoDB, Patches

Wrong GROUP BY makes your queries fragile

September 6, 2006 By Peter Zaitsev 7 Comments

This is probably well known issue for everyone having some MySQL experience or experience with any other SQL database. Still I see this problem in many production applications so it is worth to mention it, especially as it is connected to MySQL Performance. No it might not affect MySQL Performance per say but it limits [...]

Filed Under: Insight for Developers Tagged With: Production, Tips

What to tune in MySQL Server after installation

APC or Memcached

Life Beyond MySQL

Test Drive of Solid

EuroOSCON 2006 – High Performance FullText Search

Database access Optimization in Web Applications.

Alternatives of PHP ?

Why Index could refuse to work ?

Internals of InnoDB mutexes

Wrong GROUP BY makes your queries fragile

Search

Top Searches

Percona Webinars

ABOUT PERCONA

Percona MySQL Training

Percona Careers

SOFTWARE FROM PERCONA

SERVICES FOR MYSQL USERS

ABOUT THIS BLOG AND PERCONA