I’m reading the guide, but I’m still too busy with my work to read it proficiently. In order to pass the exam I have to read it again focusing all the details.

But, after reading the first 6 chapters (more then 50% of the entire book) I found the guide useful and simply understandable … and, thanks to lulu.com, it seems to me to be cheapest.
Well done authors!!!

This integrates with Monolith, but the database update function can be stripped out for use without Monolith. The idea is that this script is a wrapper for mysqldump that does backup file consistency checking, email reporting, file based logging and directory pruning.

I used to have one script for daily, weekly, and monthly all running out of /etc/cron.daily /etc/cron.weekly /etc/cron.monthly - respectively. But maintaining 3 scripts is foolish if one can do everything. So I added some variables to check day of week and day of month to achieve this.

Enjoy the code. Script Link here.

Some people might have noticed that Workbench runs very slowly and flickers a lot in their machines. Other people will be able to work without noticing any significant sluggishness with the diagram graphics. The difference is because Workbench’s custom canvas may use hardware accelerated OpenGL graphics or non-accelerated software rendering, depending on the system (ie, whether or not a 3D accelerated graphics card is available or not). We were expecting that the most reasonably recent machines (maybe 5 years old or less) would have at least some basic graphics acceleration, but for some reason, that seems to not always be the case. Apparently, some people that have decent systems with ATI or Intel cards seem to get the fallback software rendered canvas, which will result in sluggish graphics.

We are still not sure why Cairo/Glitz (the underlying graphics library used by our drawing …

Just read about the potential performance implications of having thousands of tables in a single MySQL database over at Ask Bjørn Hansen’s blog.

We have that type of setup at Alert Logic, but I don’t remember any problems while shutting down the database server. I wonder if the FLUSH TABLES problem only happens that badly under MyISAM instead of InnoDB?

I never liked how build in Wordpress search works. it shows full documents rather than snippets it does not search comments and it does not have any query language so I always used Google search if I wanted to find something on MySQL Performance Blog.

Today we have published new search functionality for our site which is based on Sphinx. We have developed it as WordPress plugin which will be available as open source software in a few weeks - just want to test it a bit more and write proper documentation before announcing. If you would like to test it however let us know.

As you can see search functionality allows you to specify what would you like to search (Posts, Pages or Comments) as well as if you would like to sort results be relevance of freshness. You can also use query standard Sphinx query language to search phrases or …

connector/odbc 5.1.2 was released today. this will probably be the last beta. we have gone back and triaged all of the bugs filed against connector/odbc, and have identified a few bugs that we have to fix before we will release a release candidate, but overall the trend of bugs is very encouraging. there are only a handful of bugs filed specifically against 5.1, and the total number of connector/odbc bugs is down to under 60.

So far so good. I have a bit over two hundred RSS entries logged in the database for testing purposes. Today I changed the table structure for for the title and description to support longer entries. Here is the pertinent code.

Add feed function:

function add_feed($item,$site_id) {
$each_title = $item['title'];
$each_link = $item['link'];
$each_desc = $item['description'];
if(isset($item['guid'])) { $each_guid = $item['guid'];} else { $each_guid="";}
if(isset($item['pubDate'])) { $each_pubDate = $item['pubDate'];} else { $each_pubDate="";}
//print "\n$each_desc\n";
$sql2=sprintf("
INSERT INTO `extrabigassfries`.`feed_items` (
`id` ,
`rss_site_id` ,
`item_title` ,
`item_link` ,
`item_description` ,
`item_guid` ,
`item_pubDate` ,
`Creation_time`
)
VALUES (
NULL , …