Skip to content

Instantly share code, notes, and snippets.

@Nitrodist
Created November 30, 2011 10:59
Show Gist options
  • Save Nitrodist/1408678 to your computer and use it in GitHub Desktop.
Save Nitrodist/1408678 to your computer and use it in GitHub Desktop.
MariaDB [btt]> select * from searches;
+----+--------------+---------------------+---------------------+
| id | query | created_at | updated_at |
+----+--------------+---------------------+---------------------+
| 1 | Nitrodist | 2011-11-30 10:44:53 | 2011-11-30 10:44:53 |
| 2 | MurrayMoman | 2011-11-30 10:45:02 | 2011-11-30 10:45:02 |
| 3 | Juiceman8181 | 2011-11-30 10:45:08 | 2011-11-30 10:45:08 |
+----+--------------+---------------------+---------------------+
3 rows in set (0.00 sec)
MariaDB [btt]> show session status like '%cost%';
+-----------------+----------+
| Variable_name | Value |
+-----------------+----------+
| Last_query_cost | 1.599000 |
+-----------------+----------+
1 row in set (0.10 sec)
MariaDB [btt]> select query from searches;
+--------------+
| query |
+--------------+
| Nitrodist |
| MurrayMoman |
| Juiceman8181 |
+--------------+
3 rows in set (0.00 sec)
MariaDB [btt]> show session status like '%cost%';
+-----------------+----------+
| Variable_name | Value |
+-----------------+----------+
| Last_query_cost | 1.599000 |
+-----------------+----------+
1 row in set (0.00 sec)
MariaDB [btt]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment