The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
2k 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 ...
1
vote
1answer
36 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
33 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 ?
27
votes
10answers
19k 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 ...
-10
votes
1answer
46 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
116 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
2answers
1k 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 ...
0
votes
1answer
106 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 ...
1
vote
2answers
502 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 ...
1
vote
1answer
25 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
1answer
34 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 ...
0
votes
1answer
61 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
0answers
32 views

mysql -q strange behavior

Using Mysql 5.5.37-0ubuntu0.14.04.1. Doing mysql mydb works fine, but using $ mysql -q mydb shows a strange behavior when doing mysql> describe sometable; then a very large number of --- are ...
2
votes
1answer
2k 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 ...
0
votes
1answer
266 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
0answers
141 views

SQL Error 1406 Data too long for column 'concatenado' mysql mac osx

I have a function column with name concatenado that is adding each titulo size 50 words each, until my subtitulo is null initially this has varchar(5000) and it is working good in Windows 8 without ...
0
votes
0answers
38 views

Mysql large memory consumption

I have a server running under openvz. System is Debian 6.0, MySql server 5.5.31 installed from dotdeb.org repo. I have very strange problem. Mysql server settings not allow Mysql to get more than 1.7 ...
0
votes
0answers
10 views

MySQL Server Not starting on Windows OS with Arabic

I have a MySQL server (The MySQL version is 5.5.25) that I packages with my software that I run on my Windows XP/7/8/Server, the MySQL server is starting up and running as required on the Windows OSes ...
0
votes
3answers
334 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
0answers
95 views

Upgrading MySQL 5.5.20 to 5.6 Identifying Weak Passwords?

I am trying to upgrade a WAMP server from MySQL 5.5.20 (32-bit) to 5.6.12 (64-bit) and when I went through the process of trying to upgrade the actual database the upgrade failed seemingly because of ...
0
votes
3answers
91 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 ...
0
votes
0answers
53 views

server pid removed after config cnf

i want config my server with this configuration : [mysql] # CLIENT # port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] # GENERAL # user ...
-2
votes
1answer
953 views

Plesk 11.5 installation Problems on Ubuntu 12.04 unable to access mysql server

Im not able to install Plesk 11.5 on my dedicated Server under Ubuntu 12.04 LTS because the their is no access to mysql. Installtion log says: Trying to establish test connection... ERROR 1045 ...
0
votes
0answers
26 views

Access Denied to Database Information_Schema

I have an SQL dump that is around 70GB in size with over a thousand databases inside of it. I am attempting to import it via command line, however I receive the error message... Access Denied for ...
1
vote
1answer
83 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
0answers
17 views

MySQL usage statistics by connecting user or by table

Is there a way to get some MySQL usage statistics, like aggregated number of SELECT/INSERT/UPDATE/DELETE queries, on a per connecting user or per database table?
1
vote
1answer
2k 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 ...
0
votes
3answers
139 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 ...
0
votes
1answer
103 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
vote
3answers
2k 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 ...
1
vote
1answer
352 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 ...
0
votes
1answer
834 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
3answers
92 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
53 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
45 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
596 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
364 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
621 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
333 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 ...
2
votes
2answers
493 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 ...
0
votes
0answers
152 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 ...
1
vote
3answers
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
votes
1answer
212 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
35 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
146 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 ...
1
vote
2answers
3k 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 ...
0
votes
0answers
475 views

Ubuntu 12.04 64bit - What would cause high System CPU %sys during high MySQL loads?

128GB RAM, 32cores Xeon RAID 10 SSD. Mysql version is the latest 5.5 for Ubuntu 12.04 . We have a lot of queries - about 1800+ per second. During high MySQL load - 2700+% load on a 32 CPU system - ...
0
votes
1answer
84 views

How to solve mysql server 5.5 update dependency issue?

since a month or two i cannot update package on my ubuntu server. The problem concern the mysql package which seems newer on the server that the minimum required ?? : lm@s8:~# sudo apt-get upgrade ...
1
vote
1answer
305 views

MySQL is too slow on Windows VPS

I'm running a wordpress blog on my VPS, But MySQL Queries are taking too much time. For example, it is taking more than 1.5 seconds to load a post from database. But CPU and RAM usage is low on my ...
15
votes
1answer
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 ...