i have an wordpress wesbite and its a 4 core 3GB Ram VPS, but i have no huge traffic monthky 2-3k. i se my Mysql query very high always server full and page slow, my hosting support reply this,
" We have checked your server , and mysql is using high resources.
This is due to persistent sending data requests in processlist for mysql , here is the request
SELECT SQL_CALC_FOUND_ROWS [login to view URL] FROM wpaq_posts LEFT JOIN wpaq_postmeta ON ([login to view URL]
I would recommend to check this with your developer "
i need a solution, my page link : [login to view URL]
9 freelancer đang chào giá trung bình $63 cho công việc này
Hello, I have read your job details carefully and i can do your work if you will provide me more details of project.I will definitely give you a best solution to your problem. Thanks
I understand what WordPress is doing and can fix your issue with the SQL statement. It is inherit with WordPress and the only way to fix it is to rewrite that statement.