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


SSLs / multidomain SSLs



Server Hardware


AMD EPYC 7401P 24-Core Processor

Speed 1200.000 MHz

Cache 512 KB

48 threads

Ram =128G

MYSQL Tables_rows


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

Beceriler: CS-Cart, MySQL

Daha fazlasını gör: optimize mysql phpbb3, optimize mysql queries, optimize mysql load servers, optimize mysql databases, optimize mysql requests, optimize mysql query software, optimize mysql apache, optimize mysql cpu usage, optimize mysql oscommerce, optimize mysql thousands concurrent users, optimize mysql traffic website, optimize mysql traffic, optimize mysql queries script, need optimize mysql, optimize mysql server

İşveren Hakkında:
( 0 değerlendirme ) PATRA, Greece

Proje NO: #16766844

Bu iş için 10 freelancer ortalamada $185 teklif veriyor


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.

$155 USD in 3 gün içinde
(13 Değerlendirme)
$200 USD in 2 gün içinde
(38 Değerlendirme)
$155 USD in 2 gün içinde
(30 Değerlendirme)

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 Daha Fazla

$250 USD in 10 gün içinde
(5 Değerlendirme)

I have experience with MySQL please share tables scripts to check foreign keys and indexes. Maybe your DB need some indexes

$155 USD in 10 gün içinde
(2 Değerlendirme)

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

$233 USD in 10 gün içinde
(2 Değerlendirme)

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 Daha Fazla

$155 USD in 2 gün içinde
(3 Değerlendirme)
$155 USD in 3 gün içinde
(3 Değerlendirme)

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 Daha Fazla

$277 USD in 3 gün içinde
(0 Değerlendirme)

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 Daha Fazla

$111 USD in 3 gün içinde
(0 Değerlendirme)