Fix SQL Deadlocks & Slow Queries on Custom Magento Build
£10-15 GBP (1시간 기준)
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.
프로젝트 ID: #17760253
프로젝트 소개
이 일자리에 대한 프리랜서 30 명의 평균 입찰가: £13 (1시간 기준)
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
"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 기타
"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 기타
ok got it . i am expert in sql .... i can resolve your issues for you ... message me .................thanks.
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 기타
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
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 기타
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.
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) 기타