rajmohan Posted January 30, 2009 Share Posted January 30, 2009 Hi All, I am having one table which is having more then 100 millions of records... I have written a query like this.. for example.. SELECT COUNT(*) FROM tbl_name where user_id='XXXX' (The use of this query is to count how many hit happen by this users. ) When I execute this query it crashes my database.. please help me. Now I need a very best solution to solve this problem.. Quote Link to comment Share on other sites More sharing options...
landavia Posted January 30, 2009 Share Posted January 30, 2009 it seem your table are corrupt i would suggest you to repair.. but before worse happen.. try copy your table 1st then repair the table.. better create backup or lost data. Quote Link to comment Share on other sites More sharing options...
rajmohan Posted January 30, 2009 Author Share Posted January 30, 2009 How to find whether the table is corrupt or not.. Quote Link to comment Share on other sites More sharing options...
rajmohan Posted January 30, 2009 Author Share Posted January 30, 2009 I am using the storage engine "MYISAM".. Whether because of this may occur some problem... Quote Link to comment Share on other sites More sharing options...
landavia Posted January 30, 2009 Share Posted January 30, 2009 >>How to find whether the table is corrupt or not.. u can't.. but something like that.. (fail select).. related to crash data >>I am using the storage engine "MYISAM".. actualy.. type don't related to the table corrupt or not i have DB using MYISAM.. is already fail after a year, but there more old.. not crash.. is only a matter of luck i believe Quote Link to comment Share on other sites More sharing options...
fenway Posted February 2, 2009 Share Posted February 2, 2009 What does "CHECK TABLES" say? Quote Link to comment Share on other sites More sharing options...
Mchl Posted February 2, 2009 Share Posted February 2, 2009 >>I am using the storage engine "MYISAM".. actualy.. type don't related to the table corrupt or not Actually it is. Different storage engines fail in different ways. InnoDB for example can fix itself most of the times without user ever noticing it failed. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.