May 21, 2013

Percona welcomes Ewen Fortune and Piotr Biel

October 1, 2008 By 5 Comments

Although we haven’t announced any new members in a while, the Percona team has continued to grow steadily behind the scenes. Our hiring policy is to have a few months’ provisional period to ensure the…, of course. Ewen has been a consultant and contractor before joining Percona, and has many years of experience in Oracle, MySQL, Unix systems ….

Piotr Biel lives in Poland, quite close to our other Polish team member (Maciek Dobrzanski). In his past as a system architect he … can do!

Ewen and Piotr, a very warm welcome to the Percona team from all of us, and we are so glad to …

Filed Under: Events and Announcements Tagged With:

Beware of MyISAM Key Cache mutex contention

August 12, 2008 By 10 Comments

Today I was working with the client loading data to MyISAM tables at very high rate. Hundreds of millions rows are loaded daily into single MySQL instance with bursts up to 100K of records/sec which need to be inserted (in the table with few indexes). It was good not all records had to go to [...]

Filed Under: Insight for DBAs Tagged With: ,

How adding another table to JOIN can improve performance ?

August 1, 2008 By 12 Comments

JOINs are expensive and it most typical the fewer tables (for the same database) you join the better performance you will get. As for any rules there are however exceptions The one I’m speaking about comes from the issue with MySQL optimizer stopping using further index key parts as soon as there is a range [...]

Filed Under: Insight for Developers Tagged With: ,

Missing Data – rows used to generate result set

July 20, 2008 By 15 Comments

As Baron writes it is not the number of rows returned by the query but number of rows accessed by the query will most likely be defining query performance. Of course not all row accessed are created equal (such as full table scan row accesses may be much faster than random index lookups row accesses [...]

Filed Under: Insight for Developers Tagged With:

MySQL extensions for hosting

April 24, 2008 By 11 Comments

A few weeks ago I was asked to isolate some functionalities from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table accounting to the database, accessible with a new set of commands such as SHOW TABLE_STATISTICS, SHOW INDEX_STATISTICS and SHOW USER_STATISTICS. The first two can interest anyone to periodically check what data [...]

Filed Under: Percona Software Tagged With:

Innodb Performance Optimization Basics

November 1, 2007 By 75 Comments

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. [...]

Filed Under: Insight for DBAs Tagged With:

Is it query which needs to be optimized ?

March 6, 2007 By 9 Comments

Last few days I had a lot of a lot of questions at MySQL Performance Forum as well as from our customers regarding query optimization… which had one thing in common – It is not query which needed to be optimized. Way too frequently people design schema first and then think how the queries they [...]

Filed Under: Insight for Developers Tagged With:

Database problems in MySQL/PHP Applications

August 11, 2006 By 13 Comments

Article about database design problems is being discussed by Kristian. Both article itself and responce cause mixed feellings so I decided it is worth commenting: 1. Using mysql_* functions directly This is probably bad but I do not like solutions proposed by original article ether. PEAR is slow as well as other complex conectors. I [...]

Filed Under: Insight for Developers Tagged With: , ,

MySQL EXPLAIN limits and errors.

July 24, 2006 By 6 Comments

Running EXPLAIN for problematic queries is very powerful tool for MySQL Performance optimization. If you’ve been using this tool a lot you probably noticed it is not always provide adequate information. Here is list of things you may wish to watch out. EXPLAIN can be wrong – this does not happen very often but it [...]

Filed Under: Insight for Developers Tagged With: ,

Why MySQL could be slow with large tables ?

June 9, 2006 By 141 Comments

If you’ve been reading enough database related forums, mailing lists or blogs you probably heard complains about MySQL being unable to handle more than 1.000.000 (or select any other number) rows by some of the users. On other hand it is well known with customers like Google, Yahoo, LiveJournal,Technocarati MySQL has installations with many billions [...]

Filed Under: Insight for DBAs Tagged With: ,
« Older Posts
Newer Posts »