The other day I was watching a Memcached Webinar (”Memcached for MySQL: Advanced Use Cases”) sponsored by MySQL, and it got me thinking about memcached from an operational perspective. It seems to me that the implementation patterns for memcached are fairly well codified in the standard body of knowledge. What does NOT appear to be [...]
Jul
06
2008
Jul
06
2008
It looks like I never blogged about it but I'm going to be speaking on OSCON 2008. Similar to the last year presentation I'll do overview of MySQL Open Source storage engines. I'll do brief overview of different storage engines available out there as well as share benchmark results for some of them.
Entry posted by peter | One comment
[Read more]
Jul
06
2008
Consider these scenarios:
1. You need to test some new configurations in your my.cnf and
you need to reboot MySQL.
2. You want to run some benchmarking on your database.
3. You want to try some new replication ideas that involves
creating new replication structure, stopping the slaves, doing
failovers, or any ideas related to replication.
And, most importantly, you want to do all of the above without
disturbing your production databases.
Answer:
MySQL Sandbox. A lot of people have written about this gem but
until you have use it, you will not realize how simple and yet
valuable this tool is.
Jul
05
2008
When we use a relational database system, we should know some important things. Numeric data type is very essential for a table. Here I describe some important points of Numeric Data type in MySQL:
MySQL has 9 numeric data types
- Integer: TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT
- Floating Point: FLOAT, DOUBLE
- Fixed Point: DECIMAL
- Other: BIT, (ENUM maybe)
Some poor design:
- INT(1)
- BIGINT AUTO_INCREMENT
- no UNSIGNED used
- DECIMAL(31,0)
INT(1) – 1 does not mean 1 digit. (1) represents client output display format only. INT is 4 Bytes. TINYINT is 1 Byte …
[Read more]
Jul
05
2008
When dealing with replicated setups with two or more slaves sharing a master, it appears as if a lot of people overlook the obvious. You don't need to take your master down to resync a slave. I was hoping I wouldn't need to post about this, but I see people taking down their masters when they have perfectly healthy slaves way too often to let it slip.
Jul
05
2008
|
Over the last months I have seen some impressive presentations about Open Solaris, and I wanted to give it a try. The live CD provided with opensolaris 2008.05 is very easy to install, and so I set it up in a virtual machine. The environment looks familiar for a seasoned Linux user, and thus I decided to use it as a test bed for my MySQL Sandbox, which includes a test suite that lets you run a complete test with little effort. |
|
|
Well, little effort for you, maybe, but not for the operating system. The test puts a lot of stress on the … |
Jul
04
2008
So, how does one gather statistics on indexes? With InnoDB it’s one thing, with MyISAM it’s another thing. This post however, will focus on MyISAM. There are various ways, each having their own drawbacks and positive sides.
What about ANALYZE TABLE? It’s great — very fast in
InnoDB. But with MyISAM a lock occurs while scanning the table.
OPTIMIZE TABLE? Still relatively quick with MyISAM,
unless the table in question is huge. InnoDB requires an
ALTER TABLE — it might take forever, depending on
the server configuration, as OPTIMIZE TABLE for
InnoDB maps to a ALTER TABLE tableName ENGINE=InnoDB
We all know how ANALYZE TABLE, REPAIR
TABLE, and OPTIMIZE TABLE work with MyISAM.
However, there’s a less explored way, for MyISAM — the
myisam_stats_method.
…
[Read more]
Jul
04
2008
.jpg){kind=link}
My copy of High Performance MySQL arrived this week! It's also Independance Day here in the States, so I have a long weekend after all the fireworks to get through my stack of reading, plus get some hill rides in to prepare for a 200K brevet July 19th. Oh, tomorrow also starts the Tour de France! What a weekend!!
MySQL DBA & Programming Blog by Mark Schoonover …
[Read more]
Jul
04
2008
My copy of High Performance MySQL arrived this week! It's also Independance Day here in the States, so I have a long weekend after all the fireworks to get through my stack of reading, plus get some hill rides in to prepare for a 200K brevet July 19th. Oh, tomorrow also starts the Tour de France! What a weekend!!
MySQL DBA & Programming Blog by Mark Schoonover …
[Read more]
Jul
04
2008
Andrew Clarke has published to 104th edition of Log Buffer, the weekly review of database blogs, on Radio Free Tooting, marking LB’s second year. Happy Birthday, LB!
Log Buffer always needs editors, so if you you’d like to present your view of the week that was in DB blogs, contact me, the Log Buffer coordinator. You’ll be joining some of the best bloggers around, and making yourself and your blog a little better known to readers around the world.
And now, here’s Andrew Clarke’s …
[Read more]