Re: Grant permissions problems - help
Hi Nestor. What does the mysql_error() report as the exact error message? This could help you identify what kind of access control issue it is. Alternatively, you could try running the same query from the command line (using the mysql client) and see if you get the same error. Also, I'm not really sure about this feature, but it has helped me once or twice: trace mode. In PHP, you can do ini_set('mysql.trace_mode','on'); and there might be a way to do this also with the mysql client Best, George. George Webb [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Number of MySQL children ?
Would someone please explain how to set the number of child mysqld processes which start when mysql (mysql-standard-4.0.14-pc-linux-i686) starts up? I am using MySQL on a memory-poor (32MB RAM) machine, and MySQL seems to hog about 10MB per child process, and there are ten (10) of them at startup. All this, and usually there is only one or two active connections. So I was thinking more like two (2) child processes would be better, but I can't seem to change it from the default (ten (10)). BTW, I experimented with the server parameters (http://www.mysql.com/doc/en/Server_parameters.html), but still there are at least ten (10) mysqld child process always running. Thanks for your help! George Webb [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]