Suljettu

Optimise Xenforo database slow MySql queries

Hello everyone, i am having some issues with the slow mysql queries on my xenforo forum that generate a lot of account executions on hosting. I will attached them here, need to fix them fast:

=== TOP 3 of 3 (total) Slow Queries for the past 24 hours ==========

1. Executed 10h 36m 4s ago for 1.744852 sec on Database --> spinni63_claudiu

Date: 2017-02-14 12:00:04 Query_time: 1.744852 Rows_examined: 2: Rows_sent 2 Lock_time: 0.057933

# Schema: spinni63_claudiu Last_errno: 0 Killed: 0 SELECT title, template_compiled FROM xf_template_compiled WHERE title IN ('xengallery_bb_code_tag_gallery', 'attachment_editor_attachment') AND style_id = '2' AND language_id = '3';

------------------------------------------------------------------------------------------------

2. Executed 10h 37m 23s ago for 1.602071 sec on Database --> spinni63_claudiu

Date: 2017-02-14 11:58:45 Query_time: 1.602071 Rows_examined: 3: Rows_sent 3 Lock_time: 0.000061

# Schema: spinni63_claudiu Last_errno: 0 Killed: 0 SELECT title, template_compiled FROM xf_template_compiled WHERE title IN ('xengallery_bb_code_tag_gallery', '[url removed, login to view]', '[url removed, login to view]', '[url removed, login to view]') AND style_id = '2' AND language_id = '0';

------------------------------------------------------------------------------------------------

3. Executed 10h 36m 34s ago for 1.329392 sec on Database --> spinni63_claudiu

Date: 2017-02-14 11:59:34 Query_time: 1.329392 Rows_examined: 0: Rows_sent 0 Lock_time: 0.000053

# Schema: spinni63_claudiu Last_errno: 0 Killed: 0 SELECT attachment.*, [url removed, login to view], data.file_size, data.file_hash, data.file_path, [url removed, login to view], [url removed, login to view], data.thumbnail_width, data.thumbnail_height FROM xf_attachment AS attachment INNER JOIN xf_attachment_data AS data ON (data.data_id = attachment.data_id) WHERE attachment.temp_hash = '5cf7af31f6e922d4ae9b38a80cbfc144' ORDER BY attachment.attach_date;

Taidot: Tietokannan hallinto, Tietokantakehitys, Tietokantaohjelmointi

Näytä lisää: slow mysql queries wordpress, magento slow mysql queries, resolve generated slow mysql queries, mysql count slow slow query slow queries, optimize mysql queries, mysql part number database, mysql drink recipe database, mysql thunderbird adress database, mysql update seperate database, php mysql equipment rental database, building xml files mysql queries, php mysql simple project database, mysql php music database player website user system, mysql php rental database, mysql user system database

About the Employer:
( 18 reviews ) ramnicu Valcea, Romania

Projektin tunnus: #13108574

10 freelanceria on tarjonnut keskimäärin 201 $ tähän työhön

truongnguyen86

Hello there, i'm expert on SQL field, actually i've done tuning project for many times before, you can check my profile to see. Actually with these kind of slow queries we can do 2 things: indexes on those necessary fi Lisää

250 $ USD 3 päivässä
(75 arvostelua)
5.9
fanninson45

INTRODUCTION I have done a similar project like this recently for a Canadian Sporting Organisation here [url removed, login to view] SHOWCASE An experienced Microso Lisää

233 $ USD 4 päivässä
(12 arvostelua)
5.4
300 $ USD 5 päivässä
(4 arvostelua)
4.1
155 $ USD 3 päivässä
(1 arvostelu)
2.1
SoftoMozo

Backed by IITians, Please check our portfolio at [url removed, login to view] or here on freelancer. We are a team of skilled young and experienced designers developers backed by IITians. We have been in the market for a while a Lisää

155 $ USD 3 päivässä
(0 arvostelua)
0.0
bradzelenak

Years of database tuning experience will guide me in helping you find the absolute best performance.

150 $ USD 3 päivässä
(0 arvostelua)
0.0
tanz99

Hi, I'll help you optimize the database. I have over 10+ years of experience in database management and optimization. Please contact me to discuss more details. Looking forward to working with you. Thanks

182 $ USD 1 päivässä
(0 arvostelua)
0.0
lumenaSolutions

Hello sir!! Myself Ritika I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.. i have experience more than 8+ yrs. My skills are : - PHP, MySql,Python MVC F Lisää

277 $ USD 5 päivässä
(0 arvostelua)
0.0
amarjotrocky

Hi, My name is Amarjot from India working as database developer (oracle, mysql, sybase) having around 7+ experience in the same. I have hands-on performance tuning of the queries and also worked in making packages, Lisää

155 $ USD 3 päivässä
(0 arvostelua)
0.0
aap31374

I have 10+ years database development experience in sql server, Mysql and Postgres. I have also worked in SSIS and SSRS. I assure that i will give you fully satisfaction about this assignment.

155 $ USD 3 päivässä
(0 arvostelua)
0.0