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/
2 messages in com.mysql.lists.mysqlspeed of 3.23 vs 4.1 for logging server
