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 <[EMAIL PROTECTED]> 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. > > -- > Florin Andrei > > http://florin.myip.org/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
