by Peter Zaitsev | Oct 28, 2006 | Insight for Developers
If you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not – Here is FAQ . I’m to meet the team (Georg, Andrey etc) which will be developing this driver during my visit to Open Source...
by Peter Zaitsev | Oct 26, 2006 | Percona Events
I’ll have two sessions on upcoming OpenSource Database Conference in Frankfurt 6-8 November. One session will be general MySQL Performance Optimization workshop the other will be focused on Innodb architecture and optimization. If you’re visiting this...
by Peter Zaitsev | Oct 16, 2006 | Insight for DBAs
This is interesting question which I thought it would be good to write about. There are obviously benefits and drawbacks for each of methods. Smaller applications usually start with single server which has both MySQL and Web server on it. In this case it is not...
by Peter Zaitsev | Oct 8, 2006 | Insight for Developers
Yesterday I had fun time repairing 1.5Tb ext3 partition, containing many millions of files. Of course it should have never happened – this was decent PowerEdge 2850 box with RAID volume, ECC memory and reliable CentOS 4.4 distribution but still it did. We had...
by Peter Zaitsev | Oct 3, 2006 | Insight for DBAs
Innodb primary key is special in many senses and I was always wondering how well MySQL is integrated with Innodb to take advantage of these special features. Lets see which things work and which things do not: I used the following simple table for tests: CREATE TABLE...
by Peter Zaitsev | Oct 3, 2006 | Insight for DBAs
I’ve written and spoke a lot about using short PRIMARY KEYs with Innodb tables due to the fact all other key will refer to the rows by primary key. I also recommended to use sequential primary keys so you do not end up having random primary key BTREE updates...
by Vadim Tkachenko | Oct 1, 2006 | Percona Software
Taking into account 4.1 tree is still popular and is used on many production servers we decided to make backport of patch to slow-log queries. The patch allows to specify time of slow queries in microseconds and is very helpful in a fight with problematic queries. 4.1...
by Peter Zaitsev | Sep 27, 2006 | Insight for Developers
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...
by Peter Zaitsev | Sep 27, 2006 | Percona Events
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....
by Vadim Tkachenko | Sep 22, 2006 | Uncategorized
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...
by Peter Zaitsev | Sep 22, 2006 | Percona Events
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...
by Peter Zaitsev | Sep 12, 2006 | Insight for Developers
This is a 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...
by Vadim Tkachenko | Sep 9, 2006 | Insight for Developers
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 –...
by Peter Zaitsev | Sep 8, 2006 | Insight for DBAs
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;...
by Vadim Tkachenko | Sep 7, 2006 | Insight for DBAs
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...
by Peter Zaitsev | Sep 6, 2006 | Insight for Developers
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...
by Vadim Tkachenko | Sep 4, 2006 | Percona Events
Starting September I’m leaving MySQL to partner with Peter on practice as well as work with him on some Web projects. I really enjoyed working under Peter’s guidance while working for MySQL and it is great we now can work together as a partners. I thanks...
by Peter Zaitsev | Sep 4, 2006 | Insight for DBAs
I already wrote couple of weeks ago I keep most of my systems on MySQL 4.1 still as they will not benefit from MySQL 5.0 features anyway while I do not want to likely loose a bit of performance and possibly deal with new bugs and changes introduced in MySQL 5.0 (You...
by Vadim Tkachenko | Sep 4, 2006 | Insight for Developers
(There is an updated version of this post here) MySQL has useful extention to the GROUP BY operation: function GROUP_CONCAT: GROUP_CONCAT(expr) – This function returns a string result with the concatenated non-NULL values from a group. Where it can be useful?...
by Peter Zaitsev | Aug 31, 2006 | Insight for Developers
Starting MySQL 4.1, MySQL had support for what is called derived tables, inline views or basically subselects in the from clause. In MySQL 5.0 support for views was added. These features are quite related to each other but how do they compare in terms of performance ?...
