Category Archives: 5 minute dba

Speaking in Chicago on Tuesday September 28th

I wanted to drop a quick note and let everyone know I am going to be speaking at an IOUG event on 9/28/2010 in Downtown Chicago. I will be targeting DBA’s, Developers, and users who want to know more about … Continue reading

Posted in 5 minute dba, mysql | Comments Off on Speaking in Chicago on Tuesday September 28th

Great to see everyone at the UC

It was awesome to see everyone at the 2010 mysql UC. Sorry if I did not get a chance to chat with everyone, time just flew by! I had great turn out for my two sessions and had a lot … Continue reading

Posted in 5 minute dba, Matt, mysql | Comments Off on Great to see everyone at the UC

A few key Tokyo Cabinet Notes

I wanted to publish a few interesting gotcha’s , facts, and settings people who use or want to use Tokyo Cabinet/Tyrant should know. A quick overview, Tokyo Tyrant is the network daemon that sits ontop of Tokyo Cabinet. This means … Continue reading

Posted in 5 minute dba, NOSQL, Tokyo | Comments Off on A few key Tokyo Cabinet Notes

5 Minute DBA MyISAM Example Config Files

I have been asked this numerous times ever since I posted my InnoDB sample configuration files, Do I have sample configuration parameters for a MyISAM setup? We are seeing less and less people use MyISAM, but it is still popular … Continue reading

Posted in 5 minute dba, Matt, mysql | 4 Comments

Be Wary of Large Log File Sizes

As some people have mentioned here and here Increasing the innodb log file size can lead to nice increases in performance. This is a trick we often deploy with clients so their is not anything really new here. However their … Continue reading

Posted in 5 minute dba, Common Mistakes, Matt, mysql, performance | 1 Comment

5 Minute DBA – Database Server Hardware Selection

So you need to purchase a new database server, and you really don’t know where to start.. Because their maybe different recommendations for different OS’s I am going to stick with Linux with these recommendations. I want to say right … Continue reading

Posted in 5 minute dba, mysql | 3 Comments

5 Minute Linux Admin/DBA – What OS tools to use to monitor your database server

A very special 5 minute DBA post here, we are crossing over… sys admin & dba oh my! I tend to always look first at the OS, and then move over to looking at what is going on inside the … Continue reading

Posted in 5 minute dba, linux, mysql | 3 Comments

The 5 minute DBA: Storage Engine Selection

I was soooo tempted to post a 1 word post on this, just posting “Innodb”. It would be very easy, and its the advice that I am going to give in the end anyways. After all we need to get … Continue reading

Posted in 5 minute dba, mysql | 1 Comment

The 5 minute DBA: Default My.cnf File

Because I was asked….What should I set my my.cnf parameters to? What are good default values? How much memory should I allocate to the db if I have X amount of ram? What is a good starting point for the … Continue reading

Posted in 5 minute dba, mysql, performance | 7 Comments

The Five Minute DBA: Fix your slow database – my.cnf parameters

I thought I would write a few blog posts on what I am calling the 5 minute DBA. The content of these is  interesting or frequently asked questions that I get when out on a gig, you know those ones … Continue reading

Posted in 5 minute dba, mysql, performance | 9 Comments