Top "Mysql-management" questions

How to know about MySQL 'refused connections'

I am using MONyog to montitor my two mysql servers. I get alert emails from MONyog when something goes wrong. …

mysql logging monitoring mysql-management
How do i Setup utf-8 as standard character set for a mysql server?

do i have to recompile it? i figured out diffent ways of setting the character set values see http://dev.…

mysql utf-8 character-encoding mysql-management
MYSQL Temporary Tables - How to view active ones

We have a simple "crm-like" software in our company. There are some complex queries that were taking some time, daily-use …

mysql mysql-management temp-tables
Configuring MySQL server to avoid "MySQL Server has gone away" error

When I tried to establish a MySQL database using a dump, I got the following error message ERROR 2006 (HY000) at …

mysql mysqldump mysql-management
File './mysql-bin.index' not found on MySql startup on OSX 10.5

I did a manual setup for the installation of MySql 5.5 on mac OSX 10.5 instead of using .dmg package installer. After …

mysql mysql-management osx-leopard
MySql - replication monitoring tool

I have a master/slave MySql replication. Im looking for a tool that will allow me to monitor the replication (…

mysql mysql-management
how to reset all mysql stats?

I can't seem to find a way to reset all the mysql stats (that show in the 'Stats' page in …

mysql phpmyadmin mysql-management
What does the MySQL Query cache Hitrate % value respesent?

Using MySQL Workbench I am looking at the Admin view for two servers I run. Both servers have a similar …

mysql mysql-management query-cache
Can MySQL reliably restore backups that contain views or not?

Environment: Ubuntu 11.10, MySQL 5.1.58 I have a small database with views. When I try to dump and restore, I get ERROR 1356 (…

mysql mysqldump mysql-management
Mac OS X mySQL custom database path (MAMP PRO)

I'm using MAMP (OS-X 10.6.6) and I want to move my mySQL db folder to my dropbox folder. The MySQL server …

mysql macos mamp mysql-management