Showing entries 1 to 2
Displaying posts with tag: mysql status variables (reset)
May
29
2014
How MySQL ‘queries’ and ‘questions’ are measured
Posted by MySQL Performance Blog on Thu 29 May 2014 10:00 UTC
Tags:

MySQL has status variables “questions” and “queries” which are rather close but also a bit different, making it confusing for many people. The manual describing it might not be very easy to understand: 

Queries
The number of statements executed by the server. This variable includes statements executed within stored programs, unlike the Questions variable. It does not count COM_PING or COM_STATISTICS commands.
 Questions
The number of statements executed by the server. This includes only statements sent to the server by clients and not statements executed within stored programs, unlike the Queries variable. This variable does not count COM_PING, COM_STATISTICS, COM_STMT_PREPARE, COM_STMT_CLOSE, or COM_STMT_RESET commands.

In a nutshell if you’re not using prepared statements the big difference between those is what …

[Read more]
Jan
09
2012
Tracking Server Variables, Documentation, Manuals, Changelogs for MySQL, InnoDB, MariaDB, and XtraDB
Posted by Chris Calender on Mon 09 Jan 2012 17:50 UTC
Tags:
innodb, MySQL Documentation, InnoDB plugin, maria variables, MySQL, chris calender, InnoDB Plugin Version History, InnoDB Plugin Versions, chris calendar, connector c++ change history, connector c++ changelogs, connector j change history, connector j changelogs, connector mxj change history, connector mxj changelogs, connector net change history, connector net changelogs, innodb documentation, innodb manual, innodb options, innodb plugin documentation, innodb plugin manual, innodb plugin version, innodb server variables, innodb variables, jdbc change history. mysql proxy changelogs, jdbc changelogs, maria options, mariadb change history, mariadb changelogs, mariadb documentation, mariadb manual, mariadb options, mariadb variables, myodbc change history, myodbc changelogs, mysql change history, mysql changelogs, mysql manual, mysql proxy change history, mysql server variables, mysql status variables, odbc change history, odbc changelogs, xtrabackup change history, xtrabackup changelogs, xtrabackup documentation, xtrabackup manual, xtradb change history, xtradb changelogs, xtradb documentation, xtradb manual

I find myself constantly looking up server variables (and manuals and changelogs) for MySQL, MariaDB, and XtraDB, which versions they are in, and so forth. So I finally created a couple pages which contain the links to all of these various bits of information across the various flavors of MySQL.

I’ve been using them every day, so I thought some others might want to bookmark these as well.

I’ve created the following:

o Changelogs
o Documentation
o Server Variables
o InnoDB Plugin Versions

The Changelogs page contains links for MySQL 3.23 up through 5.6, MariaDB 5.1 – 5.3, XtraDB 5.1 – 5.5, Xtrabackup 1.3 – …

[Read more]
Showing entries 1 to 2