MySQL version 5.0 - please also tag with mysql for search purposes.

learn more… | top users | synonyms

0
votes
2answers
152 views

Large query with subquery runs indefinitely after mysql update

We recently did a big server update, in the process migrating from mysql-5.0 to 5.5.40 Several of the queries, which had been running well on the old server, now grind everything to a screeching halt. ...
2
votes
1answer
56 views

Opening MySQL connection is sometimes very slow

I have a very weird issue with an older MySQL server (v5.0.45) and a Java application. From time to time getting a connection from the database takes 7 seconds, 15 seconds, 30 seconds etc (most of ...
1
vote
1answer
14 views

Can I remove binary log files not listed in mysql-bin.index?

We've had some problems with one of our more elderly MySQL servers (version 5.045). The database is back up and running OK but there were over twenty thousand binary log files in the mysql folder. I ...
0
votes
1answer
103 views

MySQL database dump bombs out Error 1064 when using LOCK TABLES

This specific machine is running MySQL version 5.0.27. I have tried to get a full dump of this database several times and each time it bombs out. Tried getting just a structure dump of it and this is ...
0
votes
0answers
37 views

MySQL output out of order

I have a bash script which read locks all tables of two databases of a MySQL server, which have the same structures, flush the database and rsync the MYI, MYD and FRM files from one of the locked ...
0
votes
0answers
103 views

Enable general_log in Mysql 5.0.96

I want to enable general_log in MySql 5.0.96. I have set log variable but it isn't working. [mysqld] log=/var/log/mysql.log and restart mysql with following command /etc/init.d/mysql restart But ...
0
votes
0answers
150 views

CREATE VIEW joining two tables, only displaying rows from the first table with the most recent date in the second table

I have multiple tables. My main table has a composite key consisting of a phone number and an order number. I want to create a VIEW where only the subscriptions with the most recent order date are ...