Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>To enable full Log Query add the following to your my.cnf:</p> <pre><code>log=/var/log/mysqldquery.log </code></pre> <p>The above will log all queries to the log file.</p> <p>Don't forgot to restart mysql service after making changes in my.cnf file.</p> <p>Example output from actions via SequelPro (mac client):</p> <pre><code>090721 11:06:45 51 Query ALTER TABLE `test` ADD `name` varchar(10) DEFAULT NULL 51 Query SHOW COLUMNS FROM `test` 51 Query SHOW INDEX FROM `test` 090721 11:06:57 51 Query SHOW COLUMNS FROM `test` 51 Query UPDATE `test` SET `id`='1', `name`='test' WHERE `id` = '1' AND `name` IS NULL LIMIT 1 51 Query SELECT * FROM `test` LIMIT 0,100 51 Query SELECT COUNT(1) FROM `test` 090721 11:07:00 51 Query UPDATE `test` SET `id`='2', `name`='test' WHERE `id` = '2' AND `name` IS NULL LIMIT 1 51 Query SELECT * FROM `test` LIMIT 0,100 51 Query SELECT COUNT(1) FROM `test` </code></pre> <p>On *NIX based systems you can use grep to start</p> <pre><code>grep 'SELECT\|INSERT\|UPDATE' querylog.log </code></pre> <p>Or get more tricky and start doing things like:</p> <pre><code>grep 'SELECT\|INSERT\|UPDATE' querylog.log | awk '{$1="";$2="";print}' </code></pre> <p>This would give you something like this, not perfect but closer:</p> <pre><code> 51 Query UPDATE `test` SET `id`='2', `name`='test' WHERE `id` = '2' AND `name` IS NULL LIMIT 1 SELECT * FROM `test` LIMIT 0,100 SELECT COUNT(1) FROM `test` 51 Query INSERT INTO `test` (`id`,`name`) VALUES ('3','testing') SELECT * FROM `test` LIMIT 0,100 SELECT COUNT(1) FROM `test` </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow do I log just the raw queries in MySQL?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USIan
    1. USIan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow do I log just the raw queries in MySQL?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI would rather replace the first x characters after the grep: sed 's/^.{x}//'
      singulars
      1. PO
      1. USsoulmerge
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload