The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
15 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
18 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
0answers
6 views

import of mysql binary log stopped can I restart the import

I'm doing a two hourly import of binary logs, but nog during an import I had a crash. Can I restart this import without having duplicate data ? Thanks
0
votes
1answer
44 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
27 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 ...
0
votes
3answers
170 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
39 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 ...
1
vote
1answer
180 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 ...
1
vote
0answers
88 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
44 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
131 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
274 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
537 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 ...
1
vote
0answers
138 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
110 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
334 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
374 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
191 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
72 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 ...
0
votes
0answers
134 views

(OpenShift) Permission denied when installing my own cartridge from my github repository

I froked MySQL cartridge from official github repo and I added some modifications to support utf8mb4 encoding. this is my cartiridge on github : ...
1
vote
1answer
122 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
42 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 ?
-9
votes
1answer
635 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
478 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
48 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
1
vote
2answers
456 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
471 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
218 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 ...
2
votes
1answer
7k 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 ...
0
votes
3answers
1k 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 ...
4
votes
1answer
7k 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 ...
1
vote
1answer
132 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 ...
0
votes
2answers
202 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 ...
42
votes
12answers
43k 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 ...
0
votes
3answers
534 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 ...
0
votes
3answers
281 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 ...
1
vote
2answers
2k 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 ...
2
votes
1answer
715 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 ...
2
votes
3answers
144 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.
0
votes
1answer
118 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 ...
0
votes
1answer
56 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 ...
0
votes
2answers
863 views

Mysql 5.5 is not installed in CentOS 5.7

I am using CentOS 5.7 with 64 bit. In my machine already have MySQL 5.0.88 version. Now I want to upgrade MySQL to 5.5 version. I followed this link to start my installation process. When i give "yum ...
0
votes
1answer
567 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. ...
0
votes
1answer
1k 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 ...
0
votes
1answer
506 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 ...
0
votes
0answers
185 views

fail to upgrade from mysql5.1 to mysql5.5 (Ubuntu 11.04)

I follow instruction in that blog upgrade from mysql5.1 to mysql5.5: http://ronaldbradford.com/blog/upgrading-to-mysql-5-5-on-ubuntu-10-04-lts-2013-01-22/ Step 1. Remove existing MySQL 5.1 retaining ...
2
votes
2answers
723 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 ...
-1
votes
1answer
312 views

MySQL Configuration on my.cnf [closed]

[mysqld] core-file default-storage-engine=MyISAM max_connections = 5000 max_user_connections = 5000 key_buffer = 1024MB myisam_sort_buffer_size = 512M join_buffer_size = 256M read_buffer_size = 256M ...
-1
votes
1answer
36 views

MySQL statement [closed]

How to create a MySQL statement to check expiry and and deactivate a/c on matched date? desc mailbox; username varchar pass varchar created datetime expiry datetime active tinyint(1) I ...
0
votes
0answers
190 views

Import large InnoDB table dump

i've a mysqldump ( 1.5G large ) of a table I need to import. The server i bought, which is clean and not under load, takes > 2hours to import it. I read many tweaks i can use to speed up the import ...