OPTIMIZE MYSQL - CSCART
$30-250 USD
Paid on delivery
When i run the follow command
UPDATE cscart_product_features SET STATUS="A" WHERE STATUS="D"
and take as message (UPDATED 1696 ROWS)
after that all the 48 threads of cpu are all over 98%
my memory is 29,7G/128G
After a while my site give me everyhwere to frontpage the error (504 Gateway Time-out nginx)
the adminam panel work with a delay... but work..
The onyl that i can to to wrok my server again is to restart the services of mysql,ngix and run the follow command
so to disbale again the features
UPDATE cscart_product_features SET STATUS="D"
---------------------------------------------------------------------------------
Server Setup
CS-CART Version [login to view URL]
PHP Version 7.2.4
CPanel / WHM
NGINX
SSLs / multidomain SSLs
MariaDB
APC(u)
Server Hardware
Processor
AMD EPYC 7401P 24-Core Processor
Speed 1200.000 MHz
Cache 512 KB
48 threads
Ram =128G
MYSQL Tables_rows
cscart_product_features=1699
cscart_product_features_values = 4348140
cscart_products = 124076
cscart_product_descriptions = 248152
cscart_products_categories = 145421
cscart_categories = 5195
cscart_ult_product_descriptions = 244268
cscart_orders = 42211
cscart_order_data = 203669
cscart_order_details = 68709
cscart_product_prices = 600318
cscart_images = 785937
Project ID: #16766844
About the project
10 freelancers are bidding on average $185 for this job
Hello Nice to meet you i think you have to optimize cscart_product_features_values table Please contact me to finish further more detail about your project. Regards.
Dear customer, We are a team of full-time freelancers with a range of skills including: HTML, PHP, CMS, SEO,Website Development, Wordpress, opencart, Joomla, Magento, E-commerce and Online Marketing. We can help in More
I have experience with MySQL please share tables scripts to check foreign keys and indexes. Maybe your DB need some indexes
Hi, I'm a seasoned mysql/mariadb programmer and can help you out. Please see my earlier high ratings. You will not regret I you select me. / Hakan
Hello ntheogr, Although I’m new to freelancer, I’m a senior developer based in Essex, UK. I have all relevant experience for this project and I’m eager to start ASAP. I urge you to message me ASAP to discuss further, t More
I have 6 year experience Freelancer,up work,Fiverr & 99design market place I have seen your project that i can to do easily because I have many experience to Graphic Design,Webdesign,Web Develop & programming .So I cou More
Hi, Hope you are doing well! I am Pragnesh. I have 5+ experience in PHP, YII , Codeigniter, MySql, Jquery with Symantec and Comodo API integration API. I understand your issue. I think we need to improve scri More