Databases
Benchmarking Drizzle with MyBench(DBD::drizzle)
With thanks to Patrick Galbraith and his DBD::drizzle 0.200 I am now able to test client benchmarks side by side with MySQL and Drizzle. For simple benchmarking with clients, generally when I have little time, I use a simple Perl framework mybench .
Read moreVerifying MySQL Replication in action
There is a very simple test to show MySQL replication in action and to also better understand the basics of MySQL Replication. With a configured MySQL environment we can run the following test on your MySQL master, and monitor the MySQL slave.
Read moreUsing statpack with SHOW STATUS
Mark Leith, on of the MySQL Support Team managers wrote some time ago a very nice utility I use often called Statpack . My use of Statpack is very simple. Take two snaphots of SHOW GLOBAL STATUS and compare to produce a text based version of the statistics.
Read moreThe value of multi insert values
Baron got a great amount of response from his 50 things to know before migrating Oracle to MySQL . I’m glad I invited him as a fellow MySQL colleague to my presentation to the Federal Government on Best Practices for Migrating to MySQL from Oracle and SQL Server for his inspiration.
Read moreWhat is max_tmp_tables?
Recently I came across another configuration option I’d not heard of before. I profess to not know them all, however I do know when I find something unusual. If you are a beginner DBA, learn what is normal and expected, and identify what is out of the normal, investigate, research and question if necessary.
Read moreWafflecloud with cream
I have been working recently with Matt Yonkovit to get Waffle Grid cloud enabled with Amazon Web Services (AWS) . An initial version of Waffle Grid Cream – Version 0.5 release is now available.
Read moremulti-threaded memcached
I discovered while compiling Wafflegrid today that by default, the Ubuntu binaries for memcached are not-multithreaded. Following the installation of memcached from apt-get and libmemcached I ran memslap for: $ memslap -s localhost Threads connecting to servers 1 Took 1.
Read moreProblems compiling MySQL 5.4
Seem’s the year Sun had for improving MySQL , and with an entire new 5.4 branch the development team could not fix the autoconf and compile dependencies that has been in MySQL for all the years I’ve been compiling MySQL.
Read moreUnderstanding your RAID Configuration
For any production MySQL Database system, running RAID is a given these days. Do you know what RAID your database is? Are you sure? . Ask for quantifiable reproducible output from your systems provider or your System Administrator.
Read moreOSCON 2009 at a discounted rate
OSCON moves this year from Portland to San Jose. As one the community panel for Drizzle: Status, Principles, and Ecosystem I also have a speaker discount which you can combine with O’Reilly having also extended early bird registration until June 23.
Read moreMySQL Book winner – for 5 configuration options
If you had to configure a WordPress MU installation without access to any details of your MySQL Configuration, what would you do? What top five configuration settings would you use?
Read more(Mis)Understanding RAID configuration
Update 8 June 2009 Be sure you to check out some of my research including Understanding your RAID Configuration and Understanding PERC RAID Controllers . Last week I got caught thinking a MySQL production system wasn’t configured with RAID when it actually was.
Read moreLeveraging the power of Twitter
Last week I posted the following twitter request — “Can somebody loan me (or buy me) a Dell 2950 decked out so I can run and publish some benchmarks. Please!”
Read moreFree MySQL Book giveway – Current Progress
I’ve decided to give people two more days for a chance to win a free MySQL Book — Sheeri Cabral’s MySQL Administrators Bible . I have had five people so far provide recommendations for a simple MySQL configuration question as stated in <a href=http://ronaldbradford.
Read more