General
multi-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 moreMore Basic MySQL Security
The reason for yesterday’s Basic OS/MySQL Security was a request to review a system and I was given the production server ‘root’ password in an email. Never email a ‘root’ password, especially including the hostname as well.
Read moreFor MySQL DBA fame and glory. Prize included.
I came across the following configuration today on a Production MySQL system (5.0.67) running 30+ blogs using WordPress MU . $ cat /etc/my.cnf [mysqld] set-variable = max_connections=500 safe-show-database No I did not truncate the output.
Read moreBasic OS/MySQL Security
If you can do either of these on your MySQL production server, you need to correct immediately. 1. Login directly to your MySQL server as the ‘root’ Linux Operating System user.
Read moreTranscending Technology Specific Boundaries
I had the pleasure to sit on the Performance Panel at the recent Percona Performance Conference . While the panel contained a number of usual MySQL suspects, one person was not familiar, that being Cary Millsap from Method R .
Read moreSHOW WARNINGS woes
Recently on a client site I had to fight the pain of having no way to confirm loss of data integrity when optimizing data types. Due to MySQL’s ability to perform silent conversion of data, when converting a number of columns we enabled sql_mode to catch any truncations as errors.
Read moreThe MySQL crystal ball says …
As the recipient of the 2009 MySQL Community Member of the Year award I received a MySQL crystal ball. While it looks good in my bookcase, unfortunately the best advice I can offer during this time of uncertainty is “watch this space”.
Read more