RSS MySQL Performance Blog

http://www.mysqlperformanceblog.com

Everything about MySQL Performance

Last checked about 1 hour ago.

6 people have subscribed to this feed.

Feed frequency

post frequency (last month)

PostRank™ filter

latest 15 posts

« older items




Wednesday November 19th, 2008

1.3
PostRank

The patches are going to Launchpad

From MySQL Performance Blog, 3 hours ago, 0 comments Comment

After some discussions on the OpenSQLCamp 2008 conference we decided to move our development to Launchpad, to be in stream with other MySQL related projects. We published our patches there https://code.launchpad.net/percona-patches, it is supposed to be main repository for the patches. We advise to use Launchpad bug system to report bugs and also for feature requests. [...]

Friday November 14th, 2008

7.0
PostRank

MySQL Binaries percona build7 with latest patches

From MySQL Performance Blog, 5 days ago, 0 comments Comment

We made new binaries for MySQL 5.0.67 build 7 which include patches we recently announced. The -percona release includes: PLAIN TEXT CODE: | innodb_check_defrag.patch                        | Session status to check fragmentation of the last InnoDB scan                            [...]

Thursday November 13th, 2008

5.6
PostRank

Adaptive checkpointing

From MySQL Performance Blog, 6 days ago, 0 comments Comment

Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer pool? One is the limit of “amount”. The other is the limit of “age”. – limit of “amount” – As you know, buffer pool of InnoDB works as write-back cache of its datafiles. If the buffer pool [...]
1.9
PostRank

New SpecJAppServer results at MySQL and Sun.

From MySQL Performance Blog, 6 days ago, 0 comments Comment

As you likely have seen Sun has posted the new SpecJAppServer Results More information from Tom Daly can be found here These results are quite interesting for me as I worked on some of the previous SpecJAppServer Benchmarks several years ago while being employed by MySQL. These are great results, [...]

Wednesday November 12th, 2008

6.8
PostRank

Scaling to 256-way the Sun way

From MySQL Performance Blog, 7 days ago, 0 comments Comment

As you may have recently seen there are some articles about scaling MySQL one 256-way system. I though wow did they really make it work, considering how many bottlenecks remain in MySQL. What article really tells us ? First the number 256 - this is not number of Cores… this is number of hardware threads which [...]
3.0
PostRank

More patches

From MySQL Performance Blog, 7 days ago, 0 comments Comment

After some pause we are going to announce bunch of patches we made and ported for last period. Ported patches (ported from Google V2 patch): - innodb_fsync_source.patch - Show information about callers of fsync, more info - innodb_io_tune.patch - Port of two patches InnodbIOTune and InnodbAsync, more info - innodb_extra_status.patch - Show more information about InnoDB internals [...]

Monday November 10th, 2008

7.9
PostRank

Thoughs on Innodb Incremental Backups

From MySQL Performance Blog, 9 days ago, 0 comments Comment

For normal Innodb “hot” backups we use LVM or other snapshot based technologies with pretty good success. However having incremental backups remain the problem. First why do you need incremental backups at all ? Why not just take the full backups daily. The answer is space - if you want to [...]

Sunday November 9th, 2008

5.6
PostRank

Drilling down to the source of the problem

From MySQL Performance Blog, 10 days ago, 0 comments Comment

I had an interesting tuning case few days ago. The system serving high traffic using Innodb tables would be stalling every so often causing even very simple queries both reads and writes taking long time to complete, with progress almost paused (dropping from thousands to tens of queries per second). On the surface the problem [...]

Friday November 7th, 2008

2.4
PostRank

New Presentations published (Meetup and Highload)

From MySQL Performance Blog, 12 days ago, 0 comments Comment

We have finally found the time to update out presentation pages - we’ve added the presentation on MySQL Scaling by Sharding and Replication as well as Russian Language presentations I’ve given at HighLoad++ conference back in October. Innodb Scalability and New Features (Russian), Scaling MySQL-powered Web Sites by Sharding and Replication (Russian), Wonderful World of MySQL [...]
7.5
PostRank

Poor man’s query logging

From MySQL Performance Blog, 12 days ago, 0 comments Comment

Occasionally there is a need to see what queries reach MySQL. The database provides several ways to share that information with you. One is called general log activated with --log (or --general-log in MySQL 5.1+) start-up parameter. The log writes any query being executed by MySQL to a file with limited amount of additional information. [...]
8.0
PostRank

Living with backups

From MySQL Performance Blog, 12 days ago, 0 comments Comment

Everyone does backups. Usually it’s some nightly batch job that just dumps all MySQL tables into a text file or ordinarily copies the binary files from the data directory to a safe location. Obviously both ways involve much more complex operations than it would seem by my last sentence, but it is not important right [...]

Thursday November 6th, 2008

1.4
PostRank

Election night

From MySQL Performance Blog, 13 days ago, 0 comments Comment

Today was epoch day in American history. Maybe even most important day this year, but it’s not what I’d like to write about here. What does it mean for US citizens and all other people around the world? We know, but what does it mean for us - IT professionals and/or internet portals serving news [...]

Monday November 3rd, 2008

4.4
PostRank

MySQL, AIX5L and malloc()

From MySQL Performance Blog, 15 days ago, 0 comments Comment

Some time ago I get brand new IBM POWER6 server as the replacement for “old” P5 used to host Oracle database. Because we planed to use advanced virtualization with VIOS + LPAR/DLPAR I conceived the idea to use one spare partition for MySQL tests. Because I had no past experience with it and there is [...]

Sunday November 2nd, 2008

2.7
PostRank

OpenSQLCamp is comming close

From MySQL Performance Blog, 17 days ago, 0 comments Comment

OpenSQLCamp is coming close and it is your last change to register. I’m very excited about this event as it looks to be marketing free community gathering, having much fewer attendees but many of them are well known MySQL Professionals. Besides hopefully in depth sessions this promises a lot of good informal chats. Also as [...]

Saturday November 1st, 2008

7.6
PostRank

Yasufumi Kinoshita joins Percona

From MySQL Performance Blog, 18 days ago, 0 comments Comment

I am happy to announce Yasufumi Kinoshita joins our team as Performance Engineer. Yasufumi is known as InnoDB hacking expert, and there is bunch of patches he maid we include in our releases: innodb buffer pool scalability fix, innodb rw_lock fix, control InnoDB IO etc. Actually there is one more patch - “adaptive flush” in InnoDB, [...]

« older items