The mysql5.5 tag has no wiki summary.
0
votes
1answer
26 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 ...
1
vote
1answer
37 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
56 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
28 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
32 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
78 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
41 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. ...
1
vote
0answers
50 views
centos update mysqlnd [closed]
I updated my mysql from version 5.0 to version 5.5, but my PDO drive is still mysqlnd 5.0.10. I would like to update the mysql driver to 5.5. How could i do that?
I already tried to recompile apache, ...
1
vote
1answer
96 views
MySQL service not available after server upgrade
I have recently migrated my website to a CentOS 6 VPS server. The server had somewhat older version of MySQL/PHP installed - so I upgraded everything (using CPanel) to below versions:
MySQL: ...
0
votes
1answer
83 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
131 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
64 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
62 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
95 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
32 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
79 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 ...
0
votes
0answers
144 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
46 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 ...
0
votes
1answer
133 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 ...
14
votes
1answer
920 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
88 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 ...
0
votes
0answers
433 views
MySQL Workbench is not finding MySQL service? [closed]
I set up a local MySQL server, currently with no databases. I'm trying to create a new server instance profile in MySQL Workbench to manage the server, and during the Create New Server Instance ...
0
votes
0answers
22 views
why the table shows as Myisam but not as well in apache error log?
I have web server with OS Red Hat Enterprise Linux Server release 6.2 (Santiago) and database server with OS Red Hat Enterprise Linux Server release 6.2 (Santiago) and mysql Ver 14.14 Distrib 5.5.23, ...
1
vote
1answer
140 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 ...
0
votes
0answers
73 views
Error connecting to DB [closed]
In regards to:
Remounting MySQL under a new mount point
Everything is running. MySQL started but for websites they can not connect to the mysql database at all.
Error log does not show much. Only:
...
0
votes
1answer
84 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
501 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
0answers
22 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
57 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
294 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
1k 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
86 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 ...
1
vote
1answer
880 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
3k 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
vote
2answers
1k 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
1answer
140 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 ...
1
vote
2answers
242 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
1k 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
377 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 ...
3
votes
3answers
2k 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
160 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
1k 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
1k 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.
...
0
votes
1answer
692 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
2k 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 ...
1
vote
0answers
58 views
How can I set the original PHP mysql api driver to auto-reconnect by default in MySQL version > 5.0.13?
MySQL server turned off auto-reconnect by default in version 5.0.13: http://dev.mysql.com/doc/refman/5.0/en/auto-reconnect.html
In MySQL 5.0, auto-reconnect was enabled by default until MySQL 5.0.3, ...
3
votes
1answer
485 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
404 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
3k 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
1answer
727 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 ...
