« back to all changes in this revision
Viewing changes to tests/r/pbxt/information_schema.result
- browse files at revision 1048
- compare with another revision
- download diff
- download tarball
- view history from revision 1048
- Committer: Vladimir Kolesnikov
- Date: 2009-11-13 17:32:32 UTC
- Revision ID: vladimir@primebase.org-20091113173232-uc5pnpecjum3gdj1
fixed test-cases according to changes in drizzle
- files modified:
- tests/r/pbxt/auto_increment.result
added
removed
tests/r/pbxt/information_schema.result
62
62
CHARACTER_SET_NAME DEFAULT_COLLATE_NAME DESCRIPTION MAXLEN
63
63
select * from information_schema.COLLATIONS
64
64
where COLLATION_NAME like 'latin1%';
65
COLLATION_NAME CHARACTER_SET_NAME ID IS_DEFAULT IS_COMPILED SORTLEN
65
COLLATION_NAME CHARACTER_SET_NAME DESCRIPTION ID IS_DEFAULT IS_COMPILED SORTLEN
66
66
select * from information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
67
67
where COLLATION_NAME like 'latin1%';
68
68
COLLATION_NAME CHARACTER_SET_NAME
88
88
select table_name, column_name, data_type from information_schema.columns
89
89
where data_type = 'datetime';
90
90
table_name column_name data_type
91
INNODB_TRX trx_started datetime
92
INNODB_TRX trx_wait_started datetime
91
93
TABLES CREATE_TIME datetime
92
94
TABLES UPDATE_TIME datetime
93
95
TABLES CHECK_TIME datetime
94
INNODB_TRX trx_started datetime
95
INNODB_TRX trx_wait_started datetime
96
96
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES A
97
97
WHERE NOT EXISTS
98
98
(SELECT * FROM INFORMATION_SCHEMA.COLUMNS B
123
123
x_double_precision NULL NULL
124
124
drop table t1;
125
125
SELECT table_schema, count(*) FROM information_schema.TABLES
126
WHERE table_name NOT LIKE 'ndb_%' AND table_name NOT LIKE 'falcon%' GROUP BY TABLE_SCHEMA;
126
WHERE table_name NOT LIKE 'ndb_%' AND
127
table_name NOT LIKE 'falcon%' AND
128
table_name NOT LIKE 'MEMCACHED%' AND
129
table_name NOT LIKE 'PBXT%'
130
GROUP BY TABLE_SCHEMA;
127
131
table_schema count(*)
128
132
information_schema 24
129
133
pbxt 2
214
218
or column_type = 'varchar(27)')
215
219
group by column_type order by num;
216
220
column_type group_concat(table_schema, '.', table_name) num
217
varchar(20) information_schema.PLUGINS 1
221
varchar(20) information_schema.MODULES 1
218
222
varchar(27) information_schema.COLUMNS 1
219
223
create table t1(f1 char(1) not null, f2 char(9) not null);
220
224
select CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH from
246
250
c2.table_name = t.table_name AND
247
251
c2.column_name LIKE '%SCHEMA%'
248
252
)
249
AND t.table_name NOT LIKE 'falcon%';
253
AND t.table_name NOT LIKE 'falcon%'
254
AND t.table_name NOT LIKE 'MEMCACHED%'
255
AND t.table_name NOT LIKE 'PBXT%';
250
256
table_name column_name
251
257
CHARACTER_SETS CHARACTER_SET_NAME
252
258
COLLATIONS COLLATION_NAME
254
260
COLUMNS TABLE_SCHEMA
255
261
GLOBAL_STATUS VARIABLE_NAME
256
262
GLOBAL_VARIABLES VARIABLE_NAME
263
INNODB_CMP page_size
264
INNODB_CMPMEM page_size
265
INNODB_CMPMEM_RESET page_size
266
INNODB_CMP_RESET page_size
267
INNODB_LOCKS lock_id
268
INNODB_LOCK_WAITS requesting_trx_id
269
INNODB_TRX trx_id
257
270
KEY_COLUMN_USAGE CONSTRAINT_SCHEMA
271
MODULES MODULE_NAME
258
272
PLUGINS PLUGIN_NAME
259
273
PROCESSLIST ID
260
274
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
264
278
STATISTICS TABLE_SCHEMA
265
279
TABLES TABLE_SCHEMA
266
280
TABLE_CONSTRAINTS CONSTRAINT_SCHEMA
267
PBXT_STATISTICS ID
268
INNODB_TRX trx_id
269
INNODB_LOCKS lock_id
270
INNODB_LOCK_WAITS requesting_trx_id
271
INNODB_CMP page_size
272
INNODB_CMP_RESET page_size
273
INNODB_CMPMEM page_size
274
INNODB_CMPMEM_RESET page_size
275
281
SELECT t.table_name, c1.column_name
276
282
FROM information_schema.tables t
277
283
INNER JOIN
286
292
c2.table_name = t.table_name AND
287
293
c2.column_name LIKE '%SCHEMA%'
288
294
)
289
AND t.table_name NOT LIKE 'falcon%';
295
AND t.table_name NOT LIKE 'falcon%'
296
AND t.table_name NOT LIKE 'MEMCACHED%'
297
AND t.table_name NOT LIKE 'PBXT%';
290
298
table_name column_name
291
299
CHARACTER_SETS CHARACTER_SET_NAME
292
300
COLLATIONS COLLATION_NAME
294
302
COLUMNS TABLE_SCHEMA
295
303
GLOBAL_STATUS VARIABLE_NAME
296
304
GLOBAL_VARIABLES VARIABLE_NAME
305
INNODB_CMP page_size
306
INNODB_CMPMEM page_size
307
INNODB_CMPMEM_RESET page_size
308
INNODB_CMP_RESET page_size
309
INNODB_LOCKS lock_id
310
INNODB_LOCK_WAITS requesting_trx_id
311
INNODB_TRX trx_id
297
312
KEY_COLUMN_USAGE CONSTRAINT_SCHEMA
313
MODULES MODULE_NAME
298
314
PLUGINS PLUGIN_NAME
299
315
PROCESSLIST ID
300
316
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
304
320
STATISTICS TABLE_SCHEMA
305
321
TABLES TABLE_SCHEMA
306
322
TABLE_CONSTRAINTS CONSTRAINT_SCHEMA
307
PBXT_STATISTICS ID
308
INNODB_TRX trx_id
309
INNODB_LOCKS lock_id
310
INNODB_LOCK_WAITS requesting_trx_id
311
INNODB_CMP page_size
312
INNODB_CMP_RESET page_size
313
INNODB_CMPMEM page_size
314
INNODB_CMPMEM_RESET page_size
315
323
SELECT MAX(table_name) FROM information_schema.tables;
316
324
MAX(table_name)
317
325
TABLE_CONSTRAINTS
342
350
on t.table_schema = c1.table_schema AND t.table_name = c1.table_name
343
351
where t.table_schema = 'information_schema' AND
344
352
t.table_name not like 'falcon%' AND
353
t.table_name not like 'MEMCACHED%' AND
354
t.table_name not like 'PBXT%' AND
345
355
c1.ordinal_position =
346
356
(select isnull(c2.column_type) -
347
357
isnull(group_concat(c2.table_schema, '.', c2.table_name)) +
366
376
INNODB_LOCK_WAITS information_schema.INNODB_LOCK_WAITS 1
367
377
INNODB_TRX information_schema.INNODB_TRX 1
368
378
KEY_COLUMN_USAGE information_schema.KEY_COLUMN_USAGE 1
369
PBXT_STATISTICS information_schema.PBXT_STATISTICS 1
379
MODULES information_schema.MODULES 1
370
380
PLUGINS information_schema.PLUGINS 1
371
381
PROCESSLIST information_schema.PROCESSLIST 1
372
382
REFERENTIAL_CONSTRAINTS information_schema.REFERENTIAL_CONSTRAINTS 1
459
469
SELECT info FROM information_schema.processlist WHERE id = CONNECTION_ID();
460
470
info
461
471
SELECT info FROM information_schema.processlist WHERE id = CONNECTION_ID()
472
show processlist;
473
Id User Host db Command Time State Info
474
# # # mysqltest Sleep # # NULL
475
# # # test Sleep # # NULL
476
# # # test Query # # show processlist
477
SELECT info, command, db
478
FROM information_schema.processlist
479
WHERE id = CONNECTION_ID();
480
info command db
481
SELECT info, command, db
482
FROM information_schema.processlist
483
WHERE id = CONNECTION_ID() Query test
484
SELECT *
485
FROM information_schema.character_sets
486
ORDER BY character_set_name;
487
CHARACTER_SET_NAME DEFAULT_COLLATE_NAME DESCRIPTION MAXLEN
488
binary binary 1
489
utf8 utf8_general_ci UTF-8 Unicode 4
490
SELECT *
491
FROM information_schema.collations
492
ORDER BY collation_name;
493
COLLATION_NAME CHARACTER_SET_NAME DESCRIPTION ID IS_DEFAULT IS_COMPILED SORTLEN
494
binary binary 63 0 Yes 1 0
495
utf8_bin utf8 46 0 Yes 1 0
496
utf8_czech_ci utf8 234 0 Yes 8 0
497
utf8_danish_ci utf8 235 0 Yes 8 0
498
utf8_esperanto_ci utf8 241 0 Yes 8 0
499
utf8_estonian_ci utf8 230 0 Yes 8 0
500
utf8_general_ci utf8 45 0 Yes 1 0
501
utf8_hungarian_ci utf8 242 0 Yes 8 0
502
utf8_icelandic_ci utf8 225 0 Yes 8 0
503
utf8_latvian_ci utf8 226 0 Yes 8 0
504
utf8_lithuanian_ci utf8 236 0 Yes 8 0
505
utf8_persian_ci utf8 240 0 Yes 8 0
506
utf8_polish_ci utf8 229 0 Yes 8 0
507
utf8_romanian_ci utf8 227 0 Yes 8 0
508
utf8_roman_ci utf8 239 0 Yes 8 0
509
utf8_sinhala_ci utf8 243 0 Yes 8 0
510
utf8_slovak_ci utf8 237 0 Yes 8 0
511
utf8_slovenian_ci utf8 228 0 Yes 8 0
512
utf8_spanish2_ci utf8 238 0 Yes 8 0
513
utf8_spanish_ci utf8 231 0 Yes 8 0
514
utf8_swedish_ci utf8 232 0 Yes 8 0
515
utf8_turkish_ci utf8 233 0 Yes 8 0
516
utf8_unicode_ci utf8 224 0 Yes 8 0
517
SELECT *
518
FROM information_schema.collation_character_set_applicability
519
ORDER BY collation_name;
520
COLLATION_NAME CHARACTER_SET_NAME
521
binary binary
522
utf8_bin utf8
523
utf8_czech_ci utf8
524
utf8_danish_ci utf8
525
utf8_esperanto_ci utf8
526
utf8_estonian_ci utf8
527
utf8_general_ci utf8
528
utf8_hungarian_ci utf8
529
utf8_icelandic_ci utf8
530
utf8_latvian_ci utf8
531
utf8_lithuanian_ci utf8
532
utf8_persian_ci utf8
533
utf8_polish_ci utf8
534
utf8_romanian_ci utf8
535
utf8_roman_ci utf8
536
utf8_sinhala_ci utf8
537
utf8_slovak_ci utf8
538
utf8_slovenian_ci utf8
539
utf8_spanish2_ci utf8
540
utf8_spanish_ci utf8
541
utf8_swedish_ci utf8
542
utf8_turkish_ci utf8
543
utf8_unicode_ci utf8
544
SELECT table_name, column_name
545
FROM information_schema.columns
546
WHERE table_name NOT LIKE 'MEMCACHED%'
547
AND table_name NOT LIKE 'PBXT%'
548
ORDER BY table_name;
549
table_name column_name
550
CHARACTER_SETS CHARACTER_SET_NAME
551
CHARACTER_SETS DEFAULT_COLLATE_NAME
552
CHARACTER_SETS DESCRIPTION
553
CHARACTER_SETS MAXLEN
554
COLLATIONS COLLATION_NAME
555
COLLATIONS CHARACTER_SET_NAME
556
COLLATIONS DESCRIPTION
557
COLLATIONS ID
558
COLLATIONS IS_DEFAULT
559
COLLATIONS IS_COMPILED
560
COLLATIONS SORTLEN
561
COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME
562
COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME
563
COLUMNS TABLE_CATALOG
564
COLUMNS TABLE_SCHEMA
565
COLUMNS TABLE_NAME
566
COLUMNS COLUMN_NAME
567
COLUMNS ORDINAL_POSITION
568
COLUMNS COLUMN_DEFAULT
569
COLUMNS IS_NULLABLE
570
COLUMNS DATA_TYPE
571
COLUMNS CHARACTER_MAXIMUM_LENGTH
572
COLUMNS CHARACTER_OCTET_LENGTH
573
COLUMNS NUMERIC_PRECISION
574
COLUMNS NUMERIC_SCALE
575
COLUMNS CHARACTER_SET_NAME
576
COLUMNS COLLATION_NAME
577
COLUMNS COLUMN_TYPE
578
COLUMNS COLUMN_KEY
579
COLUMNS EXTRA
580
COLUMNS PRIVILEGES
581
COLUMNS COLUMN_COMMENT
582
COLUMNS STORAGE
583
COLUMNS FORMAT
584
GLOBAL_STATUS VARIABLE_NAME
585
GLOBAL_STATUS VARIABLE_VALUE
586
GLOBAL_VARIABLES VARIABLE_NAME
587
GLOBAL_VARIABLES VARIABLE_VALUE
588
INNODB_CMP page_size
589
INNODB_CMP compress_ops
590
INNODB_CMP compress_ops_ok
591
INNODB_CMP compress_time
592
INNODB_CMP uncompress_ops
593
INNODB_CMP uncompress_time
594
INNODB_CMPMEM page_size
595
INNODB_CMPMEM pages_used
596
INNODB_CMPMEM pages_free
597
INNODB_CMPMEM relocation_ops
598
INNODB_CMPMEM relocation_time
599
INNODB_CMPMEM_RESET page_size
600
INNODB_CMPMEM_RESET pages_used
601
INNODB_CMPMEM_RESET pages_free
602
INNODB_CMPMEM_RESET relocation_ops
603
INNODB_CMPMEM_RESET relocation_time
604
INNODB_CMP_RESET page_size
605
INNODB_CMP_RESET compress_ops
606
INNODB_CMP_RESET compress_ops_ok
607
INNODB_CMP_RESET compress_time
608
INNODB_CMP_RESET uncompress_ops
609
INNODB_CMP_RESET uncompress_time
610
INNODB_LOCKS lock_id
611
INNODB_LOCKS lock_trx_id
612
INNODB_LOCKS lock_mode
613
INNODB_LOCKS lock_type
614
INNODB_LOCKS lock_table
615
INNODB_LOCKS lock_index
616
INNODB_LOCKS lock_space
617
INNODB_LOCKS lock_page
618
INNODB_LOCKS lock_rec
619
INNODB_LOCKS lock_data
620
INNODB_LOCK_WAITS requesting_trx_id
621
INNODB_LOCK_WAITS requested_lock_id
622
INNODB_LOCK_WAITS blocking_trx_id
623
INNODB_LOCK_WAITS blocking_lock_id
624
INNODB_TRX trx_id
625
INNODB_TRX trx_state
626
INNODB_TRX trx_started
627
INNODB_TRX trx_requested_lock_id
628
INNODB_TRX trx_wait_started
629
INNODB_TRX trx_weight
630
INNODB_TRX trx_mysql_thread_id
631
INNODB_TRX trx_query
632
KEY_COLUMN_USAGE CONSTRAINT_CATALOG
633
KEY_COLUMN_USAGE CONSTRAINT_SCHEMA
634
KEY_COLUMN_USAGE CONSTRAINT_NAME
635
KEY_COLUMN_USAGE TABLE_CATALOG
636
KEY_COLUMN_USAGE TABLE_SCHEMA
637
KEY_COLUMN_USAGE TABLE_NAME
638
KEY_COLUMN_USAGE COLUMN_NAME
639
KEY_COLUMN_USAGE ORDINAL_POSITION
640
KEY_COLUMN_USAGE POSITION_IN_UNIQUE_CONSTRAINT
641
KEY_COLUMN_USAGE REFERENCED_TABLE_SCHEMA
642
KEY_COLUMN_USAGE REFERENCED_TABLE_NAME
643
KEY_COLUMN_USAGE REFERENCED_COLUMN_NAME
644
location Path
645
location Table_count
646
MODULES MODULE_NAME
647
MODULES MODULE_VERSION
648
MODULES MODULE_AUTHOR
649
MODULES IS_BUILTIN
650
MODULES MODULE_LIBRARY
651
MODULES MODULE_DESCRIPTION
652
MODULES MODULE_LICENSE
653
PLUGINS PLUGIN_NAME
654
PLUGINS PLUGIN_TYPE
655
PLUGINS IS_ACTIVE
656
PLUGINS MODULE_NAME
657
PROCESSLIST ID
658
PROCESSLIST USER
659
PROCESSLIST HOST
660
PROCESSLIST DB
661
PROCESSLIST COMMAND
662
PROCESSLIST TIME
663
PROCESSLIST STATE
664
PROCESSLIST INFO
665
REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG
666
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
667
REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME
668
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG
669
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA
670
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME
671
REFERENTIAL_CONSTRAINTS MATCH_OPTION
672
REFERENTIAL_CONSTRAINTS UPDATE_RULE
673
REFERENTIAL_CONSTRAINTS DELETE_RULE
674
REFERENTIAL_CONSTRAINTS TABLE_NAME
675
REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME
676
SCHEMATA CATALOG_NAME
677
SCHEMATA SCHEMA_NAME
678
SCHEMATA DEFAULT_CHARACTER_SET_NAME
679
SCHEMATA DEFAULT_COLLATION_NAME
680
SCHEMATA SQL_PATH
681
SESSION_STATUS VARIABLE_NAME
682
SESSION_STATUS VARIABLE_VALUE
683
SESSION_VARIABLES VARIABLE_NAME
684
SESSION_VARIABLES VARIABLE_VALUE
685
STATISTICS TABLE_CATALOG
686
STATISTICS TABLE_SCHEMA
687
STATISTICS TABLE_NAME
688
STATISTICS NON_UNIQUE
689
STATISTICS INDEX_SCHEMA
690
STATISTICS INDEX_NAME
691
STATISTICS SEQ_IN_INDEX
692
STATISTICS COLUMN_NAME
693
STATISTICS COLLATION
694
STATISTICS CARDINALITY
695
STATISTICS SUB_PART
696
STATISTICS PACKED
697
STATISTICS NULLABLE
698
STATISTICS INDEX_TYPE
699
STATISTICS COMMENT
700
STATISTICS INDEX_COMMENT
701
statistics ID
702
statistics Name
703
statistics Value
704
TABLES TABLE_CATALOG
705
TABLES TABLE_SCHEMA
706
TABLES TABLE_NAME
707
TABLES TABLE_TYPE
708
TABLES ENGINE
709
TABLES VERSION
710
TABLES ROW_FORMAT
711
TABLES TABLE_ROWS
712
TABLES AVG_ROW_LENGTH
713
TABLES DATA_LENGTH
714
TABLES MAX_DATA_LENGTH
715
TABLES INDEX_LENGTH
716
TABLES DATA_FREE
717
TABLES AUTO_INCREMENT
718
TABLES CREATE_TIME
719
TABLES UPDATE_TIME
720
TABLES CHECK_TIME
721
TABLES TABLE_COLLATION
722
TABLES CHECKSUM
723
TABLES CREATE_OPTIONS
724
TABLES TABLE_COMMENT
725
TABLE_CONSTRAINTS CONSTRAINT_CATALOG
726
TABLE_CONSTRAINTS CONSTRAINT_SCHEMA
727
TABLE_CONSTRAINTS CONSTRAINT_NAME
728
TABLE_CONSTRAINTS TABLE_SCHEMA
729
TABLE_CONSTRAINTS TABLE_NAME
730
TABLE_CONSTRAINTS CONSTRAINT_TYPE
731
SELECT *
732
FROM information_schema.key_column_usage;
733
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION POSITION_IN_UNIQUE_CONSTRAINT REFERENCED_TABLE_SCHEMA REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME
734
SELECT *
735
FROM information_schema.referential_constraints;
736
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG UNIQUE_CONSTRAINT_SCHEMA UNIQUE_CONSTRAINT_NAME MATCH_OPTION UPDATE_RULE DELETE_RULE TABLE_NAME REFERENCED_TABLE_NAME
737
SELECT catalog_name, schema_name
738
FROM information_schema.schemata
739
ORDER BY schema_name;
740
catalog_name schema_name
741
NULL information_schema
742
NULL mysql
743
NULL pbxt
744
NULL test
745
SELECT *
746
FROM information_schema.session_status
747
ORDER BY variable_name;
748
VARIABLE_NAME VARIABLE_VALUE
749
# #
750
# #
751
# #
752
# #
753
# #
754
# #
755
# #
756
# #
757
# #
758
# #
759
# #
760
# #
761
# #
762
# #
763
# #
764
# #
765
# #
766
# #
767
# #
768
# #
769
# #
770
# #
771
# #
772
# #
773
# #
774
# #
775
# #
776
# #
777
# #
778
# #
779
# #
780
# #
781
# #
782
# #
783
# #
784
# #
785
# #
786
# #
787
# #
788
# #
789
# #
790
# #
791
# #
792
# #
793
# #
794
# #
795
# #
796
# #
797
# #
798
# #
799
# #
800
# #
801
# #
802
# #
803
# #
804
# #
805
# #
806
# #
807
# #
808
# #
809
# #
810
# #
811
# #
812
# #
813
# #
814
# #
815
# #
816
# #
817
# #
818
# #
819
# #
820
# #
821
# #
822
# #
823
# #
824
# #
825
# #
826
# #
827
# #
828
# #
829
# #
830
# #
831
# #
832
# #
833
# #
834
# #
835
# #
836
# #
837
# #
838
# #
839
# #
840
# #
841
# #
842
# #
843
# #
844
# #
845
# #
846
# #
847
# #
848
# #
849
# #
850
# #
851
# #
852
# #
853
SHOW STATUS;
854
Variable_name Value
855
# #
856
# #
857
# #
858
# #
859
# #
860
# #
861
# #
862
# #
863
# #
864
# #
865
# #
866
# #
867
# #
868
# #
869
# #
870
# #
871
# #
872
# #
873
# #
874
# #
875
# #
876
# #
877
# #
878
# #
879
# #
880
# #
881
# #
882
# #
883
# #
884
# #
885
# #
886
# #
887
# #
888
# #
889
# #
890
# #
891
# #
892
# #
893
# #
894
# #
895
# #
896
# #
897
# #
898
# #
899
# #
900
# #
901
# #
902
# #
903
# #
904
# #
905
# #
906
# #
907
# #
908
# #
909
# #
910
# #
911
# #
912
# #
913
# #
914
# #
915
# #
916
# #
917
# #
918
# #
919
# #
920
# #
921
# #
922
# #
923
# #
924
# #
925
# #
926
# #
927
# #
928
# #
929
# #
930
# #
931
# #
932
# #
933
# #
934
# #
935
# #
936
# #
937
# #
938
# #
939
# #
940
# #
941
# #
942
# #
943
# #
944
# #
945
# #
946
# #
947
# #
948
# #
949
# #
950
# #
951
# #
952
# #
953
# #
954
# #
955
# #
956
# #
957
# #
958
# #
959
SELECT *
960
FROM information_schema.global_status
961
ORDER BY variable_name;
962
VARIABLE_NAME VARIABLE_VALUE
963
# #
964
# #
965
# #
966
# #
967
# #
968
# #
969
# #
970
# #
971
# #
972
# #
973
# #
974
# #
975
# #
976
# #
977
# #
978
# #
979
# #
980
# #
981
# #
982
# #
983
# #
984
# #
985
# #
986
# #
987
# #
988
# #
989
# #
990
# #
991
# #
992
# #
993
# #
994
# #
995
# #
996
# #
997
# #
998
# #
999
# #
1000
# #
1001
# #
1002
# #
1003
# #
1004
# #
1005
# #
1006
# #
1007
# #
1008
# #
1009
# #
1010
# #
1011
# #
1012
# #
1013
# #
1014
# #
1015
# #
1016
# #
1017
# #
1018
# #
1019
# #
1020
# #
1021
# #
1022
# #
1023
# #
1024
# #
1025
# #
1026
# #
1027
# #
1028
# #
1029
# #
1030
# #
1031
# #
1032
# #
1033
# #
1034
# #
1035
# #
1036
# #
1037
# #
1038
# #
1039
# #
1040
# #
1041
# #
1042
# #
1043
# #
1044
# #
1045
# #
1046
# #
1047
# #
1048
# #
1049
# #
1050
# #
1051
# #
1052
# #
1053
# #
1054
# #
1055
# #
1056
# #
1057
# #
1058
# #
1059
# #
1060
# #
1061
# #
1062
# #
1063
# #
1064
# #
1065
# #
1066
# #
1067
SELECT *
1068
FROM information_schema.table_constraints;
1069
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE
1070
SELECT table_schema, table_name
1071
FROM information_schema.tables
1072
WHERE table_name NOT LIKE 'MEMCACHED%'
1073
AND table_name NOT LIKE 'PBXT%'
1074
ORDER BY table_name;
1075
table_schema table_name
1076
information_schema CHARACTER_SETS
1077
information_schema COLLATIONS
1078
information_schema COLLATION_CHARACTER_SET_APPLICABILITY
1079
information_schema COLUMNS
1080
information_schema GLOBAL_STATUS
1081
information_schema GLOBAL_VARIABLES
1082
information_schema INNODB_CMP
1083
information_schema INNODB_CMPMEM
1084
information_schema INNODB_CMPMEM_RESET
1085
information_schema INNODB_CMP_RESET
1086
information_schema INNODB_LOCKS
1087
information_schema INNODB_LOCK_WAITS
1088
information_schema INNODB_TRX
1089
information_schema KEY_COLUMN_USAGE
1090
pbxt location
1091
information_schema MODULES
1092
information_schema PLUGINS
1093
information_schema PROCESSLIST
1094
information_schema REFERENTIAL_CONSTRAINTS
1095
information_schema SCHEMATA
1096
information_schema SESSION_STATUS
1097
information_schema SESSION_VARIABLES
1098
pbxt statistics
1099
information_schema STATISTICS
1100
information_schema TABLES
1101
information_schema TABLE_CONSTRAINTS
Loggerhead is a web-based interface for Breezy
Version: 2.0.1