equal
deleted
inserted
replaced
7 :local: |
7 :local: |
8 |
8 |
9 SQL clients. |
9 SQL clients. |
10 ============ |
10 ============ |
11 |
11 |
12 https://mariadb.com/kb/en/mariadb/clients-and-utilities/ |
12 https://mariadb.com/kb/en/mariadb/clients-and-utilities/ |
13 Clients and Utilities. |
13 Clients and Utilities. |
14 https://mariadb.com/kb/en/mariadb/graphical-and-enhanced-clients/ |
14 https://mariadb.com/kb/en/mariadb/graphical-and-enhanced-clients/ |
15 Graphical and Enhanced Clients. |
15 Graphical and Enhanced Clients. |
16 |
16 |
17 mysql. |
17 mysql. |
18 ------ |
18 ------ |
19 |
19 |
20 Official client. Install ``mariadb-client`` package - ``mysql`` utility |
20 Official client. Install ``mariadb-client`` package - ``mysql`` utility |
123 |
123 |
124 explain select 1; |
124 explain select 1; |
125 |
125 |
126 .. |
126 .. |
127 |
127 |
128 https://mariadb.com/kb/en/mariadb/explain/ |
128 https://mariadb.com/kb/en/mariadb/explain/ |
129 Syntax and transcription of EXPLAIN. |
129 Syntax and transcription of EXPLAIN. |
130 |
130 |
131 Monitor server execution. |
131 Monitor server execution. |
132 ========================= |
132 ========================= |
133 |
133 |
134 List all current executions:: |
134 List all current executions:: |
151 to ensure for which query plan shown becase query may finished and new |
151 to ensure for which query plan shown becase query may finished and new |
152 started. |
152 started. |
153 |
153 |
154 See: |
154 See: |
155 |
155 |
156 * `SHOW EXPLAIN in MariaDB 10.0 vs EXPLAIN FOR CONNECTION in MySQL 5.7 |
156 * `SHOW EXPLAIN in MariaDB 10.0 vs EXPLAIN FOR CONNECTION in MySQL 5.7 |
157 <http://s.petrunia.net/blog/?p=89>`_ |
157 <http://s.petrunia.net/blog/?p=89>`_ |
158 |
158 |
159 Profiling queries. |
159 Profiling queries. |
160 ================== |
160 ================== |
161 |
161 |
162 Enable profiling, execute query and review profiling data:: |
162 Enable profiling, execute query and review profiling data:: |