Questions tagged [mysql5.5]
MySQL RDBMS version 5.5
135
questions
71
votes
18
answers
130k
views
`mysql_upgrade` is failing with no real reason given
I'm upgrading from MySQL 5.1 to 5.5, running mysql_upgrade and getting this output:
# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
FATAL ERROR: Upgrade failed
...
- 1,187
20
votes
3
answers
51k
views
Cant connect to mysql using self signed SSL certificate
After creating a self-signed SSL certificate, I have configured my remote MySQL server to use them (and SSL is enabled)
I ssh into my remote server, and try connecting to its own mysqld using SSL (...
- 561
15
votes
4
answers
23k
views
Variable 'general_log_file' can't be set to the value of '/var/lib/msyql/ubuntu.log'
I changed the value of mysql's general_log_file variable to something else, and now I'm trying to change it back to what it was originally, /var/lib/mysql/ubuntu.log. But when I do:
SET GLOBAL ...
15
votes
1
answer
1k
views
All MySQL Databases lost overnight
After a call from a customer to say that his website is down, I find that MySQL on our RackSpace Cloud Windows 2008 server was not running. I restarted MySQL but got the 'Access denied for user' error ...
- 151
12
votes
4
answers
49k
views
Slave replication stops with Last_SQL_Errno: 1032
I have added an extra Slave server to an existing MySQL Replication. The Master server and the old Slave server are working fine without any issue, but the newly added server is stoping with the ...
- 397
9
votes
1
answer
22k
views
Is It key_buffer or key_buffer_size?
I search the internet regarding the correct variable in my.cnf file. Some said that key_buffer_size is deprecated, but some said that key_buffer_size is the correct variable in my.cnf.
So, what is ...
- 299
8
votes
4
answers
20k
views
enabling ssl connection from wordpress to mysql
I have been searching on how to configure wordpress to connect to mysql db over ssl, however most of the example are about three to five years old e.g. this wordpress support topic
my wordpress ...
- 537
7
votes
1
answer
5k
views
MySQL Slave stuck on a single bin log + bin log position for 17+ hours
tl;dr: Replication is stalled on a specific binlog and position, and I'm not sure why
I have a MySQL Replication setup with MySQL 5.5.
This replication setup has no history of ever falling behind ...
- 1,187
6
votes
3
answers
16k
views
Maximum execution time of 300 seconds exceeded error while importing large MySQL database
I'm trying to import 641 MB MySQL database with a command:
mysql -u root -p ddamiane_fakty < domenyin_damian_fakty.sql
but I got an error:
ERROR 1064 (42000) at line 2351406: You have an error ...
- 568
6
votes
1
answer
5k
views
Recover a crashed MySQL master server from the slave
we are building a simple master/slave MySQL configuration using asynchronous replication, with MySQL enterprise 5.5.17 on both servers and innoDB based tables. In case of a crash of the master server ...
- 61
5
votes
0
answers
3k
views
Invalid key length error when trying to connect phpmyadmin to remote MySql over SSL
I get these error messages when logging in to phpmyadmin instance
Error during session start; please check your PHP and/or webserver log file and configure your PHP installation properly. Also ...
- 537
4
votes
2
answers
10k
views
MySQL 5.1 vs MySQL 5.5 (5.1 twice as fast)
I recently installed MySQL 5.1 on CentOS 6.2 and had a performance gain over the MySQL 4.1 we are running. So I upgrade the MySQL 5.1 to MySQL 5.5 to see if there was even more of a gain but it ...
- 295
4
votes
2
answers
6k
views
MySQL not releasing temp file descriptors
Since a few days ago, we’ve been experiencing some serious problems with our MySQL installation: MySQL keeps opening temporal files (normal behaviour) but these files are never released. The ...
- 193
4
votes
1
answer
3k
views
How to Install and Run multiple MySQL Servers versions on centos? [closed]
I am new to MySQL database and I would like to install and run multiple MySQL server versions in CentOS server.
I have done following things but no luck.
Installed mysql 5.1.86 with default ...
- 49
3
votes
2
answers
1k
views
MySQL 5.5 InnoDB = OFF?
We run a server with MySQL 5.5. 95% of the tables are set to the InnoDB engine.
However whenever I look at the my.ini file (using the MySQL Workbench) under mysqld section innodb is unchecked and OFF ...
- 1,089
3
votes
1
answer
2k
views
How do I configure rsyslog to deal with MySQL Slow Query Log multi-line messages?
Using rsyslog v8.2.2, I would like to group multi-line messages, such as those output by the MySQL Slow Query log.
Each new message begins with three consecutive lines having '#' as the first char of ...
- 1,895
3
votes
1
answer
638
views
CSV engine on MySQL server
I don't think that this is a programming question so I am going to ask it here -
Reading the book high performance mysql, I read about the CSV engine. The paragraph says:
The CSV engine can treat ...
- 1,089
3
votes
1
answer
8k
views
MySQL - The server quit without updating PID file
I have installed MySQL 5.6.16 on Debain 7.4.
But i encountered problems with starting mysql, where every time i start mysql i get this error:
The server quit without updating PID file (/var/run/...
- 131
3
votes
2
answers
3k
views
Does mysql connection error count ever flush or will the host eventually get blocked?
During performance testing of our application I found that under extreme loads one problem that can occur is the occasional mysql connection error (i.e. at this stage I don't believe it is fair to ...
- 968
3
votes
0
answers
96
views
script cannot connect to Mysql server Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Mysql server seems working properly and running also i can connect to the database via ssh command, here's the my.cnf file directives:
[mysqld]
#port=3306
datadir=/home/mysql
socket=/home/mysql/mysql....
- 31
3
votes
1
answer
970
views
OpenShift/MySQL error: lower_case_table_names error when migrating from OS X to OpenShift
Ok, so I have dumped a MySQL 5.x database from an OS X instance, and am having problems importing the database into the OpenShift MySQL 5.5 container. My tables are Camel-case (eg "tblAccounts") but ...
- 31
3
votes
1
answer
1k
views
High CPU on MySql Fusion-io server
I've just finished reading this old Q&A which had some really good detailed information on a similar setup to ours, though unfortunately our problem (now) is not with replication.
MySQL ...
- 31
2
votes
1
answer
1k
views
Changing MySQL datadir on active server
I have a server that seems to be setup wrong by previous administrator..
The server has two disks, disk 0 which is the operating system (RAID1 clone)
disk 1 which is 3 drives in a RAID5 setup with ...
- 1,089
2
votes
3
answers
2k
views
Find which mysql is running
I have installed mysql 5.5 and percona 5.5 in the same machine. I am not able to identify wheather the running db is mysql or percona. IS there is any way to identify the difference.
- 121
2
votes
2
answers
6k
views
Upgrading MySQL 5.5 to 5.6
I've decided to do the update of MySQL from 5.5 to 5.6 on my CentOS server. How can I backup MySQL5.5 in case I want to downgrade, and how can I install MySQL 5.6?
Is there a way to use yum for this?...
- 1,479
2
votes
4
answers
5k
views
MySQL query cache is enabled but not being used
I've checked the query cache is enabled
mysql> SHOW VARIABLES LIKE 'have_query_cache';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| have_query_cache | ...
- 6,031
2
votes
3
answers
5k
views
MySQL Service Stop although Restart=Always
I've an Amazon t2.small EC2 - 1 Core and 2GB RAM it's more than the minimum requirements for CentOS and Virtualmin
My System:
CentOS 7.5.1804
Virtualmin
MySQL 5.5.60-MariaDB
Apache 2.4.6
The ...
- 171
2
votes
1
answer
4k
views
Installing MySql 5.5 on Debian with the deb package
I'm setting up a debian server as a development server. apt-get gave me everything I need to install, except for mysql 5.5 as this version is still in the experimental branch.
So what I tried to do ...
- 145
2
votes
1
answer
2k
views
Special characters in mysql password using mysqldump
I have the following ssh script:
#Here I am getting the mysql password for the root user
password=$(cat /root/.my.cnf | grep "password" | awk -F\" '{print $2}')
#here I am trying to dump the ...
- 43
2
votes
1
answer
2k
views
MySQL 5.5 replication setup on ubuntu 12.04
The following master-master configuration worked on MySQL Server 5.1.x(Ubuntu 10.04).
Master1(192.168.2.80)
##################################
#MySQL Replication
##################################
...
- 1,753
2
votes
2
answers
1k
views
MySQL binary logging
My server is telling my that binary logging is disabled. When I do a mysqladmin variables, I see this: log_bin | OFF. This is my configuration file:
[mysqld]
...
2
votes
0
answers
6k
views
Child process still did not exit
My LAMP server recently froze and I rebooted it. I ran into some memory issues with MySQL after that that I was able to determine indicated my swapfile got disabled during the reboot. I re-enabled my ...
- 213
2
votes
1
answer
136
views
Bugzilla migration from ubuntu 10.04 to 14.04 with Mysql 5.1 to Mysql 5.5
I am running Bugzilla 4.0 on Ubuntu 10.04.4 LTS running on physical server & thought of upgrading it to Ubuntu 14.04 on Hyper-V for testing.
After migration of bugzilla webroot 4.0 to Ubuntu 14....
- 1,142
2
votes
3
answers
3k
views
MySQL keeps crashing [closed]
So a little background, a few weeks ago I brought a new CentOS dedicated server in Melbourne, however it seems beside the number of attackers I get, there also seem to be an issue with the MySQL ...
- 185
2
votes
1
answer
894
views
MySQL 5.5 on CentOS 6 -- mysql user 'root@localhost' cannot grant privs
This is a new install and I have only set the root passwords for localhost, 127.0.0.1 and .
I know the password is correct as I can log in with root@localhost to the mysql server and can also create ...
- 78
1
vote
2
answers
2k
views
Cannot upgrade mySql on a Debian 6 server using apt-get
I run a Debian 6 server and use it to host a dozen of LAMP based websites.
I configured it to email me whenever a software update becomes available, and this morning I received the notification for 6 ...
1
vote
3
answers
5k
views
How to upgrade mysql5.0 to 5.5 on CentOS
I am trying to upgrade mysql from 5.0 to 5.5 on my local server. I have CentOS 5.8.
I have php5.3 installed. When I type
yum remove mysql mysql-*
The following comes out.
Removing:
mysql ...
- 333
1
vote
1
answer
3k
views
Why can't I uninstall mysql-5.5 & install mysql-5.6 on Amazon Linux machine?
I'm on a 64-bit Amazon Linux machine.
I had previously installed mysql-server 5.5. (using sudo yum install)
However, I soon found out that my application requires MySql-serve 5.6.
So I uninstalled ...
- 589
1
vote
3
answers
856
views
mysql master-master setup as a way to simply master-slave promotion
I'm trying to see if the following plan is viable. Goal here is to be able to do HA (uptime) and not necessarily for load -- writes are fine on one MySQL 5.5 server (with innodb) but not really ...
- 135
1
vote
3
answers
4k
views
Install MySQL 5.6 on CentOS 6.3 gone WRONG
I am trying to install MySQL 5.6 on CentOS 6.3 64bit using the .rpms provided by MySQL. I downloaded all the 64bit linux rpms into /usr/local/src/mysql and performed rpm -Uvh *.
The installation gave ...
- 1,479
1
vote
1
answer
1k
views
Cannot start MySQL 5.5 as normal user (fedora 15)
service mysqld start gives me:
Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details.
[FAILED]
...
- 154
1
vote
3
answers
5k
views
Percona MySQL 5.5 fails to start
trying to setup new server here but keep getting this in error log:
mysqld_safe Starting mysqld daemon with databases from /data/mysql/myisam
[Warning] Can't create test file /data/mysql/myisam/...
- 958
1
vote
2
answers
1k
views
Revisit - MySQL 5.1 vs 5.5
Many months ago, while MySql 5.5 was still in beta this question was asked before. Now that it has been released and there are a few maintenance updates out, what do all y'all think?
- 1,042
1
vote
3
answers
1k
views
How to speed up final stage of xtrabackup with lots of tables?
I have a MySQL 5.5 database with thousands of tables and heavy write workload.
I need to use xtrabackup to take online backup (create a slave from production server with minimum downtime), but the ...
- 121
1
vote
2
answers
4k
views
Accidentally delete ibdata1, ib_logfile1 and ib_logfile0
Actually i have problems with the database always down due to log. Usually when I restart it will work just fine. But recently the database cannot start and make me think to simply delete those ...
- 111
1
vote
1
answer
1k
views
MySQL server 5.5 , my.ini settings
There are a view things that don't match in my MySQL .ini file.
For example, everything that I have read/learned is to use
config_settings = value
however, in my configuration file there are:
...
- 1,089
1
vote
1
answer
3k
views
Can't create/write to file '/mnt/temp/something' (Errcode: 13)
I changed the tmp directory of the mysql configuration to a mounted disk and on service mysql restart I get following error:
Can't create/write to file '/mnt/temp/something' (Errcode: 13)
To my ...
- 238
1
vote
2
answers
651
views
What would cause mysqlcheck to incorrectly report a table as undamaged?
We are administering a MySQL server for one of our customers that has >100 databases with about 50 tables each, many of them InnoDB tables. The server crashed and I'm trying to find the culprit. When ...
- 213
1
vote
2
answers
3k
views
MySql Server does not start with innodb_force_recovery set to value 1-6
I have an ubuntu 14.04 KVM that was running as server LAMP till today when I have installed a Wordpress Plugin and the MySql Server 5.5 stopped working.
I have tried to start the server multiple ...
1
vote
1
answer
36
views
Examine MySQL INNODB folder
Consider the following situation.
I currently have an Ubuntu installation installed in my Virtual Machine. This installation has mysql installed in it.
Data for the mysql-server can be found under;
...
- 11