high cpu on request with JOIN
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?