equal
deleted
inserted
replaced
61 |
61 |
62 Server version, platform, etc:: |
62 Server version, platform, etc:: |
63 |
63 |
64 [mysql]> SHOW VARIABLES LIKE "%version%"; |
64 [mysql]> SHOW VARIABLES LIKE "%version%"; |
65 |
65 |
66 Debugging. |
66 Debugging queries error. |
67 ========== |
67 ======================== |
68 |
68 |
69 After error or warning run:: |
69 After error or warning run:: |
70 |
70 |
71 MariaDB [mysql]> SHOW WARNINGS; |
71 MariaDB [mysql]> SHOW WARNINGS; |
72 MariaDB [mysql]> SHOW ERRORS; |
72 MariaDB [mysql]> SHOW ERRORS; |
73 MariaDB [mysql]> show engine innodb status; |
73 MariaDB [mysql]> show engine innodb status; |
74 |
74 |
|
75 Monitor server execution. |
|
76 ========================= |
|
77 :: |
|
78 |
|
79 MariaDB [mysql]> SHOW PROCESSLIST; |
|
80 |
|
81 Profiling queries. |
|
82 ================== |
|
83 |
|
84 Enable profiling, execute query and review profiling data:: |
|
85 |
|
86 [mysql]> set profiling=1; |
|
87 [mysql]> select 1; |
|
88 [mysql]> show profile; |
|
89 |
|
90 Each profiled query results stored separately. To get list of results:: |
|
91 |
|
92 [mysql]> show profiles; |
|
93 |
|
94 To retrieve selected profiling data:: |
|
95 |
|
96 [mysql]> show profile for query 1; |
|
97 |