kloner Posted January 26, 2011 Share Posted January 26, 2011 Hello,At the outset, sorry for my english. I hope you understand me.I have shop on PrestaShop. I have +/- 8000 products.Records of MySQL: 333 512Recently, the mysql database server kills.Query is looped backSELECT SQL_CALC_FOUND_ROWS p . * , pl.`description_short` , pl.`available_now` , pl.`available_later` , plQuery using 100 % of core. How to fix this ? Link to comment Share on other sites More sharing options...
kloner Posted January 26, 2011 Author Share Posted January 26, 2011 Please, help. Link to comment Share on other sites More sharing options...
inveostore.com Posted January 26, 2011 Share Posted January 26, 2011 It seems some of PS database tables do not have correct integrity. Go to phpMyAdmin click "Check All" at table list and then change "With selected" to "Repair table". It should help. Link to comment Share on other sites More sharing options...
kloner Posted January 26, 2011 Author Share Posted January 26, 2011 Hej, this is not work. I too used mysqlcheck -A -r and no error's. Link to comment Share on other sites More sharing options...
kloner Posted January 27, 2011 Author Share Posted January 27, 2011 hmm, any sugestions ? Link to comment Share on other sites More sharing options...
kloner Posted January 27, 2011 Author Share Posted January 27, 2011 Request a cloned and begins to block the entire machine to us ..We have:wersja: 1.3.1.1 - 2.283s Link to comment Share on other sites More sharing options...
inveostore.com Posted January 27, 2011 Share Posted January 27, 2011 If you are 100% sure it worked before db server crash, it will likely be a general MySQL problem and not PS. I would recommend to put a question at some MySQL related forums. Link to comment Share on other sites More sharing options...
kloner Posted January 27, 2011 Author Share Posted January 27, 2011 Now i update presta to 1.3.6 i think this fix my bug.. Link to comment Share on other sites More sharing options...
kloner Posted January 27, 2011 Author Share Posted January 27, 2011 update is not fix this bug.Please help me, this query are clone and block machine ..SELECT SQL_CALC_FOUND_ROWS p . * , pl.`description_short` , pl.`available_now` , pl.`available_later` , plThis query is for ps_product ?Maybe, i delete all products and import again from my exel base ? Link to comment Share on other sites More sharing options...
kloner Posted January 28, 2011 Author Share Posted January 28, 2011 Hello,I updated to 1.3.6 Presta Uploader a new database from Excel files, and unfortunately did not help.Screen:Uploaded with ImageShack.us Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now