rcamu Posted January 12, 2016 Share Posted January 12, 2016 Caros, meu BD está com mais de 60mb... ps_connections ps_connections_source ps_guest só essas 3 tabelas está dando quase 50mb, são tabelas de histórico, como eu consigo diminuir isso, tipo deixar somente os últimos 3 meses? Link to comment Share on other sites More sharing options...
selectshop.at Posted January 15, 2016 Share Posted January 15, 2016 Desative as estatísticas do Prestashop e use programas de estatísticas instaladas no servidor (se nao for compartilhado !). Vc. pode também escrever um pequeno script para esvaziar estas tabelas de tempo em tempo automáticamente, se tiver conhecimentos de programacao. Ou entao use um módulo: https://www.prestashop.com/forums/topic/90075-moduledelete-connections-v21-save-space-on-databaseoptimize-all-tables-for-more-speed-ps1216/ Link to comment Share on other sites More sharing options...
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