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: 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.
32 freelancers are bidding on average £13/hour for this job
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 Hello How are you I read your description carefully Your description is very familar to me I have many good experiences in php, magento and SQL So I can finish your project quickly and perfectly Thanks