Closed

OPTIMIZE MYSQL - CSCART

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

Skills: CS-Cart, MySQL

See more: optimize mysql server, need optimize mysql, optimize mysql queries script, optimize mysql traffic, optimize mysql traffic website, optimize mysql thousands concurrent users, optimize mysql oscommerce, optimize mysql cpu usage, optimize mysql apache, optimize mysql query software, optimize mysql requests, optimize mysql databases, optimize mysql load servers, optimize mysql queries, optimize mysql phpbb3

About the Employer:
( 0 reviews ) PATRA, Greece

Project ID: #16766844

12 freelancers are bidding on average $179 for this job

$200 USD in 2 days
(24 Reviews)
4.6
$155 USD in 2 days
(30 Reviews)
4.6
drgold03

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 days
(7 Reviews)
4.3
CyborgSouvik

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

$250 USD in 10 days
(5 Reviews)
3.7
$155 USD in 3 days
(6 Reviews)
3.0
thepro

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 days
(2 Reviews)
2.6
nubelo_MjFSuBpQ

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 days
(2 Reviews)
2.0
rutherfordandco

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

$155 USD in 2 days
(2 Reviews)
1.6
tuhinkhan7878

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

$277 USD in 3 days
(0 Reviews)
0.0
fleetTower

Hi I have long experience in this field. My previous work website is "[login to view URL]" "[login to view URL]" "[login to view URL]" "[login to view URL]" "[login to view URL]" More

$150 USD in 3 days
(0 Reviews)
0.0
patelpragnesh03

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

$111 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(1 Review)
0.0