[Skip to main content](#vessel-content) # mysql query slow and down mysql server ## - **[aminweb](/forum/user/38602-aminweb "View aminweb's Profile")** - [![aminweb's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar38602.png)](/forum/user/38602-aminweb "View aminweb's Profile") Topic Author - [ Offline](/forum/user/38602-aminweb) - Amin Less More - Posts: 138 - Thank you received: 4 - - - 9 years 6 months ago [\#267170](#267170) by [aminweb](/forum/user/38602-aminweb "View aminweb's Profile") *[mysql query slow and down mysql server](/forum/2-general-talk-about-hikashop/889773-mysql-query-slow-and-down-mysql-server#267170 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.5 -- PHP version -- : 5.6 hi, my shop site(hikashop) many time average load server high and down server. hosting provider say : this problem releated hikashop component. please help me to resolve this problem error site when server down : Error displaying the error page: Application Instantiation Error: Could not connect to MySQL. directadmin system message : Subject: Warning: The system load average is 62.33 top - 14:12:09 up 3:50, 1 user, load average: 80.91, 62.39, 40.32 Tasks: 325 total, 3 running, 317 sleeping, 1 stopped, 4 zombie %Cpu(s): 36.5 us, 1.5 sy, 0.0 ni, 60.6 id, 1.1 wa, 0.0 hi, 0.0 si, 0.3 st KiB Mem : 4914072 total, 155828 free, 4646664 used, 111580 buff/cache KiB Swap: 2097148 total, 3644 free, 2093504 used. 90932 avail Mem ----- thanks")* was created by *[aminweb](/forum/user/38602-aminweb "View aminweb's Profile")* -- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.5 -- PHP version -- : 5.6 hi, my shop site(hikashop) many time average load server high and down server. hosting provider say : this problem releated hikashop component. please help me to resolve this problem error site when server down : Error displaying the error page: Application Instantiation Error: Could not connect to MySQL. directadmin system message : Subject: Warning: The system load average is 62.33 top - 14:12:09 up 3:50, 1 user, load average: 80.91, 62.39, 40.32 Tasks: 325 total, 3 running, 317 sleeping, 1 stopped, 4 zombie %Cpu(s): 36.5 us, 1.5 sy, 0.0 ni, 60.6 id, 1.1 wa, 0.0 hi, 0.0 si, 0.3 st KiB Mem : 4914072 total, 155828 free, 4646664 used, 111580 buff/cache KiB Swap: 2097148 total, 3644 free, 2093504 used. 90932 avail Mem --- thanks --- Joomla Developer \| am.ebrahimzadeh\[at\]gmail.com Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg4OTc3My1teXNxbC1xdWVyeS1zbG93LWFuZC1kb3duLW15c3FsLXNlcnZlcj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 6 months ago [\#267173](#267173) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[mysql query slow and down mysql server](/forum/2-general-talk-about-hikashop/889773-mysql-query-slow-and-down-mysql-server#267173 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.5 -- PHP version -- : 5.6 hi, my shop site(hikashop) many time average load server high and down server. hosting provider say : this problem releated hikashop component. please help me to resolve this problem error site when server down : Error displaying the error page: Application Instantiation Error: Could not connect to MySQL. directadmin system message : Subject: Warning: The system load average is 62.33 top - 14:12:09 up 3:50, 1 user, load average: 80.91, 62.39, 40.32 Tasks: 325 total, 3 running, 317 sleeping, 1 stopped, 4 zombie %Cpu(s): 36.5 us, 1.5 sy, 0.0 ni, 60.6 id, 1.1 wa, 0.0 hi, 0.0 si, 0.3 st KiB Mem : 4914072 total, 155828 free, 4646664 used, 111580 buff/cache KiB Swap: 2097148 total, 3644 free, 2093504 used. 90932 avail Mem ----- thanks")* Hello, Can you host provider can give more details why HikaShop would be responsible ? With the current information, all I can say is that your system is overloaded and MySQL server is not able to serve all requests. But I'm afraid nothing is pointing HikaShop as source of your issue. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [aminweb](/forum/user/38602-aminweb "View aminweb's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg4OTc3My1teXNxbC1xdWVyeS1zbG93LWFuZC1kb3duLW15c3FsLXNlcnZlcj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[aminweb](/forum/user/38602-aminweb "View aminweb's Profile")** - [![aminweb's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar38602.png)](/forum/user/38602-aminweb "View aminweb's Profile") Topic Author - [ Offline](/forum/user/38602-aminweb) - Amin Less More - Posts: 138 - Thank you received: 4 - - - 9 years 6 months ago [\#267224](#267224) by [aminweb](/forum/user/38602-aminweb "View aminweb's Profile") Replied by *[aminweb](/forum/user/38602-aminweb "View aminweb's Profile")* on topic *[mysql query slow and down mysql server](/forum/2-general-talk-about-hikashop/889773-mysql-query-slow-and-down-mysql-server#267224 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.5 -- PHP version -- : 5.6 hi, my shop site(hikashop) many time average load server high and down server. hosting provider say : this problem releated hikashop component. please help me to resolve this problem error site when server down : Error displaying the error page: Application Instantiation Error: Could not connect to MySQL. directadmin system message : Subject: Warning: The system load average is 62.33 top - 14:12:09 up 3:50, 1 user, load average: 80.91, 62.39, 40.32 Tasks: 325 total, 3 running, 317 sleeping, 1 stopped, 4 zombie %Cpu(s): 36.5 us, 1.5 sy, 0.0 ni, 60.6 id, 1.1 wa, 0.0 hi, 0.0 si, 0.3 st KiB Mem : 4914072 total, 155828 free, 4646664 used, 111580 buff/cache KiB Swap: 2097148 total, 3644 free, 2093504 used. 90932 avail Mem ----- thanks")* I access server root (ssh) How can I find out, what the database table, it puts pressure on the server? please help me thanks --- Joomla Developer \| am.ebrahimzadeh\[at\]gmail.com Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg4OTc3My1teXNxbC1xdWVyeS1zbG93LWFuZC1kb3duLW15c3FsLXNlcnZlcj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 9 years 6 months ago [\#267232](#267232) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[mysql query slow and down mysql server](/forum/2-general-talk-about-hikashop/889773-mysql-query-slow-and-down-mysql-server#267232 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.5 -- PHP version -- : 5.6 hi, my shop site(hikashop) many time average load server high and down server. hosting provider say : this problem releated hikashop component. please help me to resolve this problem error site when server down : Error displaying the error page: Application Instantiation Error: Could not connect to MySQL. directadmin system message : Subject: Warning: The system load average is 62.33 top - 14:12:09 up 3:50, 1 user, load average: 80.91, 62.39, 40.32 Tasks: 325 total, 3 running, 317 sleeping, 1 stopped, 4 zombie %Cpu(s): 36.5 us, 1.5 sy, 0.0 ni, 60.6 id, 1.1 wa, 0.0 hi, 0.0 si, 0.3 st KiB Mem : 4914072 total, 155828 free, 4646664 used, 111580 buff/cache KiB Swap: 2097148 total, 3644 free, 2093504 used. 90932 avail Mem ----- thanks")* Hi, Turn on the debug mode of the Joomla configuration and browse your website, on the pages that are slow to display, look at the debug MySQL query data at the bottom of the page and that will provide important information on which query is slow. Then, you can look at the tables used in these queries. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg4OTc3My1teXNxbC1xdWVyeS1zbG93LWFuZC1kb3duLW15c3FsLXNlcnZlcj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[aminweb](/forum/user/38602-aminweb "View aminweb's Profile")** - [![aminweb's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar38602.png)](/forum/user/38602-aminweb "View aminweb's Profile") Topic Author - [ Offline](/forum/user/38602-aminweb) - Amin Less More - Posts: 138 - Thank you received: 4 - - - 9 years 6 months ago - 9 years 6 months ago [\#267274](#267274) by [aminweb](/forum/user/38602-aminweb "View aminweb's Profile") Replied by *[aminweb](/forum/user/38602-aminweb "View aminweb's Profile")* on topic *[mysql query slow and down mysql server](/forum/2-general-talk-about-hikashop/889773-mysql-query-slow-and-down-mysql-server#267274 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.5 -- PHP version -- : 5.6 hi, my shop site(hikashop) many time average load server high and down server. hosting provider say : this problem releated hikashop component. please help me to resolve this problem error site when server down : Error displaying the error page: Application Instantiation Error: Could not connect to MySQL. directadmin system message : Subject: Warning: The system load average is 62.33 top - 14:12:09 up 3:50, 1 user, load average: 80.91, 62.39, 40.32 Tasks: 325 total, 3 running, 317 sleeping, 1 stopped, 4 zombie %Cpu(s): 36.5 us, 1.5 sy, 0.0 ni, 60.6 id, 1.1 wa, 0.0 hi, 0.0 si, 0.3 st KiB Mem : 4914072 total, 155828 free, 4646664 used, 111580 buff/cache KiB Swap: 2097148 total, 3644 free, 2093504 used. 90932 avail Mem ----- thanks")* SELECT * FROM kbs5e_hikashop_file AS file WHERE file.file_type = 'product' AND file_ref_id = 4021 ORDER BY file_ordering ASC this query many time repeat and per query time 1.3 ms and dont any key for this query --- SELECT * FROM kbs5e_hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_display` LIKE '%;field\_item\_product\_cart=1;%' AND a.field_table='item' AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%') ORDER BY a.`field_ordering` ASC query time : 1.47 ms --- SELECT a.* FROM kbs5e_hikashop_zone_link AS a WHERE a.zone_child_namekey IN ('country_United_Kingdom_222','tax_europe_9728','ship__1818572586'); query time : 1.23 ms --- Joomla Developer \| am.ebrahimzadeh\[at\]gmail.com Last edit: 9 years 6 months ago by [aminweb](/forum/user/38602-aminweb "View aminweb's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg4OTc3My1teXNxbC1xdWVyeS1zbG93LWFuZC1kb3duLW15c3FsLXNlcnZlcj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 9 years 6 months ago [\#267292](#267292) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[mysql query slow and down mysql server](/forum/2-general-talk-about-hikashop/889773-mysql-query-slow-and-down-mysql-server#267292 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.5 -- PHP version -- : 5.6 hi, my shop site(hikashop) many time average load server high and down server. hosting provider say : this problem releated hikashop component. please help me to resolve this problem error site when server down : Error displaying the error page: Application Instantiation Error: Could not connect to MySQL. directadmin system message : Subject: Warning: The system load average is 62.33 top - 14:12:09 up 3:50, 1 user, load average: 80.91, 62.39, 40.32 Tasks: 325 total, 3 running, 317 sleeping, 1 stopped, 4 zombie %Cpu(s): 36.5 us, 1.5 sy, 0.0 ni, 60.6 id, 1.1 wa, 0.0 hi, 0.0 si, 0.3 st KiB Mem : 4914072 total, 155828 free, 4646664 used, 111580 buff/cache KiB Swap: 2097148 total, 3644 free, 2093504 used. 90932 avail Mem ----- thanks")* Hello, You can see to add an index for "file_ref_id" on the table "hikashop_file" : but a query around 1-2 ms is not problematic. Thanks to the debug mode, you can also check what file is performing the query. If you have a query processed several times, it can help to understand if something is unusual. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg4OTc3My1teXNxbC1xdWVyeS1zbG93LWFuZC1kb3duLW15c3FsLXNlcnZlcj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86322 - Thank you received: 14281 - - 9 years 6 months ago [\#267733](#267733) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[mysql query slow and down mysql server](/forum/2-general-talk-about-hikashop/889773-mysql-query-slow-and-down-mysql-server#267733 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.5 -- PHP version -- : 5.6 hi, my shop site(hikashop) many time average load server high and down server. hosting provider say : this problem releated hikashop component. please help me to resolve this problem error site when server down : Error displaying the error page: Application Instantiation Error: Could not connect to MySQL. directadmin system message : Subject: Warning: The system load average is 62.33 top - 14:12:09 up 3:50, 1 user, load average: 80.91, 62.39, 40.32 Tasks: 325 total, 3 running, 317 sleeping, 1 stopped, 4 zombie %Cpu(s): 36.5 us, 1.5 sy, 0.0 ni, 60.6 id, 1.1 wa, 0.0 hi, 0.0 si, 0.3 st KiB Mem : 4914072 total, 155828 free, 4646664 used, 111580 buff/cache KiB Swap: 2097148 total, 3644 free, 2093504 used. 90932 avail Mem ----- thanks")* Hi, We got your debug. Here is what we can say out of it: - There are 416 MySQL queries generated for the loading of data on that page. - It only took 0.35 second to run all these MySQL queries. - Out of these 416 queries, HikaShop only accounts for 240 of them. More than 400 queries for one page is a lot. However, they are really fast on your website so the problem with your MySQL server doesn't come from these. So either the problem is on other pages than the one for which you provided the debug, or the slow down isn't MySQL related. Also, a normal page should have about 100 queries provided it's configured properly. Looking at them, it looks like your template (or some other module-related extension) is adding a lot of extra queries on the modules which aren't there normally. And regarding HikaShop, I suppose that it comes from how you configured the listings. There are ways to reduce the number of queries. For example, if you turn off the display of the custom item fields in your listings, the system will remove a lot of the queries on the listings. But even doing all that won't help for your main issue as it apparently comes from something else. Please ask your provider what exactly slows down the server and provide them when the debug file you gave. Because saying it comes from HikaShop without saying what is the problem exactly is like saying there is a bug in Windows without saying where it comes from or how to reproduce it and Microsoft won't be able to do anything in that case. You can even give them the link to this message so that they don't have to analyze the debug file and directly read my conclusions. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg4OTc3My1teXNxbC1xdWVyeS1zbG93LWFuZC1kb3duLW15c3FsLXNlcnZlcj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.068 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)