mariadb-dumpslow.1 - Online Linux Manual Page

\FBMYSQLDUMPSLOW\FR - Online Linux Manual PageSection : 1
Updated : 27 June 2019
Source : MariaDB 10\&.5
Note : MariaDB Database System

NAMEmysqldumpslow − Summarize slow query log files

SYNOPSISmysqldumpslow [options] [log_file ...]

DESCRIPTIONThe MariaDB slow query log contains information about queries that take a long time to execute. mysqldumpslow parses MariaDB slow query log files and prints a summary of their contents. Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. It ‟abstracts” these values to N and ´S´ when displaying summary output. The −a and −n options can be used to modify value abstracting behavior. Invoke mysqldumpslow like this: shell> mysqldumpslow [options] [log_file ...]mysqldumpslow supports the following options. • −−help Display a help message and exit. • −a Do not abstract all numbers to N and strings to ´S´. • −−debug, −d Run in debug mode. • −g pattern Consider only queries that match the (grep−style) pattern. • −h host_name Host name of MariaDB server for *−slow.log file name. The value can contain a wildcard. The default is * (match all). • −i name Name of server instance (if using mysql.server startup script). • −l Do not subtract lock time from total time. • −n N Abstract numbers with at least N digits within names. • −r Reverse the sort order. • −s sort_type How to sort the output. The value of sort_type should be chosen from the following list: • t, aa: Sort by rows affected or average rows affected • l, ae: Sort by rows examined or aggregate rows examined • l, at: Sort by query time or average query time • l, al: Sort by lock time or average lock time • s, as: Sort by rows sent or average rows sent • c: Sort by count • −t N Display only the first N queries in the output. • −−verbose, −v Verbose mode. Print more information about what the program does. Example of usage: shell> mysqldumpslow Reading mysql slow query log from /usr/local/mysql/data/mysqld51−apple−slow.log Count: 1 Time=4.32s (4s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost insert into t2 select * from t1 Count: 3 Time=2.53s (7s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost insert into t2 select * from t1 limit N Count: 3 Time=2.13s (6s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost insert into t1 select * from t1

COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc., 2010-2019 MariaDB Foundation This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA or see http://www.gnu.org/licenses/.

SEE ALSOFor more information, please refer to the MariaDB Knowledge Base, available online at https://mariadb.com/kb/

AUTHORMariaDB Foundation (http://www.mariadb.org/). 0

Johanes Gumabo

Data Size : 20,690 byte
man-mariadb-dumpslow.1Build : 2024-12-05, 20:55 :
Visitor Screen : x
Visitor Counter ( page / site ) : 4 / 182,919
Visitor ID : :
Visitor IP : 18.191.218.234 :
Visitor Provider : AMAZON-02 :
Provider Position ( lat x lon ) : 39.962500 x -83.006100 : x
Provider Accuracy Radius ( km ) : 1000 :
Provider City : Columbus :
Provider Province : Ohio , : ,
Provider Country : United States :
Provider Continent : North America :
Visitor Recorder : Version :
Visitor Recorder : Library :
Online Linux Manual Page : Version : Online Linux Manual Page - Fedora.40 - march=x86-64 - mtune=generic - 24.12.05
Online Linux Manual Page : Library : lib_c - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Online Linux Manual Page : Library : lib_m - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Data Base : Version : Online Linux Manual Page Database - 24.04.13 - march=x86-64 - mtune=generic - fedora-38
Data Base : Library : lib_c - 23.02.07 - march=x86-64 - mtune=generic - fedora.36

Very long time ago, I have the best tutor, Wenzel Svojanovsky . If someone knows the email address of Wenzel Svojanovsky , please send an email to johanes_gumabo@yahoo.co.id .

If error, please print screen and send to johanes_gumabo@yahoo.co.id
Under development. Support me via PayPal.