"Some suggestions have been to recreate the tables and indexes using the 64bit binary on the opteron system."
I'm confused - are you running the 32-bit binary, or the 64-bit binary? David ----- Original Message ----- From: "Santiago Flores" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 26, 2003 10:50 AM Subject: Mysql 64 bit vs. Mysql 32bit > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
