V1.7 database Cleaner Module

[mkr]

dear members i need a module that can clean my database and make my website more faster

 

[d-shilko]

You able to clear DB by you self without module. Make backup before using.

Case 1​

Remove data from those tables​

Run following command in your phpMyAdmin:

TRUNCATE TABLE ps_connections;
TRUNCATE TABLE ps_connections_page;
TRUNCATE TABLE ps_connections_source;
TRUNCATE TABLE ps_pagenotfound;
TRUNCATE TABLE ps_statssearch;

​

Case 2​

# Delete all logs
TRUNCATE ps_log;


# Delete old connection data (only used for stats)
# change 2016-02-01 00:00:00 according to you needs
DELETE c, cs
FROM ps_connections c
LEFT JOIN ps_connections_source cs ON (c.id_connections = cs.id_connections)
WHERE c.date_add < '2016-02-01 00:00:00';

OPTIMIZE TABLE ps_connections, ps_connections_source;


# Delete all guest without entry in ps_customer table
DELETE g
FROM ps_guest g
LEFT JOIN ps_customer c ON (g.id_customer = c.id_customer)
WHERE c.id_customer IS NULL;

OPTIMIZE TABLE ps_guest;


# Delete tables
# Scenes are deprecated in 1.6 (used only if upgrading with feature active)
DROP TABLE `ps_scene`;
DROP TABLE `ps_scene_category`;
DROP TABLE `ps_scene_lang`;
TRUNCATE `ps_scene_products`;
DROP TABLE `ps_scene_shop`;
UPDATE `ps_configuration` SET value='0', date_upd=NOW() WHERE `name` = 'PS_SCENE_FEATURE_ACTIVE';

 

[hxcode]

You able to clear DB by you self without module. Make backup before using.

Case 1​

Remove data from those tables​

Run following command in your phpMyAdmin:

TRUNCATE TABLE ps_connections;
TRUNCATE TABLE ps_connections_page;
TRUNCATE TABLE ps_connections_source;
TRUNCATE TABLE ps_pagenotfound;
TRUNCATE TABLE ps_statssearch;

​

Case 2​

# Delete all logs
TRUNCATE ps_log;


# Delete old connection data (only used for stats)
# change 2016-02-01 00:00:00 according to you needs
DELETE c, cs
FROM ps_connections c
LEFT JOIN ps_connections_source cs ON (c.id_connections = cs.id_connections)
WHERE c.date_add < '2016-02-01 00:00:00';

OPTIMIZE TABLE ps_connections, ps_connections_source;


# Delete all guest without entry in ps_customer table
DELETE g
FROM ps_guest g
LEFT JOIN ps_customer c ON (g.id_customer = c.id_customer)
WHERE c.id_customer IS NULL;

OPTIMIZE TABLE ps_guest;


# Delete tables
# Scenes are deprecated in 1.6 (used only if upgrading with feature active)
DROP TABLE `ps_scene`;
DROP TABLE `ps_scene_category`;
DROP TABLE `ps_scene_lang`;
TRUNCATE `ps_scene_products`;
DROP TABLE `ps_scene_shop`;
UPDATE `ps_configuration` SET value='0', date_upd=NOW() WHERE `name` = 'PS_SCENE_FEATURE_ACTIVE';

good sharing, thanks bro

 

[Camelo]

Great tips amigo!

 

[darkwini]

Super

 

[fornes]

good share, thank you very much for everything

 

[uko]

Thanks for sharing!

 

[s.elhachlafi]

thanks

 

[t.hisuka]

thanks

 

[broxit]

Good Share... thank you bro.

 

[trakr]

You able to clear DB by you self without module. Make backup before using.

# Delete old connection data (only used for stats)​

# change 2016-02-01 00:00:00 according to you needs
DELETE c, cs
FROM ps_connections c
LEFT JOIN ps_connections_source cs ON (c.id_connections = cs.id_connections)
WHERE c.date_add < '2016-02-01 00:00:00';

Is the date 2016-02-01 in your example the date "FROM" when the connections will be deleted ? It will delete from year 2016 to current year?

 

[d-shilko]

Is the date 2016-02-01 in your example the date "FROM" when the connections will be deleted ? It will delete from year 2016 to current year?

2016,1015,2014......
c.date_add (all dates in base below )< (this date) '2016-02-01 00:00:00'

Greetings

 

[freiserk]

Here:

v1.6-v1.7 - PrestaShop database cleaner module v1.0.1

PrestaShop database cleaner module Clean up your db Speed up your site For a live site, the database will be bigger and bigger, because new data get added every day, like shopping carts, guests, logs, etc. Cleaning out old useless data to speed your site up. The result: Faster website loading...

www.nulledfrm.com