The tag has no usage guidance.

learn more… | top users | synonyms

3
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 (/var/run/...
0
votes
3answers
2k 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
11k 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
151 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
288 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 ...
55
votes
17answers
67k 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
574 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
388 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 ...
3
votes
2answers
3k 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
1k 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
295 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
179 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
65 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
1k 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
641 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
691 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
882 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
383 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
1answer
119 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
589 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 ...
1
vote
0answers
203 views

New Windows Server 2008 R2 WIMP running slower than Windows Server 2003

We recently upgraded a WIMP server from Windows Server 2003 (32 bit) to Windows Server 2008 R2 (64 bit). The new server has significantly better hardware than the old server, yet many processes take ...
2
votes
2answers
2k 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
546 views

After creating a mysql user with all privileges, the user cannot create databases in phpMyAdmin and only sees information_schema table

This is a recurring problem for some reason... Using mysql 5.5, I am simply trying to create a user that can connect to the database remotely, have access to all databases, and create databases. I ...
0
votes
2answers
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 ...
1
vote
1answer
40 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 ...
1
vote
1answer
79 views

can not connect mysql with php script

I am new install centos6.2. in ssh part, I could access mysql with: >mysql -u root -p >se659;m then I could see mysql> and I could use any mysql command like: show databases;, show ...
0
votes
1answer
319 views

How to take mysql replication backup

I have a MySQL master-master replication setup with a slave for each master(only one master used for read/writes at a time) on Ubuntu server. Wondering what would be the best way to schedule backup of ...
3
votes
2answers
6k 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 ...
1
vote
1answer
117 views

Migrate to mysql replication server without interuption

I have a 3 apache2 / tomcat servers in a load balanced setup. Each tomcat server is connecting to a MySQL v5.0 database (all 3 share it). I created on the same network a MySQL v5.5 semisynchronus ...
2
votes
1answer
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
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 ...
2
votes
2answers
5k 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?...
0
votes
1answer
261 views

MySQL causes iowait's since 5.5 - optimal my.cnf wanted

I upgraded my MySQL server from 5.1 to 5.5 on CentOS (with 2 cores and 2GB RAM). With my old my.cnf the mysql service doesn't start anymore (complains about a PID file), so I use an almost empty my....
2
votes
2answers
736 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] ...
-3
votes
1answer
2k views

High Cpu Usage after MySQL Update (5.1 to 5.5) on CentOS 5.8 (64 Bit)

General Problem: Server load 20.92 (8 CPUs) [it varies from 7 to 40, normally it should be less than 1) Server Specs: Dedicated Server Intel Core i7 (8 Cpus) RAM: 8GB We use WHM and we have about ...
0
votes
1answer
1k views

How to bind mysql server to a certain IP?

In remote mysql 5.5 server I tried to add bind-address = 11.22.33.44 Where bind-address = 127.0.0.1 has commented out and 11.22.33.44 is the Ip of the web server communicating with the database ...
10
votes
3answers
15k views

Cant connect to mysql using self signed SSL certificate

After creating a self-signed SSL certificate, I have configured my remote mysqld to use them (and ssl is enabled) I ssh into my remote server, and try connecting to its own mysqld using ssl (mysql ...
1
vote
1answer
316 views

How does MySQL 5.5 and InnoDB on Linux use RAM?

Does MySQL 5.5 InnoDB keep indexes in memory and tables on disk? Does it ever do it's own in-memory caching of part or whole tables? Or does it completely rely on the OS page cache (I'm guessing that ...
1
vote
3answers
4k 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 ...
0
votes
1answer
3k views

What is the use of ibdata1 file in mysql [closed]

I have application which has the backend db as Mysql(InnoDb engine), and currently my client wants to decrease the size of the ibdata file to some fixed size. I found the three below solutions. ...
1
vote
1answer
3k 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 ...
4
votes
2answers
8k 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 ...
4
votes
1answer
2k 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 ...
2
votes
1answer
769 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 ...
2
votes
1answer
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 ...
1
vote
3answers
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 ...
0
votes
2answers
140 views

What production grade linux has MySQL 5.5? [closed]

I want production grade linux with LTS, long term support, that has MySQL 5.5. I.e. no third party repositories, no downloading binaries from mysql.org. Are there any available now or soon? The first ...