New answers tagged mysql-workbench
The options file in MySQL is a human-readable text file, typically called my.cnf on Unix and my.ini on Windows. This single file contains configuration entries for all things MySQL, including the server, and the client library, and the various other official client utilities. The screen you're referring to is a glorified configuration file editor for that ...
--no-beep is an option for the mysql command-line query tool, not for mysqldump. I would guess that you have entered the no-beep in your my.cnf configuration file under the [client] section, which applies to both mysql and mysqldump clients. You need to move no-beep to the [mysql] section of the config file, so it applies only to the mysql client.
What you need is a better visual representation of the InnoDB Storage Engine Think about the kind of things that trigger writes that can be monitored Number of Write Operations Innodb_dblwr_writes to the Double Write Buffer Redo Logs Innodb_os_log_writes and Innodb_os_log_pending_writes : Logical Innodb_os_log_fsyncs and Innodb_os_log_pending_fsyncs : ...
SHOW PROCESSLIST is what I would use, if I were in a hurry. Rolando has written a great post on determining what DML (data modification language) queries are being run and what they are modifying. As to the SELECTs, SHOW PROCESSLIST is your best bet or Jet Profiler if your looking for something with a GUI. You can also query the InnoDB Engine directly to ...
Top 50 recent answers are included