Lines Matching refs:IF
23 DROP PROCEDURE IF EXISTS statement_performance_analyzer;
257 IF (v_this_thread_enabled = 'YES') THEN
259 END IF;
263 IF (@log_bin = 1) THEN
265 END IF;
269 IF (@sys.statement_performance_analyzer.limit IS NULL) THEN
271 END IF;
272 IF (@sys.debug IS NULL) THEN
274 END IF;
279 IF (in_table = 'NOW()') THEN
283 IF (NOT INSTR(in_table, '.')) THEN
291 END IF;
295 IF (@sys.debug = 'ON') THEN
297 END IF;
299 …IF (v_table_db = DATABASE() AND (v_table_name = 'tmp_digests' OR v_table_name = 'tmp_digests_delta…
303 END IF;
306 IF (@sys.debug = 'ON') THEN
308 END IF;
310 IF (v_table_exists = 'BASE TABLE') THEN
325 IF (v_checksum_ref <> v_checksum_table) THEN
328 …IF(CHAR_LENGTH(v_quoted_table) > 93, CONCAT('...', SUBSTRING(v_quoted_table, -90)), v_quoted_table…
332 END IF;
333 END IF;
334 END IF;
337 IF (in_views IS NULL OR in_views = '') THEN
340 END IF;
345 IF (@sys.debug = 'ON') THEN
347 END IF;
352 IF (in_table IS NOT NULL) THEN
353 IF (NOT v_table_exists IN ('TEMPORARY', 'BASE TABLE')) THEN
356 …IF(CHAR_LENGTH(v_quoted_table) > 16, CONCAT('...', SUBSTRING(v_quoted_table, -13)), v_quoted_table…
360 END IF;
361 END IF;
365 IF (v_table_exists NOT IN ('TEMPORARY', 'BASE TABLE')) THEN
367 IF(in_table IS NOT NULL, CONCAT(' The table ',
368 …IF(CHAR_LENGTH(v_quoted_table) > 39, CONCAT('...', SUBSTRING(v_quoted_table, -36)), v_quoted_table…
372 END IF;
374 IF (in_action = 'delta' AND v_tmp_digests_table_exists <> 'TEMPORARY') THEN
377 END IF;
380 IF (v_table_exists = 'TEMPORARY') THEN
382 …IF(CHAR_LENGTH(v_quoted_table) > 72, CONCAT('...', SUBSTRING(v_quoted_table, -69)), v_quoted_table…
386 END IF;
390 IF (v_table_exists <> '') THEN
392 …IF(CHAR_LENGTH(v_quoted_table) > 52, CONCAT('...', SUBSTRING(v_quoted_table, -49)), v_quoted_table…
394 … IF(v_table_exists = 'TEMPORARY', ' as a temporary table.', '.'));
397 END IF;
442 IF (v_force_new_snapshot
447 IF (v_tmp_digests_table_exists = 'TEMPORARY') THEN
448 IF (@sys.debug = 'ON') THEN
450 END IF;
451 DROP TEMPORARY TABLE IF EXISTS tmp_digests;
452 END IF;
456 …IF(in_table IS NULL OR in_action = 'save', 'performance_schema.events_statements_summary_by_digest…
458 END IF;
461 IF (in_action IN ('create_table', 'create_tmp')) THEN
462 IF (in_action = 'create_table') THEN
466 END IF;
471 DROP TEMPORARY TABLE IF EXISTS sys.tmp_digests;
472 DROP TEMPORARY TABLE IF EXISTS sys.tmp_digests_delta;
476 IF (in_action = 'overall') THEN
477 IF (in_table IS NULL) THEN
481 END IF;
484 DROP TEMPORARY TABLE IF EXISTS tmp_digests_delta;
523 END IF;
525 IF (FIND_IN_SET('with_runtimes_in_95th_percentile', in_views)) THEN
528 DROP TEMPORARY TABLE IF EXISTS tmp_digest_avg_latency_distribution1;
529 DROP TEMPORARY TABLE IF EXISTS tmp_digest_avg_latency_distribution2;
530 DROP TEMPORARY TABLE IF EXISTS tmp_digest_95th_percentile_by_avg_us;
583 END IF;
585 IF (FIND_IN_SET('analysis', in_views)) THEN
596 IF (@sys.statement_performance_analyzer.limit > 0) THEN
598 END IF;
600 END IF;
602 IF (FIND_IN_SET('with_errors_or_warnings', in_views)) THEN
613 IF (@sys.statement_performance_analyzer.limit > 0) THEN
615 END IF;
617 END IF;
619 IF (FIND_IN_SET('with_full_table_scans', in_views)) THEN
630 IF (@sys.statement_performance_analyzer.limit > 0) THEN
632 END IF;
634 END IF;
636 IF (FIND_IN_SET('with_sorting', in_views)) THEN
647 IF (@sys.statement_performance_analyzer.limit > 0) THEN
649 END IF;
651 END IF;
653 IF (FIND_IN_SET('with_temp_tables', in_views)) THEN
664 IF (@sys.statement_performance_analyzer.limit > 0) THEN
666 END IF;
668 END IF;
670 IF (FIND_IN_SET('custom', in_views)) THEN
673 IF (@sys.statement_performance_analyzer.view IS NULL) THEN
675 END IF;
676 IF (@sys.statement_performance_analyzer.view IS NULL) THEN
679 END IF;
681 IF (NOT INSTR(@sys.statement_performance_analyzer.view, ' ')) THEN
683 IF (NOT INSTR(@sys.statement_performance_analyzer.view, '.')) THEN
691 END IF;
694 IF (v_custom_view_exists <> 'VIEW') THEN
697 END IF;
710 END IF;
712 IF (@sys.statement_performance_analyzer.limit > 0) THEN
714 END IF;
717 END IF;
718 END IF;
721 IF (v_this_thread_enabled = 'YES') THEN
723 END IF;
725 IF (@log_bin = 1) THEN
727 END IF;