I gang

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

Færdigheder: Magento, MySQL, PHP

Se mere: 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

Om arbejdsgiveren:
( 12 bedømmelser ) Esslingen am Neckar, Germany

Projekt-ID: #4114316

Tildelt til:

pivn

Let expert do this

€40 EUR på 1 dag
(43 bedømmelser)
4.8

16 freelancere byder i gennemsnit €127 for dette job

KatrinaQ

Freelance Professional.

€99 EUR på 1 dag
(458 bedømmelser)
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 in 3 dage
(81 bedømmelser)
7.2
AStonetech

Please refer PMB

€75 EUR in 2 dage
(209 bedømmelser)
7.0
dannv

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

€100 EUR på 1 dag
(147 bedømmelser)
6.8
vniteam

I can help you :)

€80 EUR på 1 dag
(148 bedømmelser)
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 in 3 dage
(36 bedømmelser)
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 Mere

€175 EUR in 2 dage
(28 bedømmelser)
5.3
richammond

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

€200 EUR in 3 dage
(48 bedømmelser)
5.2
SEOSEARCHTEAM

For more details please check PMB.. Thanks

€111 EUR in 2 dage
(23 bedømmelser)
4.8
SmileadeR

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

€80 EUR på 1 dag
(30 bedømmelser)
4.8
caxidsl

Let me check if you grant me ?

€80 EUR på 1 dag
(24 bedømmelser)
4.9
safecodedev

Hi, can I help you ?

€120 EUR in 3 dage
(36 bedømmelser)
4.5
diamond1027

Hi, I can do it perfectly. Regards.

€30 EUR på 1 dag
(21 bedømmelser)
4.4
technofreakz

I am a Linux Consultant

€50 EUR in 2 dage
(18 bedømmelser)
4.0
zelyonka

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

€200 EUR in 5 dage
(4 bedømmelser)
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 in 3 dage
(0 bedømmelser)
0.0