mysql performance issue. pls help..

2009-11-17 Thread F.A.I.Z.A.L
HI experts I am facing performance issue for last couple of months. it taking more time to execute query.. developers created tables on myIsam and Innodb. i have a doubts whether we can use both storage same time.. i have 2 thinks in my minds to check this performance. 1. to check innodb and

Re: mysql performance issue. pls help..

2009-11-17 Thread F.A.I.Z.A.L
hi all this is my innodb preference. i need to change anything for increasing the db performance.. innodb_additional_mem_pool_size -- 1048576 innodb_autoextend_increment -- 8 innodb_buffer_pool_awe_mem_mb -- 0 innodb_buffer_pool_size -- 8388608 innodb_checksums-- ON