Fermé

Fix SQL Deadlocks & Slow Queries on Custom Magento Build

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.

Compétences : Linux, MySQL, PHP, SQL

en voir plus : create custom magento theme, fix sql express, mssql find slow queries, export custom magento, custom magento theme prices, custom seamonkey build, php fix sql xss function, sql utilities run queries, custom magento store, custom magento build, fix mysql slow queries drupal, slow queries magento, magento build custom rest api, slow queries fix

Concernant l'employeur :
( 19 commentaires ) Diseworth, United Kingdom

Nº du projet : #17760253

31 freelance font une offre moyenne de £13/heure pour ce travail

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 / heure
(586 Commentaires)
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 Plus

£13 GBP / heure
(455 Commentaires)
8.5
OutsourceMan

"fixsql" Hello, This is Vaishali from "Hire WordPress Experts" and I am here to help you with Fix SQL Deadlocks & Slow Queries on Custom Magento Build . We have gone through the information provided by you. and Plus

£13 GBP / heure
(349 Commentaires)
8.1
surabhirathi21

"fixsql", we’ve gone through your project details and understood the requirement well and can accomplish it successfully. Based at New Delhi, India, we’re a Private Limited company with core expertise on Magent Plus

£15 GBP / heure
(204 Commentaires)
7.9
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 Plus

£15 GBP / heure
(245 Commentaires)
7.9
dbuglab

"fixsql" Hello !!! [[ I am a well oriented Magento Developer. Understood the requirements, so ready to analyse and optimise your database and code to fix a recurring deadlock and any slow queries according to your Plus

£13 GBP / heure
(185 Commentaires)
7.5
contriverz

Hi there, Hope you doing great !!! I have gone through your requirements very well to "Fix SQL Deadlocks & Slow Queries on Custom Magento Build" and its should be performed out accordingly with topmost skills. Plus

£11 GBP / heure
(97 Commentaires)
7.6
visionvivante

fixsql Hi there, Yes, I understand your SQL deadlock & Slow queries issues you are facing in Magento based website. I required your database login details so that I can analyze and fix this issue after this I am Plus

£11 GBP / heure
(63 Commentaires)
7.4
sankhalainfosol

"fixsql" Hi, Having an eye over details, we can surely help you to Fix SQL Deadlocks & Slow Queries on Custom Magento Build as per your needs. Also we are ready to start work immediately. We are Experts team o Plus

£12 GBP / heure
(125 Commentaires)
7.0
phpdeveloper100

Ready to work with you and optmizie it , actually what is going one that due to load your this table locked with one entry and then 2nd entery come , Please open Message box so that we discuss it in detail Experti Plus

£13 GBP / heure
(75 Commentaires)
7.3
magento2expert

fixsql Hello, i will help you with site issue :- Order saving error: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction, query was: UPDATE `catalog_ Plus

£10 GBP / heure
(112 Commentaires)
7.2
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 Plus

£13 GBP / heure
(245 Commentaires)
7.1
shiningdevelopor

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

£13 GBP / heure
(84 Commentaires)
6.9
tangramua

fixsql Hi, my name is Oleksii. I can help you to optimise your SQL database and code and fix a recurring deadlock and any slow queries. I think I will be the right candidate because I am professional Web Developer Plus

£15 GBP / heure
(59 Commentaires)
6.8
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 Plus

£15 GBP / heure
(52 Commentaires)
6.9
daffodilsoftware

Hello, My name is Matt and I represent the Web Development team at Daffodil. . As per your requirement, we can provide you a senior dedicated SQL resource that will be working full-time(45 hrs/week) on your proje Plus

£14 GBP / heure
(17 Commentaires)
7.7
aftabyounas

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

£11 GBP / heure
(104 Commentaires)
6.3
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 / heure
(85 Commentaires)
5.9
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 Plus

£10 GBP / heure
(98 Commentaires)
6.2
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 Plus

£17 GBP / heure
(30 Commentaires)
5.1