My website in these few days has frequently encountered display problem. All the pages cannot be displayed and the following message appeared: ----------------------------------------------------- 1030 - Got error 12 from storage engine select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id [TEP STOP] ----------------------------------------------------- The latest time it appeared was 4 hours ago, the error message lasted for about 15 minutes and then the website worked normal again. However, the error message now reappear again and I don't know when it will become normal! Can anyone give me advice as to what's wrong with the problem? Is it a server side problem or is it due to the corruption of database? Any remedial measure to rectify the problem can be taken? My website is a instant download website of scripts and ebooks, all of the product, payment data are stored in the mysql database. All contribution are welcome. Thanks.
OS error code 12: Cannot allocate memory This probably means you don't have enough memory, or the specified memory settings for MySQL are too high for the configuration of your machine. credit goes to : http://forums.mysql.com/read.php?52,112577,112584#msg-112584
The error message of the page change, now it becomes: --------------------------------------------------- Warning: mysql_connect() [function.mysql-connect]: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /home/mydls2/public_html/includes/functions/database.php on line 12 Unable to connect to database server! ---------------------------------------------------- If this is really the hosting problem, I think I need to change another one. My present hosting is the lunarpages.com with cpanel. Does anyone has good suggestion?
Unless it is your server to increase the memory allowance, you can ask your hosting provider but it may usually will answer that is not possible increase or override the limit for shared hosting accounts, so take the guys' advice and switch to another hosting