Lines Matching refs:IF
16 DROP PROCEDURE IF EXISTS statement_performance_analyzer;
250 IF (v_this_thread_enabled = 'YES') THEN
252 END IF;
256 IF (@log_bin = 1) THEN
258 END IF;
262 IF (@sys.statement_performance_analyzer.limit IS NULL) THEN
264 END IF;
265 IF (@sys.debug IS NULL) THEN
267 END IF;
272 IF (in_table = 'NOW()') THEN
276 IF (NOT INSTR(in_table, '.')) THEN
284 END IF;
288 IF (@sys.debug = 'ON') THEN
290 END IF;
292 …IF (v_table_db = DATABASE() AND (v_table_name = 'tmp_digests' OR v_table_name = 'tmp_digests_delta…
296 END IF;
299 IF (@sys.debug = 'ON') THEN
301 END IF;
303 IF (v_table_exists = 'BASE TABLE') THEN
318 IF (v_checksum_ref <> v_checksum_table) THEN
321 …IF(CHAR_LENGTH(v_quoted_table) > 93, CONCAT('...', SUBSTRING(v_quoted_table, -90)), v_quoted_table…
325 END IF;
326 END IF;
327 END IF;
330 IF (in_views IS NULL OR in_views = '') THEN
333 END IF;
338 IF (@sys.debug = 'ON') THEN
340 END IF;
345 IF (in_table IS NOT NULL) THEN
346 IF (NOT v_table_exists IN ('TEMPORARY', 'BASE TABLE')) THEN
349 …IF(CHAR_LENGTH(v_quoted_table) > 16, CONCAT('...', SUBSTRING(v_quoted_table, -13)), v_quoted_table…
353 END IF;
354 END IF;
358 IF (v_table_exists NOT IN ('TEMPORARY', 'BASE TABLE')) THEN
360 IF(in_table IS NOT NULL, CONCAT(' The table ',
361 …IF(CHAR_LENGTH(v_quoted_table) > 39, CONCAT('...', SUBSTRING(v_quoted_table, -36)), v_quoted_table…
365 END IF;
367 IF (in_action = 'delta' AND v_tmp_digests_table_exists <> 'TEMPORARY') THEN
370 END IF;
373 IF (v_table_exists = 'TEMPORARY') THEN
375 …IF(CHAR_LENGTH(v_quoted_table) > 72, CONCAT('...', SUBSTRING(v_quoted_table, -69)), v_quoted_table…
379 END IF;
383 IF (v_table_exists <> '') THEN
385 …IF(CHAR_LENGTH(v_quoted_table) > 52, CONCAT('...', SUBSTRING(v_quoted_table, -49)), v_quoted_table…
387 … IF(v_table_exists = 'TEMPORARY', ' as a temporary table.', '.'));
390 END IF;
435 IF (v_force_new_snapshot
440 IF (v_tmp_digests_table_exists = 'TEMPORARY') THEN
441 IF (@sys.debug = 'ON') THEN
443 END IF;
444 DROP TEMPORARY TABLE IF EXISTS tmp_digests;
445 END IF;
449 …IF(in_table IS NULL OR in_action = 'save', 'performance_schema.events_statements_summary_by_digest…
451 END IF;
454 IF (in_action IN ('create_table', 'create_tmp')) THEN
455 IF (in_action = 'create_table') THEN
459 END IF;
464 DROP TEMPORARY TABLE IF EXISTS sys.tmp_digests;
465 DROP TEMPORARY TABLE IF EXISTS sys.tmp_digests_delta;
469 IF (in_action = 'overall') THEN
470 IF (in_table IS NULL) THEN
474 END IF;
477 DROP TEMPORARY TABLE IF EXISTS tmp_digests_delta;
516 END IF;
518 IF (FIND_IN_SET('with_runtimes_in_95th_percentile', in_views)) THEN
521 DROP TEMPORARY TABLE IF EXISTS tmp_digest_avg_latency_distribution1;
522 DROP TEMPORARY TABLE IF EXISTS tmp_digest_avg_latency_distribution2;
523 DROP TEMPORARY TABLE IF EXISTS tmp_digest_95th_percentile_by_avg_us;
576 END IF;
578 IF (FIND_IN_SET('analysis', in_views)) THEN
589 IF (@sys.statement_performance_analyzer.limit > 0) THEN
591 END IF;
593 END IF;
595 IF (FIND_IN_SET('with_errors_or_warnings', in_views)) THEN
606 IF (@sys.statement_performance_analyzer.limit > 0) THEN
608 END IF;
610 END IF;
612 IF (FIND_IN_SET('with_full_table_scans', in_views)) THEN
623 IF (@sys.statement_performance_analyzer.limit > 0) THEN
625 END IF;
627 END IF;
629 IF (FIND_IN_SET('with_sorting', in_views)) THEN
640 IF (@sys.statement_performance_analyzer.limit > 0) THEN
642 END IF;
644 END IF;
646 IF (FIND_IN_SET('with_temp_tables', in_views)) THEN
657 IF (@sys.statement_performance_analyzer.limit > 0) THEN
659 END IF;
661 END IF;
663 IF (FIND_IN_SET('custom', in_views)) THEN
666 IF (@sys.statement_performance_analyzer.view IS NULL) THEN
668 END IF;
669 IF (@sys.statement_performance_analyzer.view IS NULL) THEN
672 END IF;
674 IF (NOT INSTR(@sys.statement_performance_analyzer.view, ' ')) THEN
676 IF (NOT INSTR(@sys.statement_performance_analyzer.view, '.')) THEN
684 END IF;
687 IF (v_custom_view_exists <> 'VIEW') THEN
690 END IF;
703 END IF;
705 IF (@sys.statement_performance_analyzer.limit > 0) THEN
707 END IF;
710 END IF;
711 END IF;
714 IF (v_this_thread_enabled = 'YES') THEN
716 END IF;
718 IF (@log_bin = 1) THEN
720 END IF;