0
votes
1answer
733 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
votes
1answer
204 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 ...
0
votes
0answers
450 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 - ...
1
vote
1answer
106 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
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
453 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] ...
1
vote
1answer
221 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
2answers
137 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 ...
1
vote
1answer
846 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] ...