OPTIMIZE MYSQL - CSCART

$30-250 USD

Closed

Posted

almost 6 years ago

$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

CS-Cart

MySQL

Project ID: 16766844

About the project

10 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

10 freelancers are bidding on average $185 USD for this job

@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

5.0

(13 reviews)

4.9

@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 designing website for you in HTML, PHP, CMS like Wordpress, Joomla, Magento, E-commerce, PSD to HTML, speedup your site, make it responsive, do graphic designing, also offer writing services, fix google errors, improve security, upgrade design, increase visitors, ECOMMERCE Site, Transfer Website from 1 host to other etc. Awaiting your response. Thanks, Souvik

$250 USD in 10 days

5.0

(5 reviews)

3.7

@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

5.0

(2 reviews)

2.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

5.0

(2 reviews)

2.2

@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, thanks! I am Good atCS-Cart, MySQL.

$155 USD in 2 days

5.0

(3 reviews)

1.5

@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 could create it for you as soon as that easy but how this have done ,,,,please discuses before start job,,,,

$277 USD in 3 days

0.0

(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 script plus database performance. I will do this job easily. Thanks, Pragnesh

$111 USD in 3 days