MySQL practical knowledge 3

Solve the Problem of freezing mysql-query-browser

After I upgrade my system to Ubuntu 8.04, mysql-query-browser will be frozen after I click the database. After searching for a method on the internet, you need to modify a file in the source code.

Find the mysql-gui-tools-5.0r12/mysql-query-browser/source/linux/MQQueryDispatcher. cc file, comment out the lines 561,562 and recompile them.

Gtk: Main: instance ()-> run ();

// While (! Req-> is_complete ())

//;

Return sps;

How to solve mysql errors when deploying jbpm process definition files in myeclipse

A mysql error occurred when deploying the fristFlow process definition file today. From the log, the connection between the Tomcat server and the MySQL server is lost. I checked the cause on the Internet and added a database connection pool configuration code to the hibernate. cfg. xml file, but I still don't know why.

We recommend that you use c3p0 to configure the connection pool for hibernate, and then configure idle_test_period for the anti-idle configuration of c3p0, as long as it is less than the wait timeout of MySQL.

How to handle a large mysql-bin.00000x file after mysql opens the bin-log

After enabling the binary log, if the time is 1 litre, there will be a log is too large, is playing a lot of mysql-bin.00000x such log files

You can log on to MYSQL:

Mysql> reset master

You can clear these files.

However, note that if the synchronization function of log operations such as log transmission is enabled, you must wait for log synchronization before performing this operation. Otherwise, the master and slever databases may be inconsistent.