I would like to remember this day. It was just crazy. Most of my day went into troubleshooting InnoDB locking issues. At this point, the situation is all clear and I am very pleased with the results. Here are two graphs from MySQL Network Monitoring tool:

Keep manageable threads/connections and your server will be very happy.

Just noticed that Planet MySQL has a new layout. Overall, I like the change. The text seems much easier to read. Ads are now gone. For each active contributor, a score is shown. Don't know if the score is number of posts or what? Does anyone care to shed some light?

During my years as a Developer/DBA hearing the words "customizable" or "extensible" always brought a slight smile to my face, particularly when they were used in conjunction with a software sales pitch or evaluation. In fact, more often than not, while presented as product features, these words often really mean, "you can do some additional things with this software if you are willing to invest significant time and resources into doing so". Even today, some of the most popular open source and commercial software solutions provide application programming interfaces (APIs) and plug-ins that are really nothing more than containers that allow you to provide your own code. The goal being to make an off-the-shelf product more applicable to the problems you are attempting to solve without having to write a customized application from scratch.

Having gotten my feet with in regards to BLOBs while developing StuffDawg, I am starting to really see why some many people get eaten by the BLOB (and get spit out too!). The problem, at least that I have found, with BLOBs is that they do not seem to scale well. My experience makes me think that it is not just because of the fact that you are storing binary data in a database, but because of the overhead in the application code for having to deal with them.

For instance, suppose you are storing images in your database, say for a gallery. That is great and all, but how does one display the images in a web-browser? Using the <img src> tag I would assume. This is all well and good, but since the image does not exist on the file-system, you either have to put it there, or need to write a script that pulls the data from the …

The Guide To Understanding mysqlreport has been updated. As many people have noticed, since mysqlreport v3.2, Key Write and Read ratio went away, replaced by Write and Read hit percentage. I figured that “99.87%” was more intuitive than “0.0013″.

Pretty usually in our Perl projects we use third-party modules (CPAN or others) and sometimes we can find a bug in such module. What are our options in such cases? This small article describes some useful hints for Perl developers who have such problems.

(more…)

Now you may not believe me, but there actually are situations when DRBD is not the right choice for meeting your storage needs. Since I’ve been asked to compile some of these and present them here, let’s take a look.

Don’t use DRBD when…

• All or most of your data is static. Front-end web servers are a prime example for this. Even though they usually serve highly dynamic content these days, your PHP documents and Perl scripts and JSP’s usually don’t change that often. Using DRBD for that type of data isn’t much use. Use DRBD for your backend store instead. On the front end, you’ll do fine with rsync, although it …

OK, so I spent a few hours this afternoon cleaning up PlanetMySQL's stylesheets and layout, and fixing some bugs in the code. You'll notice a more streamlined PlanetMySQL now, with the following bug fixes and changes:

• The truncation of entries now works correctly without stripping HTML tags, so that the content does not get all bolded or italicized like it was doing. Thanks to Monte Ohrt's Smarty plugin "truncate_tagsafe"
• Fixed a bug in the "Read More" links for truncated entries so that short entries don't show the Read More link anymore
• The Most Active Authors list is now just the top 30 most active authors and does not include MySQL AB and aggregate feeds. It was getting a little out of control with well over 200 authors...
…

Today I wondered about a really bad performance when running the test-create script from sql-bench on a freshly installed 64-bit OpenSuSE 10.2 system (Linux 2.6.18.8-0.3, MySQL 5.0.26-12). Using the same hardware, running this test on Debian 4.0 (Linux 2.6.18-4-amd64, MySQL 5.0.32-7etch1) performed much better.

I'm not sure why, but replacing the OpenSuSE 10.2 default kernel with a self compiled vanilla kernel fixed the problem. No other changes have been made on the system.
Continue reading "MySQL performance on OpenSuSE"