ptityop Posted April 13 Share Posted April 13 (edited) Hello,I am migrating a site and I am having issues working out why our database is like 6gig when our site is not that big at all. When I go to phpmyadmin and checke the table sizes the biggest is 392 and as you will see on the screenshot it goes down pretty fast. Still when I export the database i get a 6gig file. Am i missing something ? Thanks in advance for any help For info i already cleaned stats tables like ps_connection etc, but still no difference Edited April 13 by ptityop update (see edit history) Link to comment Share on other sites More sharing options...
Daresh Posted April 14 Share Posted April 14 Maybe try to optimize the tables to make the size more adequate? Link to comment Share on other sites More sharing options...
Mediacom87 Posted April 14 Share Posted April 14 Hi, Regular database cleansing is an obligation on PrestaShop, and can be done manually if you have a good command of SQL queries. However, this is time-consuming, and you need to secure your data before you lose everything. There are modules that can do this on a daily basis to prevent the database from exploding in size. Link to comment Share on other sites More sharing options...
Prestashop Addict Posted April 14 Share Posted April 14 (edited) Hi, according to Prestashop tables related to statistics, and unecessaries collected data we strongly recommend to uninstall following modules if you use an external analysis system like Google Analytics. Because some data will be redondant, and made the database growing with huge data! pagesnotfound statsdata statslive And verify tables has been removed ps_connections, ps_guest, ps_connections_source.. if not delete them. You also have a lot of layered filters. May you have a very large catalog... But may be you can limit filters... Edited April 14 by Prestashop Addict (see edit history) 1 Link to comment Share on other sites More sharing options...
ptityop Posted April 14 Author Share Posted April 14 thanks all for your input. What I don't understand is that phpmyadmin is not showing any big tables as you see.I should at least be able to see which tables are the heaviest Link to comment Share on other sites More sharing options...
ptityop Posted April 14 Author Share Posted April 14 Anyone can explain what that means please "You also have a lot of layered filters", i am not familiar with this, where this can be tweaked from ? Link to comment Share on other sites More sharing options...
ptityop Posted April 14 Author Share Posted April 14 I found the solution, pb had to do with phpmyadmin, i movd server and now i can see real sizes of table ! thanks all for your input ! Link to comment Share on other sites More sharing options...
Prestashop Addict Posted April 15 Share Posted April 15 Don't forget to change your title post by adding [SOLVED] and add a Thanks or Like to the good answer, this will help community. 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