Hi David,
I was checking on how google is indexing my pages and noticed that my site is generating this Error messge : User trioglo_price has already more than 'max_user_connections' active connections in
is there a way I could increase max_user_connections to avoid this Error message ?
Thanks
Robert,
Hi David,
Since I have full access to my server I wanted to ask you what is the location of this file my.ini ?
Thanks,
Robert
Hi David,
I have tried to use this comand Locate my.ini but it did not return any results
Thanks,
Robert
Hi Robert,
On a Linux server the global settings are /etc/my.ini - however it might not exist in which case you simply need to create it with the content shown above...
Cheers,
David.
MySQL shouldn't just crash when deleting a table...!
I presume you are trying:
DROP TABLE links;
...and then MySQL crashes at that point? Do you get a specific error message at all?
Cheers,
David.
Hi David,
When I use this query delete from links; while using mysql admin everything goes to a halt and all mysites generate this error message
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/trioglo/public_html/includes/database.php on line 26
What I dont seem to understand is why this doesnt happen when I de-register a feed or import feeds.
Thanks,
Robert
Hi David,
Something else I forgot is this only happens if the table has so many records.
Thanks,
Robert
Hello Robert,
A better way to empty large tables is to use TRUNCATE - try:
TRUNCATE links;Cheers,
David.
Hi Robert,
This is a MySQL configuration variable to prevent overloading of the database server on mutli-user hosting environments. If you have full access to your hosting account then you should be able to reconfigure MySQL, as follows in your my.ini file:
[mysqld]max_user_connections 0
The [mysqld] section should already exist, and there is probably already a value for max_user_connections. Setting it to zero will remove the limit. Don't forget to restart MySQL after making the change.
If you are in a shared hosting environment; it may be worth contacting your host to request additional resources for your account. It _shouldn't_ be an effect of crawling because none of the big search engines make parallel queries to the same host (for this very reason) so it might also be worth looking into any other scripts that may be running on the server and might not be freeing resources...
Cheers,
David.