Stack Overflow
Stack Overflow

Questions tagged [mysqldumpslow]

Mysqldumpslow parses MySQL 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.

19 questions
7
votes
1 answer

How to log mySQL queries without indexes?

I see there is a nice option how to enable log slow queries and queries without indexes: SET GLOBAL log_queries_not_using_indexes=1; SET GLOBAL log_slow_queries=1; OK, OK, but it seems both write in the same log file I have specified at my.cnf…
Jakub Mach
  • 1,109
  • 3
  • 10
  • 19
7
votes
3 answers

Where do I find the MysqlDumpSlow command?

Hi I'm logging slow queries because we're having some performance issues and I have read about mysqldumpslow and thought that would be a good way to sort through the queries. At the command prompt, I type mysqldumpslow and I get…
Charles Faiga
  • 11,665
  • 25
  • 102
  • 139
3
votes
2 answers

How to analyse MySQL Slow Query Log or MySQL General Query Log?

Analysing logs is a major problem. If you have a legacy code and hundreds and thousands of queries running, you are bound to be confused by what to improve and where to improve and how much to improve because there is always a tradeoff between how…
MontyPython
  • 2,906
  • 11
  • 37
  • 58
3
votes
1 answer

how to stop mysqldump from recording as slow queries

Im recording slow queries longer than 2 seconds. That is running fine except, the daily backups also get recorded in slow log because 1) mysqldump calls select * from xyz (big table); and 2) when inserting the backup into a new db (yesterday's…
thevikas
  • 1,618
  • 1
  • 14
  • 31
3
votes
1 answer

Mysqldump taking too much time

MySQLdump and upload process taking too long time (~8 hr) to complete the whole process. I am dumping active database into mysqldump.tar file and almost 3gb. When I load into new database its taking 6-8 hr to complete the process (upload into new…
Mahe
  • 29
  • 1
  • 4
2
votes
2 answers

Interpreting mysqldumpslow results

I have modified mysql config to log slow queries slow_query_log = 1 slow_query_log_file = /var/log/mysql/mysql-slow.log long_query_time = 2 log-queries-not-using-indexes And interpreting them with mysqldumpslow. One of the results is as…
sitilge
  • 3,687
  • 4
  • 30
  • 56
2
votes
1 answer

For MySQLDump, add a comment which outputs how many rows were dumped for each table

I would like to add a comment which outputs the number of rows that were dumped for each table, for MySQLDump. For this I need to modify the file client/mysqldump.c. An example output could be like this: -- Table structure for table t1 DROP TABLE…
Rahul Gulati
  • 363
  • 1
  • 4
  • 16
2
votes
1 answer

mysqldumpslow: What does these fields indicate..?

Recently we have started on optimizing live slow queries. As part of that, we thought to use mysqldumpslow to prioritize slow queries. I am new to this tool. I am able to understand some basic info, but I would like to know what exactly the below…
Uday
  • 1,480
  • 4
  • 27
  • 44
1
vote
1 answer

How can I turn on MySql Slow Queries in runtime?

Is there any way to turn Slow queries on when MySQL server in running? Because i cannot restart MySQL server since the manager in on vacation!
user899205
1
vote
0 answers

Slow MySQL restore after mysqldump

I did mysqldump and when I try to restore it: mysql -u root -pmypassword dbname < dump.sql it says: mysql: [Warning] Using a password on the command line interface can be insecure and takes pause about 10 sec, even if dump.sql is very small. It's…
Rattrap
  • 295
  • 4
  • 13
1
vote
1 answer

Died at /usr/bin/mysqldumpslow line 162

mysqldumpslow -s c -t 15 -v /tmp/my-slow.log >> /tmp/file_date +'%d_%m_%Y_%H_%M_%S'.log Reading mysql slow query log from /tmp/my-slow.log Died at /usr/bin/mysqldumpslow line 162, <> chunk 18.
Vladimir Knysh
  • 29
  • 4
1
vote
0 answers

mysqldumpslow write output to file

Is there a way to write the mysqldumpslow command output to a file? I tried /usr/bin/mysqldumpslow log_file /var/log/mysql/log-slow-queries.log > /var/log/mysqldumpslow.log but I get an error saying mysqldumpslow can't find the log_file. Excuse my…
Thomas G
  • 100
  • 9
0
votes
0 answers

How to optimize mysqldump which is not allowing to connect to database when run

I am facing issue of mysqldump, when I try to backup db (which is more than 200GB) using mysqldump it stops my connection to databass. I keep getting error of "too many connection", website also does not load, give error unable to connect to db.…
Fareed Qureshi
  • 1
0
votes
0 answers

When I try to restore the sql file with mysqldump, I get "ERROR 1874 (HY000) at line 42: InnoDB is in read only mode." I get the error

When I try to restore the sql file with mysqldump, I get "ERROR 1874 (HY000) at line 42: InnoDB is in read only mode." I get the error. "SET GLOBAL read_only = OFF; " I tried this and it didn't change, so I changed my.conf but I still get the same…
박승제
  • 1
  • 1
0
votes
0 answers

MySQL Dump Importing Speed Super Slow for my Kuberenetes MySQL Pod

I am migrating my MySQL database from bare metal setup to Kubernetes. So I have exported a MySQL dump with size of around 8.9GB and uploaded the MySQL dump on my Kubernetes master node. The dump is inserted using the command kubectl exec -it…
ony4869
  • 1
  • 1
1
2