MySQL problems on a Joomla site
4662
£150(approx. $188)
- Posted:
- Proposals: 3
- Remote
- #80737
- Archived
Description
Experience Level: Expert
Hi
The databser on our site creates load on its server... Pasted below is the log details from the server.
If anyone can see something in the code that could lead us towards the issue to fix it then please make a bid.
logs:
| 19746 | economyn_Gary3 | localhost | economyn_jo151 | Sleep | 38 | | | | 19748 | economyn_Gary3 | localhost | economyn_jo151 | Sleep | 94 | | | | 19761 | economyn_Gary3 | localhost | economyn_jo151 | Query | 35 | Writing to net | SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectioni d, a.state, a.catid | | 19762 | economyn_Gary3 | localhost | economyn_jo151 | Sleep | 87 | | | | 19778 | economyn_Gary3 | localhost | economyn_jo151 | Query | 23 | Copying to tmp table | SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectioni d, a.state, a.catid | | 19814 | economyn_Gary3 | localhost | economyn_jo151 | Query | 13 | Sorting result | SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) EL SE a.id END as slug | | 19817 | economyn_Gary3 | localhost | economyn_jo151 | Sleep | 56 | | | | 19824 | economyn_Gary3 | localhost | economyn_jo151 | Query | 1 | Opening tables | SELECT g.* FROM jos_core_acl_aro_groups AS g INNER JOIN jos_core_acl_groups_aro_m ap AS gm ON gm.grou | | 19825 | economyn_Gary3 | localhost | economyn_jo151 | Sleep | 30 | | | | 19827 | economyn_Gary3 | localhost | economyn_jo151 | Sleep | 28 | | |
The databser on our site creates load on its server... Pasted below is the log details from the server.
If anyone can see something in the code that could lead us towards the issue to fix it then please make a bid.
logs:
| 19746 | economyn_Gary3 | localhost | economyn_jo151 | Sleep | 38 | | | | 19748 | economyn_Gary3 | localhost | economyn_jo151 | Sleep | 94 | | | | 19761 | economyn_Gary3 | localhost | economyn_jo151 | Query | 35 | Writing to net | SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectioni d, a.state, a.catid | | 19762 | economyn_Gary3 | localhost | economyn_jo151 | Sleep | 87 | | | | 19778 | economyn_Gary3 | localhost | economyn_jo151 | Query | 23 | Copying to tmp table | SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectioni d, a.state, a.catid | | 19814 | economyn_Gary3 | localhost | economyn_jo151 | Query | 13 | Sorting result | SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) EL SE a.id END as slug | | 19817 | economyn_Gary3 | localhost | economyn_jo151 | Sleep | 56 | | | | 19824 | economyn_Gary3 | localhost | economyn_jo151 | Query | 1 | Opening tables | SELECT g.* FROM jos_core_acl_aro_groups AS g INNER JOIN jos_core_acl_groups_aro_m ap AS gm ON gm.grou | | 19825 | economyn_Gary3 | localhost | economyn_jo151 | Sleep | 30 | | | | 19827 | economyn_Gary3 | localhost | economyn_jo151 | Sleep | 28 | | |
Gary H.
100% (18)Projects Completed
29
Freelancers worked with
27
Projects awarded
50%
Last project
23 Jan 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies