Fix MySQL load issue with some WooCommerce pages -- 3

<------------------- General info -------------------> Before explaining, we want to be very clear that we're a Web Agency and we're looking for long term providers that are affordable and also very experienced with lots of years working on hosting environments / very experts in WooCommerce in this case. Very honest people, if you do this fine we will give you more tasks of other projects, since we're an agency and have multiple clients / projects, most of them based in WP. == General requirements for any freelancer in this kind of tasks - Have a good english (we also talk portuguese and spanish, just in case you use any of this languages). - Better if you're a WordPress coder / developer - Must have skype account, better if we can talk directly via voice / cam in special cases - Available for long term deals and other future projects - We want freelancers that fixes issues in minutes, not in hours. At least 10 years experience per area. <------------------- General info -------------------> == Techs / areas we want you to be a guru: - Google Insights / mobile / gtmetrix / pingdom optimization in WooCommerce WP area - JQuery / CSS / PHP / JavaScript expert - Apache / Nginx / Varnish / guru - All kind of caching that helps to improve WooCommerce - Datalog / NewRelic management - Application Performance Management and Monitoring tools == Tasks to execute: Fix an issue in a WooCommerce site that suddenly is getting multiple MySQL resources in the shop area. See --> [login to view URL] When visiting the shop, sometimes site needs half minute to serve content. This was instant before. Server (cpanel) shows a high load on MySQL service. 1.- Is not a server's issue (we tested site on different server and different technology) 2.- Is not a sql issue (other sites with larger DBs go ultra fast) 3.- This was working fine until suddenly issue appeared. Thanks.