Questions tagged [mysql5.5]
MySQL RDBMS version 5.5
135
questions
-1
votes
1
answer
519
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
1
answer
44
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 need ...
0
votes
1
answer
137
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
1
answer
1k
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
1
answer
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
0
answers
239
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 ...
1
vote
1
answer
2k
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 ...
1
vote
1
answer
98
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
1
answer
343
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 ...
1
vote
1
answer
139
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
1
answer
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
##################################
...
0
votes
1
answer
284
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
2
answers
1k
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]
...
-2
votes
1
answer
3k
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
1
answer
3k
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 ...
1
vote
3
answers
5k
views
Percona MySQL 5.5 fails to start
trying to setup new server here but keep getting this in error log:
mysqld_safe Starting mysqld daemon with databases from /data/mysql/myisam
[Warning] Can't create test file /data/mysql/myisam/...
1
vote
1
answer
631
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 ...
0
votes
1
answer
6k
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.
...
4
votes
2
answers
10k
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 ...
6
votes
1
answer
5k
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
1
answer
894
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
1
answer
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 ...
0
votes
1
answer
1k
views
Mysql rpm package build for Scientific Linux
In my organization we need to deploy custom mysql packages for our Scientific Linux nodes.
We need the latest version of mysql and the install directory as
/opt/mysql
I am trying to build from the ...
0
votes
2
answers
149
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 ...
0
votes
1
answer
141
views
MySQL-server-5.5.18 - Installation issues / doubts
1 ) How to relocate the data dir while installing the MySQL-server-5.5.18-1.linux2.6.i386.rpm.
rpm -ivh MySQL-server-5.5.18-1.linux2.6.i386.rpm
3
votes
2
answers
1k
views
MySQL 5.5 InnoDB = OFF?
We run a server with MySQL 5.5. 95% of the tables are set to the InnoDB engine.
However whenever I look at the my.ini file (using the MySQL Workbench) under mysqld section innodb is unchecked and OFF ...
1
vote
1
answer
1k
views
MySQL server 5.5 , my.ini settings
There are a view things that don't match in my MySQL .ini file.
For example, everything that I have read/learned is to use
config_settings = value
however, in my configuration file there are:
...
0
votes
1
answer
145
views
Understanding MySQL Query Cache and when to implement it?
On our current MySQL server query cache is enabled.
Qchache_hits: 31913
Qchache_inserts: 50959
Qchache_lowmem_prunes: 9320
Qchache_not_chached: 209320
Qchache_queries_in_chace: 986
com_update: 0
...
0
votes
1
answer
111
views
How to retrieve all MySQL settings?
I have a configured MySQL server (MySQL 5.1.47-community) that works perfect. I installed a second server (MySQL 5.5.15-community) to see if the new version of MySQL would work with my application ...
2
votes
1
answer
1k
views
Changing MySQL datadir on active server
I have a server that seems to be setup wrong by previous administrator..
The server has two disks, disk 0 which is the operating system (RAID1 clone)
disk 1 which is 3 drives in a RAID5 setup with ...
1
vote
2
answers
1k
views
Revisit - MySQL 5.1 vs 5.5
Many months ago, while MySql 5.5 was still in beta this question was asked before. Now that it has been released and there are a few maintenance updates out, what do all y'all think?
1
vote
1
answer
1k
views
Cannot start MySQL 5.5 as normal user (fedora 15)
service mysqld start gives me:
Starting mysqld (via systemctl): Job failed. See system logs and 'systemctl status' for details.
[FAILED]
...
0
votes
2
answers
148
views
Where do I find a MySQL self-installer for OSX?
I don't have the resources or know-how to install MySQL from source, and the downloads page on Mysql.com only provides versions that require lots of manual linking.
Isn't there anywhere that ...
0
votes
1
answer
154
views
Can't run Apache - Would having Ruby on Rails and mysql server installed on the same machine be the reason why?
everyone. I am trying unsuccessfully to run Apache on my machine. I used the command line to find out all the applications that are using port 80 and I ended them, but Apache refuses to run on my ...
0
votes
1
answer
297
views
Is MySQL 5.5 worth it?
I am about to setup a couple of LAMP servers using Ubuntu 10.04. The problem is that I have noticed that Dovecot needs the MySQL-common package to work. I don't want to install that package since I am ...