Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mysql-5]

Generic MySQL version 5 tag. Please use a mysql-5.x tag instead. Also tag with mysql for search purposes.

There are still thousands of users in the world using older version of MySQL.

Such versions include GA release of MySQL 5.1

  • 5.1.30 being the first GA
  • Some are using 5.1 releases prior to 5.1.30 in production at their own risk
  • Some are using MySQL 5.0, 4.1 and 4.0 and even 3.23.58
178 questions
152
votes
4 answers

Is it safe to delete mysql-bin files?

I have MM Replication in mysql, and I want to squeeze some free space in the box be deleting unnecessary files, I came across these mysql-bin files inside /var/db/mysql/ There are hundreds of those files like mysql-bin.000123, mysql-bin.000223 etc.…
user18530
112
votes
3 answers

ALTER TABLE - Rename a column

This is driving me nuts! I want to rename a column from read-more to read_more in my blog table I tried all this: ALTER TABLE blog RENAME COLUMN read-more to read_more; ALTER TABLE blog CHANGE COLUMN 'read-more' 'read_more' VARCHAR(255) NOT…
Bojan
  • 1,123
  • 2
  • 7
  • 4
111
votes
3 answers

What is the default order of records for a SELECT statement in MySQL?

Suppose you have the following table and data: create table t ( k int, v int, index k(k) ) engine=memory; insert into t (k, v) values (10, 1), (10, 2), (10, 3); When issuing select * from t where k = 10 with no order…
daisy
  • 1,338
  • 3
  • 11
  • 17
64
votes
8 answers

Restore mysql database with different name

How can we restore mysql database with different name from mysqldump file. I dont't want to open dump file and edit it. Any other better methods?
Praveen Prasannan
  • 1,546
  • 6
  • 25
  • 38
51
votes
6 answers

In MySQL, does the order of the columns in a WHERE clause affect query performance?

I am having performance issues on certain database queries that have large possible result sets. The query in question, I have three ANDs in the WHERE clause Does the order of the clauses matter? As in, if I put the ASI_EVENT_TIME clause first…
Patrick
  • 4,329
  • 7
  • 29
  • 28
45
votes
2 answers

InnoDB: Error: Table "mysql"."innodb_table_stats" not found after upgrade to mysql 5.6

I upgraded to mysql 5.6 from 5.5, and now my logs are littered with such messages on startup I found a possible solution here, but it does not seem official. http://forums.mysql.com/read.php?22,578559,579891#msg-579891 2013-12-06 21:08:00…
giorgio79
  • 1,407
  • 7
  • 19
  • 19
43
votes
1 answer

How long is "too long" for MySQL Connections to sleep?

I logged onto my server to check the status of the database and noticed on the SHOW PROCESSLIST; that there are a large number of connections sleeping that are very old. What duration should the connection time limit be before the connection should…
Patrick
  • 4,329
  • 7
  • 29
  • 28
30
votes
3 answers

Why query_cache_type is disabled by default start from MySQL 5.6?

We've upgraded to MySQL 5.6 and start seeing the loading of db server increased significantly, and finally found out the query_cache_type is defaulted to off start from 5.6. We enabled it again and see the loading decrease, why this value is being…
Yoga
  • 549
  • 3
  • 8
  • 15
22
votes
1 answer

How soon after updating expire_logs_days param and restarting sql will old binlogs get deleted?

MySQL 5.1.x | InnoDB | Windows My mysql data directory is starting to fill up with bin logs. I currently have the following settings configured in my windows mysql server:…
Mike B
  • 617
  • 4
  • 10
  • 17
20
votes
3 answers

Set "lock wait timeout" in MySQL

Where would I set the maximum time a query will wait for a lock in MySQL 5.0.68 before timing out?
Gaius
  • 11,238
  • 3
  • 32
  • 64
19
votes
1 answer

How to get rid of "maximum user connections" error?

I am using MySQLi for my webapp but whenever I want to visit some particular page, I get mysqli_connect() [function.mysqli-connect]: (42000/1203): User ***_user already has more than 'max_user_connections' active connections. I tried already to…
ahmed
  • 293
  • 1
  • 2
  • 4
18
votes
3 answers

Why does importing a 12 GB .sql file take more than 36 hours?

I've been waiting now for 36 hours for a 12 GB .sql file to be imported with a simple type site.sql | mysql command. I can see the ibdata1 is growing still, currently nearly 40 GB. Considering the triggers and stored procedures are at the end of the…
servermanfail
  • 365
  • 1
  • 4
  • 7
15
votes
3 answers

Speeding up conversion of MyISAM to InnoDB

I've got a mysql 5.1 server with a database of approximately 450 tables, taking up 4GB . The vast majority of these tables (all but 2) are MyIsam. This has been fine for the most part (don't need transactions), but the application has been gaining…
Derek Downey
  • 23,568
  • 11
  • 79
  • 104
14
votes
2 answers

What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?

I am very new to Database Administration. I face a lot of problems while setting up mysql master-slave replication. I also face regular mysql replication troubleshooting issues. Can anybody helps to understand how should i deal with all these?
Abdul Manaf
  • 9,587
  • 16
  • 73
  • 84
13
votes
4 answers

Can't remote access MySQL server running on Mac OS X

I have a MySQL server running on my work computer, which runs Mac OS X Maverick. I want to access it from home computer, which also has Mac OS Maverick. From terminal, if in 1 tab, I ssh into my work computer and just let the ssh session sit there…
chepukha
  • 231
  • 1
  • 2
  • 3
1
2 3
…
11 12