Mehlam Shakir, CTO of RippleTech, discusses a practical approach for auditing MySQL databases to meet security and compliance regulations. Hear real-world cases and see a live demonstration of how RippleTech?s Informant solution compliments MySQL by adding a security layer without any performance impact.

For more information on RippleTech?s INFORMANT, visit http://www.rippletech.com/

I have to say, I was a bit worried this would be a typical vendor presentation where every other word is marketing speak for how great the product is. It actually just ended up being ?here?s how Informant works, and here?s how auditing, security and compliance needs can be met,? presented in a way that?s useful and valuable to anyone who is interested in auditing or security. …

Many folks have reported problems with APC in Cool Stack 1.1 resulting in a SEGV in the CoolTools Forums.
The APC version in Cool Stack 1.1 is APC 3.0.11 and if enabled, extensions such as mysql, dtrace etc. fail with a SEGV. Media Wiki doesn't work either.

We have tested APC 3.0.14 and this version seems to work much better and I'm keeping my fingers crossed that it will work for you as well. Our performance testing doesn't show any substantial differences between 3.0.11 and 3.0.14. If you want to give it a try, simply download the correct file for your platform and rename it to apc.so in your php extensions directory …

Many folks have reported problems with APC in Cool Stack 1.1 resulting in a SEGV in the CoolTools Forums.
The APC version in Cool Stack 1.1 is APC 3.0.11 and if enabled, extensions such as mysql, dtrace etc. fail with a SEGV. Media Wiki doesn't work either.

We have tested APC 3.0.14 and this version seems to work much better and I'm keeping my fingers crossed that it will work for you as well. Our performance testing doesn't show any substantial differences between 3.0.11 and 3.0.14. If you want to give it a try, simply download the correct file for your platform and rename it to apc.so in your php extensions directory …

In a talk with Raph Levien today he said:

[basically] “… the metric for the success of an open source software project is whether the author now works at Google.”

… nearly everything I’ve ever written fails to pass this test.

Hopefully someone from Google’s M&A department can help me remedy this situation. (hint hint)

Currently there isn’t a good method to control sending individual queries to the slow query log. Typically this isn’t an issue. It becomes an issue when using very short query times and importing sql files. The slow query log doesn’t have a limit on the length of queries it will write to a log. If you’re importing a sql file with inserts that get sent to the log mysql will dump the entire insert query. This can cause the slow query log to grow to gigs in size in a very short time.

I’ve patched mysql 5.0.41 to add a session variable called sql_log_slow (think sql_log_bin) that when set to 0 will prevent queries from that session from being sent to the slow query log. The patch also updates mysqlbinlog to set that variable in it’s output. One issue with this patch is that the executable comment version in mysqldump is set to 5.0.41 but it will error when imported on any 5.0.41 server that doesn’t have this patch. If it’s merged …

If you haven’t taken the opportunity to book a meeting with me in Singapore yet, I suggest coming to the MySQL Meetup that’s happening there on Thursday. More information at the meetup site, but the key bits are:

When?

Thursday, Jul 5, 2007, 7:00 PM

Where?

Delifrance HARBOURFRONT CENTRE 1 MARITIME SQUARE #01-15 WORLD TRADE CENTRE Singapore

I understand the meetup group has been dormant for a couple of years. It’ll be good to re-jig it. I most likely will be very unreachable via email (though I’m assured that there’s some cool Wireless@SG thing happening in Singapore that will give me Internet access even if the hotel doesn’t), so consider calling +6-012-204-3201.

Technorati Tags: mysql, …

Over the weekend we migrated one of our tables from MyISAM to InnoDB. Generally speaking we’re pretty happy with most of our InnoDB migrations.

InnoDB generally uses 2-3x more data on disk but the write ahead log (WAL) buys us so much more added performance that it’s generally worth the switch.

This migration however was a bit more problematic. Importing the data from mysqldump as MyISAM into the new box only took about 2 hours. Converting the data to InnoDB has so far taken 24 hours and using 21G vs the original 6.1G for MyISAM.

I should also note that it’s not complete yet and it’s 3.5x larger than our original MyISAM install.

Clearly the performance will be worse in our situation for InnoDB because I don’t think the buffer pool efficiency will make the write ahead logging fast enough to beat MyISAM on the same hardware.

We’re not the only people who have …

MySQL AB today announced that its database helps power Qype, the popular German multi-city magazine and review portal. The MySQL database gives Qype users quick and easy access to the addresses and GPS coordinates of places of interest in more than 2,200 cities and towns -- along with user reviews on them.

So I have mentioned the BLOB Streaming Project quite a lot lately, and for good reason! Paul has recently released an alpha version of the engine itself, called MyBS. I took some time last weekend to benchmark it's performance and thought I would share my result. Keep in mind, these are rather crude, but I think they do get the point across.

For the tests I used a slightly modified version StuffDawg since it already stores images inside the database. Oddly enough, I found a few bugs with StuffDawg that I was able to patch up and will be releasing an update soon.

So before I explain things, here is the juicy stuff - the results:

tim@filedawg ~/tmp $ time wget --quiet http://stuffdawg/image.php?itemid=20   

real    0m0.767s
user    0m0.000s
sys     0m0.012s
tim@filedawg ~/tmp $ time wget --quiet …

Sometime in the next six to 12 months a bad guy will use one with its
web interface to trigger a bomb.

I would also place odds that within the next 12 to 24 months, some
kid will hack an alien ship to stop an invasion of earth with an iPhone.

Movies count.

And here you only thought you only read my blog for advice on
databases and hacking right?

Saw the latest Die Hard film today... it was good... but very painful...