Limit MySQL usage
Posted: Wed Feb 16, 2005 3:39 am
Dear,
PHP got limitation : 30s execution time and 8 MBits memory usage but MySQL isn't getting any limitation.
I want to limit MySQL usage in order to ensure my server isn't going to be unstable.
I need to limit query execution time (not to log slow-queries) and number of query per second (per user or global).
Is this possible with MySQL ?
Any other idea appreciated
Best regards,
Kilgore
PHP got limitation : 30s execution time and 8 MBits memory usage but MySQL isn't getting any limitation.
I want to limit MySQL usage in order to ensure my server isn't going to be unstable.
I need to limit query execution time (not to log slow-queries) and number of query per second (per user or global).
Is this possible with MySQL ?
Any other idea appreciated
Best regards,
Kilgore