Fix SQL Deadlocks & Slow Queries on Custom Magento Build

종료 등록 시간: 5년 전 착불
종료

We are looking for an SQL Expert to both analyse and optimise our database and code to fix a recurring deadlock and any slow queries.

Here is a sample of the deadlock error.

Order saving error: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: UPDATE `catalog_product_entity` SET `entity_type_id` = ?, `attribute_set_id` = ?, `type_id` = ?, `sku` = ?, `has_options` = ?, `required_options` = ?, `created_at` = '2018-07-16 07:14:59', `updated_at` = '2018-09-12 14:54:05', `exclude_from_supply_needs` = ? WHERE (`entity_id`=8181)

Please do NOT post a generic response, these will be ignored.

I would like to know your SQL / PHP / Magento Experience only and what you will do to help us resolve this issue.

Inlclude "fixsql" comment in your response so that I know you have read this.

리눅스 MySQL PHP SQL

프로젝트 ID: #17760253

프로젝트 소개

30 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 5년 전

이 일자리에 대한 프리랜서 30 명의 평균 입찰가: £13 (1시간 기준)

emizentech

fixsql I am expert with Magneto MYSQL Deadlock As I had resolve lot off issue with catalog table and indexing table Kindly let me know when I can start to look this bug. Thanks Vivek

£14 GBP / (1시간 기준)
(594 리뷰)
8.9
Lxtech

Hi, I will analyze and optimize the deadlock and replace the bad queries but I need more information about it so I can provide the better solution. please message me back to discuss any question you have. Best 기타

£13 GBP / (1시간 기준)
(457 리뷰)
8.5
magentoguys

"fixsql" Hi i checked ur message : Order saving error: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: UPDATE `catalog_product_entity` SET 기타

£15 GBP / (1시간 기준)
(254 리뷰)
7.9
ambientinfotech

"fixsql" Dear Client, I am expert self-motivated and hardworking Magento developer having 8+ year experienced for both versions: 1.9 & 2.0. > Magento: 1.9 to 2.0. X > Commerce portal > Customization, temp 기타

£13 GBP / (1시간 기준)
(260 리뷰)
7.2
akshitiv

"fixsql" Hello, Hope you are doing great ! We operate over 400 servers, all purely Magento stores - of varying sizes and capacity. And it is rare that the configuration files we have on one - will match that of 기타

£15 GBP / (1시간 기준)
(61 리뷰)
7.1
aftabyounas

ok got it . i am expert in sql .... i can resolve your issues for you ... message me .................thanks.

£11 GBP / (1시간 기준)
(132 리뷰)
6.5
crystalhitesh

Dear Client, Greetings!! I am Magento/WordPress developer having 8+ year experienced in design & custom theme & custom module development, working on both version 1. x to 2. x. All types of Magento solution can p 기타

£10 GBP / (1시간 기준)
(108 리뷰)
6.2
hawkscodes

Hi, I have read your exact requirement and understood the error of deadlock you are getting. I will fix it as per your guidance. Regards Karuna

£10 GBP / (1시간 기준)
(93 리뷰)
6.0
roshanasim

Hi i am linux administrator and having sound knowledge of ssh / putty / terminal to access files & directories inside linux vps. I will go through and let you know to use putty to access linux server. I have develope 기타

£17 GBP / (1시간 기준)
(30 리뷰)
5.1
sreenivas2903

Sqlfix for this it locks?

£32 GBP / (1시간 기준)
(15 리뷰)
4.4
anciwasim

"fixsql" Hello there, I read your complete job description and I can do web work for you and will be doing work for a long time. I am available now for the further discussion. Kindly message me in private chat. 기타

£13 GBP / (1시간 기준)
(1 리뷰)
4.3
gurmejsingh

hi I'm ready to fix now.

£10 GBP / (1시간 기준)
(6 리뷰)
3.8
BissiEU

"fixsql" Hi, very interesting project ! Based upon my experience this can easily be achieved. I really think that You are falling in a too slow query problem and some serialization and|or bad closing issue: th 기타

£10 GBP / (1시간 기준)
(2 리뷰)
3.0
cahuynh0588

Fix sql, I have real experienced with some cases of mysql "deadlock" of Magento. I know the reason and how to fix it. I have just help to solve this problem for some Magento 2 site. Thanks for reading.

£11 GBP / (1시간 기준)
(1 리뷰)
0.9
£13 GBP / (1시간 기준)
(0 리뷰)
0.0
samsqldba9

Having around 6 years of experience in SQL SERVER, Involved in different projects, handled critical scenarios. Well experienced in troubleshooting in all areas. Currently working in IBM for the big project LLOYDS(LBG) 기타

£11 GBP / (1시간 기준)
(0 리뷰)
0.0