MySQL tuning

Hi all, I have a MySQL server with 1.7 GB of RAM, Some of the tables in my database use MyISAM and others use InnoDB Do you think the following mysql configurations are Ok? or should I change something? innodb_buffer_pool_size =712M innodb_additional_mem_pool_size =20M innodb_log_buffer_size =8

Growing database & Performance

I have a website where my database is continuously growing. And I started being worried about performance. I have a couple of questions, and I would appreciate it very much if you can elaborate on them. - I have about 70 tables in the same database.  some of them are becoming very large (over 1

mysql_num_rows

Dear All I have a problem with mysql_num_rows if I execute it on a result returned by mysql_query,,, and that result is empty then I will get an error saying that this result is not a valid mysql result I am using count(*) and checking if my SQL statements will return more than 0

mysql_num_rows

Dear All I have a problem with mysql_num_rows if I execute it on a result returned by mysql_query,,, and that result is empty then I will get an error saying that this result is not a valid mysql result,,, but i think it should return ZERO! I am using count(*) and checking if my