Hi, A lot of times slow MySQL response can be due to MySQL's default behaviour which tries to do DNS hostname lookups. Turn this off (and make sure you're using static IP addresses in your setup) and it often helps.
In your my.cnf (usually /etc/mysql/my.cnf) add: [mysqld] skip-name-resolve You can also check your query cache sizes, make sure the cache is turned on and you've got a decent amount of cache memory allocated. I don't know if switching your tables to Myisam would help or not, I do recall that there is at least one table that doesn't cooperate well with Innodb. I've always used Myisam. Have a look at: http://www.debuntu.org/how-to-optimize-mysql-response-time/ for some tips on the name resolve / cache stuff. Hope this helps. Lorne Tyndale > Hi guys, > > I am still desperately looking for a Solution for my speed problem of sql 5.5. > > If I would alter All Tables to myisam -as it used to be prior 5.5- > Will this increase access/operation speed of rivendell/mysql ? > > Regards > Peter _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
