BIG table ps_jm_pagecache

[petrixstar]

Hello All!

I tried to export to the database and it seems I couldn't!then I exported from vps via putty ssh and it worked and it seems that the table ps_jm_pagecach has 160mb and 18235000 lines. Does anyone know what is with this table and if I can delete it, that is to empty it?

Thank you very much for the answer

[ps8modules]

Hi.
This is a question for the page cache module author.

[petrixstar]

ok, thanks, I found the module I also have spoken with the developer, I solved it, he told me that I can delete the table quietly!

in the meantime I found another table : ps_page_viewed has 21 Mb and 400k rows. can it be emptied? I did not find anything concrete on the forum and on google

Thanks

[ps8modules]

hi
ps_page_viewed is used for backoffice and graph display.
Yes, you can empty it, but don't remove it.

[Rizzzle]

Can we delete ps_jm_pagecache?

Mine is 11gb

[ps8modules]

SQL

TRUNCATE TABLE ps_jm_pagecache;

 

[Rizzzle]

Thanks for the quick reply please can you write a basic description on how to do that in phpmyadmin?

 

Thanks

[ps8modules]

Open the database, select a table, find SQL at the top, write a query in it and click the "save" button.

 

https://wpengine.com/support/run-query-phpmyadmin/

Edited July 11 by ps8modules.com (see edit history)

[Rizzzle]

Hi,

Thank you. The table that is huge is ps_jm_pagecache_bl

Is this okay to TRUNCATE?

 

Thanks

[Rizzzle]

And ps_jm_pagecache_mods

Thanks