Sedang Disiapkan

Magento Database Queries Problem (STORE EXTREMELY SLOW)

Hello,

i have an urgent problem with my magento store. Everything have work great in the last 2 years. Now i have an problem with the performance! The loading times are higher then 30-40 secconds :-( I have change nothing on magento and with the server is also everything ok.

This is the answer from the Server-Provider

You create your database is paralyzed by a variety of the following queries:

UPDATE `sales_flat_quote` SET `entity_id` = '51224', `store_id` = '2',

`created_at` = '2013-01-10 03:36:17', `updated_at` = '2013-01-10 12:54:15',

`converted_at` = '0000-00-00 00:00:00', `is_active` = '1', `is_virtual` = '0',

`is_multi_shipping` = '0', `items_count` = '1425', `items_qty` = '2301',

`orig_order_id` = '0', `store_to_base_rate` = '1', `store_to_quote_rate` = '1',

`base_to_global_rate` = '1', `base_to_quote_rate` = '1', `global_currency_code` =

'EUR', `base_currency_code` = 'EUR', `store_currency_code` = 'EUR',

`quote_currency_code` = 'EUR', `grand_total` = '746817.7', `base_grand_total` =

'746817.7', `checkout_method` = '', `customer_id` = NULL, `customer_tax_class_id`

= '3', `customer_group_id` = '0', `customer_email` = NULL, `customer_prefix` =

NULL, `customer_firstname` = NULL, `customer_middlename` = NULL,

`customer_lastname` = NULL, `customer_suffix` = NULL, `customer_dob` = NULL,

`customer_note` = NULL, `customer_note_notify` = '1', `customer_is_guest` = '0',

`customer_taxvat` = NULL, `remote_ip` = '[url removed, login to view]', `applied_rule_ids` = '',

`reserved_order_id` = '', `password_hash` = NULL, `coupon_code` = NULL, `subtotal`

= '627733.36', `base_subtotal` = '627733.36', `subtotal_with_discount` =

'627733.36', `base_subtotal_with_discount` = '627733.36', `gift_message_id` =

NULL, `is_changed` = '1', `trigger_recollect` = '0', `ext_shipping_info` = NULL,

`customer_gender` = NULL, `invoicepdf_add_totals` = NULL, `cod_fee` = '0',

`base_cod_fee` = '0', `cod_tax_amount` = '0', `base_cod_tax_amount` = '0',

`giftcert_code` = NULL WHERE (entity_id='51224')

But this are normal queries from Magento? I need really help with that. The Store is still slow and i get also the 503 errors.

THX

Kemahiran: Magento, MySQL, PHP

Lihat lebih lanjut: urgent magento help, urgent magento, queries, magento slow, magento errors, magento database, database queries, database performance , 503 magento, slow queries, magento urgent, slow php store, slow server, performance problem, slow php magento, magento slow queries, update magento store, queries magento, magento update problem, 203, magento database update, slow queries magento, magento 503, magento loading, store data database magento

Tentang Majikan:
( 12 ulasan ) Esslingen am Neckar, Germany

ID Projek: #4114316

Dianugerahkan kepada:

pivn

Let expert do this

€40 EUR dalam sehari
(43 Ulasan)
4.8

16 freelancers are bidding on average €127 for this job

KatrinaQ

Freelance Professional.

€99 EUR dalam sehari
(458 Ulasan)
7.3
p4provider

Here are Magento Experts , please check Our Latest Magento work In PMB For Our Experience and skills Regarding Magento projects and Let me start your work , Thanks

€250 EUR dalam 3 hari
(81 Ulasan)
7.2
AStonetech

Please refer PMB

€75 EUR dalam 2 hari
(209 Ulasan)
7.0
dannv

Hello, We are ready to start working on the project. Please check your inbox for more details, thanks!

€100 EUR dalam sehari
(147 Ulasan)
6.8
vniteam

I can help you :)

€80 EUR dalam sehari
(148 Ulasan)
6.8
weblaunch

Hi, we are confident we can make you happy with the quality we'll deliver,plz check pmb for more details....

€200 EUR dalam 3 hari
(36 Ulasan)
6.0
troutlet

Hi, My name is Chris Jones I was part of the original Magento beta team and have a unique understanding of this powerful shopping cart. Your problem is not uncommon. I am called upon routinely to find and fix css i Lagi

€175 EUR dalam 2 hari
(28 Ulasan)
5.3
richammond

Lets optimise Mysql. Are you on a shared or dedicated?

€200 EUR dalam 3 hari
(48 Ulasan)
5.2
SEOSEARCHTEAM

For more details please check PMB.. Thanks

€111 EUR dalam 2 hari
(23 Ulasan)
4.8
SmileadeR

I can check & fix it help you ! Plz check your inbox for detail !

€80 EUR dalam sehari
(30 Ulasan)
4.8
caxidsl

Let me check if you grant me ?

€80 EUR dalam sehari
(24 Ulasan)
4.9
safecodedev

Hi, can I help you ?

€120 EUR dalam 3 hari
(36 Ulasan)
4.5
diamond1027

Hi, I can do it perfectly. Regards.

€30 EUR dalam sehari
(21 Ulasan)
4.4
technofreakz

I am a Linux Consultant

€50 EUR dalam 2 hari
(18 Ulasan)
4.0
zelyonka

Hi, Blomberg1980! Please, see our offer in PMB.

€200 EUR dalam 5 hari
(4 Ulasan)
3.9
jameshmrik1

We can provide you complete work with facility that you can pay as we work and can provide you real time communication about the project too please check your message in detail for more information

€170 EUR dalam 3 hari
(0 Ulasan)
0.0