The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
11 views

mysql 5.5 controlled by corosync/pacemaker on Centos 5.11

As an intermediary step before upgrading to a newer OS (in a few months) I have to upgrade the MySQL version from 5.0 to 5.5 on a CentOS 5 system. The installation itself, and the upgrade via MySQL 5....
0
votes
1answer
56 views

Why can I not re-create a dropped database?

I'm on a Debian host, and dropped a database from a Django project and then tried to re-create it. I've tried variations on a same basic theme from mysqladmin and mysql to create a database, and (...
0
votes
0answers
48 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 ...
0
votes
0answers
70 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 ...
0
votes
1answer
36 views

Configuring remote access to mysql via puppet

The problem: I want to connect to mysql from another host I have a mysql instance that I configure with puppet. I want to be able to access the instance from host 1.2.3.4. Part 1: I start by hand ...
0
votes
1answer
47 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
0answers
17 views

Mysql query log is empty after boot

I can't figure out why is general and slow query log empty after computer restart. After restarting the server with systemctl the logs get populated. After reboot the files are created just empty. $ ...
2
votes
1answer
67 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....
0
votes
0answers
38 views

WordPress site with no traffic; MySQL reporting 300-500 queries per second, frequently crashing

My server is running Debian 7.10 (Apache 2.2.22, MySQL 5.5.47, PHP5). It's a VPS. I've tried to summarise the issue in the title. I'm running a very small, private WordPress blog which is only ...
0
votes
0answers
31 views

mysqldump --databases option vs .my.cnf inconsistency

I had an issue which another serverfault issue solved, however, I'm trying to understand WHY. This issue is here: Mysqldump complains about chosen databases regardless of command line, and the ...
0
votes
1answer
276 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 ...
0
votes
0answers
155 views

Apache is using 100% CPU even with one user

Apache is using 100% CPU even with one user Apache (or should I say PHP through Apache?) is using 100% CPU for few seconds every time somebody search bugs at our bug tracker or just reload the search ...
1
vote
1answer
296 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 ...
0
votes
0answers
28 views

Mysql and HAproxy

Our java application hosting on jboss was connected directly to mysql server and it was working fine.As per new requirement HAProxy has been placed in front of MYSQL Server,It works but after few ...
0
votes
0answers
112 views

MySQL replication - invalidating query cache entries (table)

We lately mved to MySQL V5.5 on CentOS release 6.7 with master and 2 slaves. Since then the replication process lags a lot behind the master with the line in the process list of: invalidating query ...
0
votes
0answers
34 views

Debian Mysql 5.6 and MariaDB Instances on Same Server

I'm trying to have Mysql 5.6 and MariaDB to make comparison and track performance between each other. Everything i have found over the internet was this link: https://mariadb.com/kb/en/mariadb/...
0
votes
1answer
33 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 ...
0
votes
1answer
330 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 ...
1
vote
2answers
567 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 ...
3
votes
0answers
38 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....
-5
votes
2answers
53 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) ...
0
votes
1answer
134 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 ...
0
votes
0answers
26 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 ...
-1
votes
1answer
47 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 ...
0
votes
1answer
64 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
vote
1answer
19 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; ...
0
votes
1answer
100 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] ...
0
votes
1answer
212 views

different servers different databases replication mysql

I am not sure if this is possible or not but I have 3 servers. Server A, B and C Server A has database A_dataBase, B_database Server B has database A_dataBase, B_database and C_database Server C has ...
-1
votes
2answers
676 views

MySQL keep crashing

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 ...
1
vote
0answers
71 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....
1
vote
1answer
376 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 ...
3
votes
1answer
185 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 ...
-2
votes
1answer
71 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 ...
1
vote
2answers
244 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 ...
0
votes
2answers
375 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 ...
-1
votes
1answer
1k 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
vote
0answers
263 views

Mysql table doesnt exist error after trying run from lvm snapshot

I'm trying to set up mysql replication by making lvm snapshot of master datadir and copying it to slave. The procedure is quite simple, on master server I execute "FLUSH TABLES WITH READ LOCK" and on ...
1
vote
1answer
153 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 ...
1
vote
1answer
649 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 ...
3
votes
1answer
629 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 ...
0
votes
1answer
262 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 ...
-1
votes
1answer
79 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 ...
1
vote
1answer
148 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
1answer
45 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 ?
-8
votes
1answer
2k views

MySQL : How to lock all write in all databases? [closed]

I need to block all writes (insert , update, delete) on all databases. How can I do that ? Put all database in Read Only for a period time.
3
votes
1answer
733 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
vote
1answer
58 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
2
votes
3answers
1k 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 | ...
0
votes
1answer
650 views

mysql load_file() function always return null for symbolic link

i have installed new database server on ubuntu mysql version is 5.5.35 im trying to execute select load_file('/usr/home/aaa.com/medya_data/ver.txt') and im sure ver.txt file is exist but ...
0
votes
1answer
316 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 ...