MySQL said too many connections
hello. My server uses SunOS dns2 5.7 Generic_106541-02 sun4u sparc SUNW,Ultra-250, and my web server software is APACHE 1.3.20 configured with PHP 4.0.6 which was build with the support of mysql. The mysql server has several databases that are used by several virtual hosts. I have a account having (and have only) the privileges of one of the databases on the mysql server. My site uses this database throught PHP scripts using the account I said above. But my php scripts said too many connections when calling mysql_pconnect in the past days. I know it was caused by the PHP scripts because of not closing the connections. I execute the command show processlist and it printed many rows. I repaired the bug and killed the connections. But, now, the problem still exists, and when I exeute show processlist there were only a few rows. What's the problem? How does mysql limit the connections? Does it limit all the connections to a certain quantity or limit each database seperately? When I execute show processlist, which connections does it shows? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL said too many connections
hello. My server uses SunOS dns2 5.7 Generic_106541-02 sun4u sparc SUNW,Ultra-250, and my web server software is APACHE 1.3.20 configured with PHP 4.0.6 which was build with the support of mysql. The mysql server has several databases that are used by several virtual hosts. I have a account having (and have only) the privileges of one of the databases on the mysql server. My site uses this database throught PHP scripts using the account I said above. But my php scripts said too many connections when calling mysql_pconnect in the past days. I know it was caused by the PHP scripts because of not closing the connections. I execute the command show processlist and it printed many rows. I repaired the bug and killed the connections. But, now, the problem still exists, and when I exeute show processlist there were only a few rows. What's the problem? How does mysql limit the connections? Does it limit all the connections to a certain quantity or limit each database seperately? When I execute show processlist, which connections does it shows? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Error: 1036 (Table 'tblHSBOYArticle_basic' is read only)
Hi. I'm a student from China. I have a problem of MYSQL under Linux. I just installed mysql under RedHat Linux 7.0 and I copyed the files of a database created by mysql under win2000 to /var/lib/mysql/database_name. But when I use the database through PHP, I found the tables are read only. PHP said: MySQL Error: 1036 (Table 'tblHSBOYArticle_basic' is read only) Session halted. I don't know what's wrong with it. I chmod 777, but it does not work yet, then I grant insert,update,delete to the table, it doesn't get better. I used root account and the operation is updating an integer column. What should I do? Save me! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php