On 17.06.11 09:48, Carlos Andrés Gallego Arboleda wrote:
Any comments about the administration of de DB on MySQL whit MyISAM or InnoDB. which of these are the best option?
We have a DB more big than 4.1 GB and the application turn more slow.
I'd say that at least the sessions table is worth converting to innodb. fot others, you can turn on logging of slow queries and see which queries are waiting for locks and which tables they do use. Then you can convert those tables to innodb. note that fulltext searches do not work in innodb so the article table should remain as myisam. -- Matus UHLAR - fantomas, uhlar@fantomas.sk ; http://www.fantomas.sk/ Warning: I wish NOT to receive e-mail advertising to this address. Varovanie: na tuto adresu chcem NEDOSTAVAT akukolvek reklamnu postu. I feel like I'm diagonally parked in a parallel universe.