I am asking this question as a hosting PROVIDER, not as a hosting client.
The sitation is like this (this is a simple example with small numbers): 1) a client has 100mb quota for site and db files (set on unix group) 2) 80mb is already taken by 75MB database in ONE TABLE and 5mb of files 3) databases gets broken 4) mysql tried to auto repair the table 5) to repair data it must create a temporary file and this files take almost as much as 75MB 6) user goes over quota becauase mysql needs another 75MB to reapir table, and this summs up like 75+75+5 a lot > than 100mb in quota 7) mysql gets stuck on this db 8) people continue to acccess site and connections build up and each connection waits for repair to be finished 9) eventually mysql runs out of connections and this stop other clients too. 10) day is ruined. SO the questions are: 1) Is the way to specify USER/GROUP and PLACE for temporary files for table repair? 2) Maybe there is some OTHER way to set quota for databases? 3) Is there way to specify max number of connections for a user? Current solution for this as i see it is to make a daemon which must connect to database first with administrative privs and monitor number of connections and repairs using processlist. If some user does more than allowed number of connection then just kill them off. If repair accures - then turn off that host for a while and turn if back on again when repair finished. I wonder how it is solved on mass hosting servers. -- Regards, Artem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
