Questions tagged [mysql5.5]
MySQL RDBMS version 5.5
135
questions
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 ...
- 1,917
1
vote
1
answer
8k
views
Import MySQL 5.6 database into 5.5 using MySQL 5.6 client tools
My local dev environment currently uses MySQL Server 5.5. However, one of my clients hosts decided to upgrade their server to 5.6. I sync my clients databases remotely using mysqldump over ssh. I have ...
CommunityBot
- 1
0
votes
1
answer
251
views
Is MySQL using up all the memory? [duplicate]
I need help with reading this output of free -m. This server has a total of 32 GB of ram but it shows 9383 used and 290 free. The rest seems to be in the buff/cache. I am running mysql on this server ...
- 50.7k
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 ...
- 96
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/...
CommunityBot
- 1
0
votes
2
answers
2k
views
Create a super user in MySQL 5.5 not working: Permission denied for root@localhost
Using CentOS 6, logged in to MySQL as root, entering the command:
create user 'user123' identified by 'pass123';
works fine. But when I try and give that user super user privileges with:
grant all ...
CommunityBot
- 1
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....
- 181
-5
votes
2
answers
102
views
MySQL crashes running but not working [closed]
Mysql is running but it not responding when using phpmyadmin when i check mysqld.log it tells:
[root@dc /]# tail /var/log/mysqld.log
151111 8:58:21 [Note] /usr/libexec/mysqld (mysqld 5.5.46) ...
CommunityBot
- 1
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?...
CommunityBot
- 1
0
votes
1
answer
419
views
MySQL creates huge files every night, bringing down the server
I have an Ubuntu 12.04 LEMP server with shop app ontop, running MySQL 5.5 as DB (currently since this problem started I've already switched to Percona with no success).
So, current facts: every night ...
- 389
1
vote
3
answers
2k
views
Replication issue with mysql 5.5.8 while restoring the dump on master server.
While restoring the Mysql dump file it throws the following error.
ERROR 1665 (HY000): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one ...
CommunityBot
- 1
0
votes
0
answers
34
views
mysql keeps lossing user permisions
We have a mysql database on ubuntu 14.04 server. It was working really fine for months until some weeks ago, when it started with this thing. It suddenly losses all user permisions and we have to set ...
- 22.5k
-2
votes
1
answer
280
views
Ubuntu Mysql stop working after outofmemory in a clamscan, mysqld.sock
I'm having daily problems with postman with autentification througth mysql on my Ubuntu14LTS Server.
I think the problem arrise after a clamscan scron that breaks in an Out of Memory. In some way ...
CommunityBot
- 1
0
votes
1
answer
134
views
Why is the MYSQL variable innodb_file_per_table changed to OFF automatically in a OPENSHIFT online gear?
My application is on openshift online gear with mySQL 5.5. Recently I found that my mySQL database become very big quickly (few days increase 1G) without many operations. This made me try to do ...
- 1
1
vote
2
answers
1k
views
MySQL 5.6 replicate live master WITHOUT down time
Following the steps to replicate an existing server, it seems most methods rely on the ability to either completely stop the master server or at least prevent it from writing using flush tables with ...
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;
...
- 110k
0
votes
1
answer
213
views
Warning while upgrading MySql 5.5 to 5.6
I'm trying to upgrade MySql from 5.5 to 5.6 in my Ubuntu machine. While running command
sudo apt-get install mysql-server-5.6
we encountered with warning like :
2015-07-01 18:47:58 0 [Warning] ...
- 8,759
1
vote
0
answers
223
views
Possible have 2 php.ini file or 2 extension_dir in php.ini?
i got Fatal error: Class 'mysqli' not found in C:\apache2triad\htdocs\index.php on line 8 error. I checked php.ini file and saw extension=php_mysql.dll is uncommented.Everything is normal. But in php....
- 11
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 ...
- 36
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 ...
- 248k
-2
votes
1
answer
92
views
Moving data between drives CentOS 6 + cPanel [closed]
Recently, my server crashed. The hosting company has installed new CentOS on a replacement drive and attached the old drive to my server. I have installed and setup cPanel onto the new server and ...
CommunityBot
- 1
0
votes
2
answers
1k
views
Replication server crash - > 18:39:32 UTC - mysqld got signal 11
Below you can see the part of the log showing the crash. The replication server is 5.6 and the master 5.5 but this setup has worked with warnings for the last week or so.
Now, after trying to change ...
- 61
0
votes
1
answer
3k
views
mysqltuner: Thread cache is disabled
Mysqltuner says " Thread cache is disabled" but according to my.cnf, it is not.
Why is that?
Here is the my.cnf content.
[mysqld]
log=/var/log/mysql.log
datadir=/var/lib/mysql
socket=/var/lib/...
- 1,393
1
vote
1
answer
294
views
Apache2 / tomcat / MySQL / PageSpeed Server hanging once a day
My server started to hang at least once a day. It remains so until I restart Tomcat. I'm not sure yet which part causes the problem, so I'm trying to work on several hypotheses:
My website is served ...
- 854
0
votes
1
answer
617
views
Can I do zero downtime MySQL replication if I have archive tables present?
I've read the question and answers at How to setup MySQL replication with minimal downtime. It looks like I can get a slave DB into sync without down time if I am using only Innodb tables.
My ...
CommunityBot
- 1
0
votes
2
answers
673
views
Queries going to mysql server even when no one is connected to it
I have a MySql server which has 2 active databases which are used for a web application and 3 inactive ones (left for archival purpose but not currently used). The problem is that the server seems to ...
- 1,338
-1
votes
1
answer
103
views
MySQL upgrade issues - script to analyze general query log
When moving from MySQL 5.0.x to a newer version (such as 5.1.x or 5.5.x) what's the best way to proactively find backwards compatibility issues? There is lots of documentation out there such as ...
- 738
1
vote
1
answer
237
views
WinServer 2008 R2 MySQL cluster service won't start
So I have a two-node failover cluster in WinServer 2008 R2, I also created a generic service which will manage my MySQL5.5 database (the database root is also in a iSCSI storage).
When the cluster ...
-5
votes
1
answer
57
views
MySQL : How dump is works? [closed]
I have a 10GB database and the dump takes just a few minutes.
I want to know how the system of dump works ?
Someone can tell me ?
- 7,034
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
0
votes
1
answer
808
views
UTF-8 encoding gone missing after enabling mysqlnd
I've enabled mysqlnd on my PHP 5.4.26 server using MariaDB 10.0.8.
My SQL config contained this:
[mysqlnd]
character-set-server = utf8
collation-server = utf8_general_ci
It was all working fine ...
- 568
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 ...
- 131
1
vote
1
answer
164
views
Linux iptables DNAT 53306 to 127.0.0.1 3306
mysql real port is 3306。
I want public network using 53306 to visit mysql,and 3306 not allowed access from public network.
How to write the iptables rules DNAT 53306 to 127.0.0.1 3306 ? help me
- 96
1
vote
1
answer
50
views
Purpose of "computer" section in MySQL Cluster 7.2?
According to the cluster documentation, you can either define data nodes with:
[ndbd]
NodeId=n
HostName=1.2.3.4
or
[ndbd]
NodeId=n
ExecuteOnComputer=m
[computer]
Id=m
HostName=1.2.3.4
I don't see ...
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 ...
- 6,442
0
votes
3
answers
661
views
Can't upgrade MySQL Server on new Ubuntu 12.04 install
After freshly installing Ubuntu server 12.04, I did the usual apt-get update / apt-get upgrade, which failed for mysql-server-5.5:
Setting up mysql-server-5.5 (5.5.31-0ubuntu0.12.04.2) ...
start: Job ...
CommunityBot
- 1
0
votes
3
answers
6k
views
Limit MySQL forked processes
How can you limit the amount of processes that MySQL forks? I noticed at startup there are at least 10 children. This is a development database that isn't in production; so no users are connecting to ...
CommunityBot
- 1
1
vote
1
answer
843
views
mysql slow queries not writing to log
I have the following slow query information setup in mysql.
SHOW VARIABLES LIKE '%SLOW%';
Variable_name Value
log_slow_queries ON
slow_launch_time 2
slow_query_log ON
slow_query_log_file ...
- 214
1
vote
1
answer
7k
views
Getting Error "Unknown MySQL server host" during importing the sql file?
In mysql server, when importing the sql file into the db. I am getting as error as below. So, can you help where the issues lies that is in mysql server config or the sql file
ERROR 2005 (HY000) at ...
CommunityBot
- 1
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 ...
- 22.4k
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 ...
- 3,935
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 ...
- 80.4k
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.
- 16.7k
0
votes
1
answer
500
views
How to secure mysql server
I have an mysql client with a fixed IP that should be able to access a mysql server.
The mysql client is integrated in a software and only port, ip, username and password are modifiable.
What would ...
- 115
0
votes
1
answer
158
views
Stable version of Mysql [closed]
I am plan to do some real application, here i finalized to use mysql as a backend. And my question is Currently which MySQL version is stable. Also want the major pitfalls for MySQL 5.5 if MySQL 5.6 ...
- 110k
0
votes
1
answer
749
views
Apt-get error when upgrading mysql from running out of room
I ran out of room on my drive on an ec2 instance and it mounted the overflow /tmp space. I noticed this when I did an apt-get update/upgrade and the upgrade failed because it had no more room on tmp. ...
- 5,914
0
votes
1
answer
2k
views
Getting mysqld_multi to work with upstart
I used this guide to get started and this wiki page as a reference for the upstart script.
My problem is that when I do a service mysql start I get six processes instead of two, as if upstart ran ...
- 126
0
votes
1
answer
1k
views
mysql database config optimization
Have a heavily trafficed database running mostly innodb and would like to better optimize the mysql config. Server has 32Gb ram and the biggest tables are ~18Gb innodb. I think I have done all the ...
- 46
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 ...
CommunityBot
- 1
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 ...
