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
0
votes
1 answer

macOS: zsh: command not found: mysqldump

I hope, it's the right forum for this question. But since there exist a mysqldump tag I think so. I'm using a Mac with macOS Catalina 10.15.7 (19H524). Since I reinstalled Homebrew and therefore also deleted some folders, mysqldump isn't working any…
David
  • 2,898
  • 3
  • 21
  • 57
0
votes
1 answer

How can I keep queries like this out of mysql_slow.log?

I have the following query I need help with. SELECT a.artist, a.facepic FROM artists_vs AS v, artists AS a WHERE v.genreid =0 AND (v.artistid1 = a.artistid OR v.artistid2 = a.artistid) ORDER BY v.bid DESC LIMIT 20 All the fields in the query are…
ryanneufeld
  • 157
  • 1
  • 4
0
votes
0 answers

mysql dump and restore slow

I backup mysql data with mysqldump command: mysqldump -uroot -pbuild testDB > ./testDB.sql And restore it from the testDB.sql file with command: source testDB.sql The testDB.sql file is 1.8GB, and restore it in my local computer(Mac pro os10.10…
fcbflying
  • 57
  • 5
0
votes
2 answers

Move database to another server

I am using mysqldump to move my database to another sever. But database has tables with million of rows and mysql restore takes too long(4 houres). is there any way I do this faster?
Mehdi Azizi
  • 187
  • 2
  • 10
1
2