I moved a website made in Prestashop 1.5.6 from one hosting account to another from the same company and I started having problems of too much use of resources, to the point that the company temporarily disabled access to Mysql. The previous account used another version of Mysql, I do not know if it would have anything to do with it.
One of the problematic querys is this:
USER: *********
DB: ********
STATE: Copying to tmp table
TIME: 178
COMMAND: Query
INFO: SELECT h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM 'ps_hook' h
INNER JOIN 'ps_hook_module' hm ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
INNER JOIN 'ps_module' as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
The ps_module table has 124 records, the ps_hook_module 408, and the ps_hook 148.
How could it be that I did not have this problem before and now it consumes too many resources?