Hello. We recently aquired a dual Opteron system to run mysql on. We were previously using a dual Athlon MP system. We have encountered the following issue. We have a script that updates records in some rather large tables. This script runs more slowly on the opteron system than on the athlon system. The database was created on the athlon system an moved over. No tables or indexes were recreated. When benchmarking the two systems the opteron is much faster than the athlon system. This does not seem to carry over to our updates.
Ideas? We have already (and are still open to more) tweaked my.cnf from the my-huge.cnf included in the Opteron binary from mysql.com (this is theirs, we haven't recompiled). We are running on SUSE8.2 for opteron. The opteron has 4GB of memory whereas the athlon had only 2GB. The tables are both on RAID5 on similar LSI controllers. The newer controller actually has better performance. Our my.cnf is included below. Any ideas on fixing this one? We really need this update query to run as quickly as it did on the athlon (at the very least). Some suggestions have been to recreate the tables and indexes using the 64bit binary on the opteron system. As this will take a while, would it have an effect? Anyone? I appreciate any comments, any direction. Thanks, Santiago
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
