Entries for MySQL Performance Blog – Page 1 of 2 »
Feb 28

Why you should ignore MySQL’s key cache hit ratio #

rated

I have not caused a fist fight in a while, so it's time to take off the gloves.

Jan 21

When should you store serialized objects in the database? #

rated

A while back Friendfeed posted a blog post explaining how they changed from storing data in MySQL columns to serializing data and just storing it...

Dec 13

Battle around MySQL heats up #

rated

As the deadline for EC to decide if Oracle can acquire Sun and hence MySQL is coming up the tensions seems to heat up.

Dec 4

Effect of adaptive_flushing #

rated
[db01-checkpt-age-1d]

I recently had the chance to witness the effects of innodb_adaptive_flushing on the performance of InnoDB Plugin 1.0.5 in the wild, which Yasufumi wrote about...


Oct 19

MySQL-Memcached or NOSQL Tokyo Tyrant – part 3 #

rated
[Tyrant -vs- memcached]

This is part 3 of our series.  In part 1 we talked about boosting performance with memcached on top of MySQL, in Part 2 we...


Oct 16

MySQL-Memcached or NOSQL Tokyo Tyrant – part 2 #

rated
[Benchmarks if everything is in memcached]

Part 1 of our series set-up our "test"  application and looked at boosting performance of the application by buffer MySQL with memcached.  Our test application...


Oct 15

MySQL-Memcached or NOSQL Tokyo Tyrant – part 1 #

rated
[DB Fits into Memory]

All to often people force themselves into using a database like MySQL with no thought into whether if its the best solution to there problem.


Oct 2

Analyzing air traffic performance with InfoBright and MonetDB #

rated

Accidentally me and Baron played with InfoBright (see http://www.mysqlperformanceblog.com/2009/09/29/quick-comparison-of-myisam-infobright-and-monetdb/) this week.

Sep 12

3 ways MySQL uses indexes #

rated

I often see people confuse different ways MySQL can use indexing, getting wrong ideas on what query performance they should expect.

Aug 29

Give me 8 hours, and I’ll help you build a better application #

rated

I have run into a number of cases recently that all had a similar look and feel.

Aug 27

Looking at Redis #

rated

Recently I had a chance to take a look at Redis project, which is semi-persistent in memory database with idea somethat similar to memcache but...

Aug 3

XtraDB has been commited to MariaDB #

rated

If you do not follow MariaDB development, I want to head up XtraDB has been commited to MariaDB server and will be included in binary...

Jul 20

XtraDB storage engine release 1.0.3-6 #

rated

Dear community, Today we are pleased to announce release 6 of XtraDB – the result of 2 months hard work.

Jul 13

Three key things to know about moving MySQL into the cloud. #

rated

This question “what problems will I have when migrating to the cloud” gets asked often enough.

Jul 7

Improving InnoDB recovery time #

rated

Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see: http://bugs.mysql.com/bug.php?id=29847 http://dammit.lt/2008/10/26/innodb-crash-recovery/ This is problem when your InnoDB crashes,...

Entries for MySQL Performance Blog – Page 1 of 2 »

HexLex tracks and indexes the most recent, relevant content of interest to software professionals. These are the top sites and entries for the past 30 days.

Copyright © Attribyte, LLC. All rights reserved. All entries and images © original authors | Terms of Use