Mysql – format of thesql query log

MySQLperformanceslow-log

What is the format of the mysql query log? In particular, for lines like:

133 Query     commit
133 Query     rollback

What does '133' stand for? And is it true that each line represents a round trip communication to the database (i.e., they are not batched)?

Best Answer

A typical general log format looks like this:

Time              Id Command    Argument
110208 12:12:06   771 Query rollback

Multiple queries can appear at particular time-stamp also ID indicates MySQL connection thread id which has executed a query Command of type "Query" which indicates query has been executed and Argument is actually a query itself.

Related Solutions

Mysql – Help optimizing query in the MySQL slow-query log

I think one issue is the shortened lengths of these two indexes in the credential_pairs table:

KEY `primary_credential_id` (`primary_credential_id`(10)),
KEY `secondary_credential_id` (`secondary_credential_id`(10))

Another thing is the datatype of the data column. Can you change it from blob to VARCHAR?

Mysql – What language and data structures does MYSQL uses as backend

MySQL can be compiled in C/C++ and you can download the source code to do so.

At this link, Under the Select Platform ComboBox, Select Source Code and Download it from there

The .frm , .MYD, and .MYI make up a MyISAM table

For example, the user table for the mysql grants is amde up of three files

/var/lib/mysql/mysql/user.frm (Table Structure for any Storage Engine)
/var/lib/mysql/mysql/user.MYD (MyISAM Table Data)
/var/lib/mysql/mysql/user.MYI (MyISAM Table Indexes)

Best Answer

Related Solutions

Mysql – Help optimizing query in the MySQL slow-query log

Mysql – What language and data structures does MYSQL uses as backend

Related Question