Re: speed of 3.23 vs 4.1 for logging server - Gary Richardson - com.mysql.lists.mysql

2 messages in com.mysql.lists.mysqlRe: speed of 3.23 vs 4.1 for logging ...

From	Sent On	Attachments
Florin Andrei	29 Mar 2005 11:48
Gary Richardson	29 Mar 2005 22:56

Subject:	Re: speed of 3.23 vs 4.1 for logging server
From:	Gary Richardson (gary...@gmail.com)
Date:	03/29/2005 10:56:32 PM
List:	com.mysql.lists.mysql

The RPM's from mysql.com should work fine on FC3. The source RPMs should build as well. I would say it shouldn't take that much effort.

I don't know about performance issues, but I always figured that you can tune InnoDB with a bit more control than myisam. For inserts, you could probably have a larger memory pool and a longer time between changelog commits, but you should probably benchmark. You'd want to use the newer versions for that, I'd assume.

Plus, with MyISAM, your odd SELECT queries will lock the tables, preventing inserts. If your queries run for more than 15 seconds, that may affect a logging server..

just some thoughts..

On Tue, 29 Mar 2005 11:48:56 -0800, Florin Andrei <flor...@gmail.com> wrote:

Fedora Core 3, which is the Linux distribution that i'm using, is still shipping with 3.23.58 The beta (test) version of Fedora 4 has mysql-4.1.10. However, FC4 is scheduled to go live on June 6th. But i need a MySQL server now.

This server will be mostly used for logging (think: syslog logging to SQL), so most of the time will just receive INSERTs on a permanent basis from a couple of sources, to a few tables (just a handful, all of them in two databases) that will be rotated periodically (all tables will be append-only - when they're too big, they're just rotated away and the very old ones are deleted when disk usage hits a threshold). Every now and then, a user or two will perform searches through the logs.

Is there a big performance difference between 3.23 and 4.1 in such a case? I prefer to just use whatever's offered in the current distribution because i don't have much time to spend tweaking the system (upgrade MySQL, recompile PHP, verify SELinux policies, etc.), but if there is a really big performance difference, i may do the effort to upgrade MySQL to the one offered in FC4-test.

http://florin.myip.org/