About two weeks ago, I posted a message describing the outcome of our upgrade from a late 7.3 to 7.5.0.8. Following the upgrade, database performance dropped to 10-50% of what we had previously achieved on the same hardware and OS. I modified the cache settings and tried the COROUTINES, but was unable to resolve the problem. I ran the analyzer and checked the kernel logs, but the engine seems unaware that performance has actually changed.
Last weekend, we rebuilt the instance from scratch as version 7.5.0.8, and used ODBC and loadercli DATALOAD statements to repopulate the tables. Performance was fine--until yesterday. The problem has suddenly reappeared, and db performance is at a crawl. In 2 years of using 7.3, we never had a problem like this.
I have run out of ideas on how to fix this. My superiors are pressuring me to return us to 7.3. Does anyone have any ideas whatsoever about what I should do?
Platform: dual Pentium 3 running SuSE Linux 8.0.
-- Mark Thomas United Drugs
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
