MySQL Forums

high cpu on request with JOIN
Posted by: Gérard Moisset
Date: January 15, 2016 03:49AM

EXPLAIN SELECT `meetingId`, `askNumber`,`meetingNumber`, `title`, `description`, `organizerCompanyId`,`organizerId`, `createdById`, `preStartDate`, `startDate`, `endDate`, `timeZone`, `pointToPoint`, `useVisio`, `iViewConferenceId`, `ctxMeetingKey`, `ctxAccessNumber`, `ctxConferenceId`, `fromOutlook`, `statusMeetingForOrganizer`, `meetingType`, `securityCode`, `comment`, g.geoarea, `isGeneric`, `tmsConferenceId` FROM meeting LEFT JOIN geoarea g USING(geoareaId) WHERE iViewConferenceId=1414144;
+----+-------------+---------+------+---------------+------+---------+------+--------+----------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------+------+---------------+------+---------+------+--------+----------------------------------------------------+
| 1 | SIMPLE | meeting | ALL | NULL | NULL | NULL | NULL | 185699 | Using where |
| 1 | SIMPLE | g | ALL | PRIMARY | NULL | NULL | NULL | 3 | Using where; Using join buffer (Block Nested Loop) |
+----+-------------+---------+------+---------------+------+---------+------+--------+----------------------------------------------------+

# Time: 160115 10:22:57
# User@Host: popvmasupdate[popvmasupdate] @ opopvdc11.nanterre.francetelecom.fr [10.99.82.71] Id: 479
# Query_time: 0.767757 Lock_time: 0.000436 Rows_sent: 1 Rows_examined: 243402
SET timestamp=1452849777;
SELECT `meetingId`, `askNumber`,`meetingNumber`, `title`, `description`, `organizerCompanyId`,`organizerId`, `createdById`, `preStartDate`, `startDate`, `endDate`, `timeZone`, `pointToPoint`, `useVisio`, `iViewConferenceId`, `ctxMeetingKey`, `ctxAccessNumber`, `ctxConferenceId`, `fromOutlook`, `statusMeetingForOrganizer`, `meetingType`, `securityCode`, `comment`, g.geoarea, `isGeneric`, `tmsConferenceId` FROM meeting LEFT JOIN geoarea g USING(geoareaId) WHERE iViewConferenceId=1414144;

how can i deal and improve this request?

Subject
Views
Written By
Posted
high cpu on request with JOIN
1357
January 15, 2016 03:49AM
678
January 15, 2016 05:43AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.