1
vote
2answers
108 views

MySql in Bash: Show only errors

Let me first start off by saying I am not an experienced linux user. I am trying to debug a mysql script in linux, however, my issue is that most of the queries are successful so I can not see the ...
1
vote
1answer
483 views

Connection to mysql server in SYN_SENT

We are facing a strange problem from last few days between our application server and database server(Mysql): connection to database server from application server hangs in SYN_SENT state and after ...
0
votes
3answers
471 views

Creating more space for MySQL with new mount

I'm using a cloud CentOS 5 instance and I realized that I left the default partitioning in the beginning. Everything on / is mounted already on hda that is about 10GB. The other drive (sda) is about ...
0
votes
2answers
2k views

“Access denied for user 'root'@'servername' (using password: NO)” - except I AM using a password

This is weird. Our web server is running RHEL 5.5, and has the MySQL client version 5.5.10 installed (just updated from a 5.0 build, which was having the same problem). When I connect to the database ...
0
votes
1answer
303 views

Guide to setting up a RHEL5 dedicated web-server for a LAMP website?

I'm setting up a dedicated webserver which will host just one website, ours, which runs on PHP/MYSQL. What all steps should I undertake to make sure everything is configured properly? Is there a ...
0
votes
5answers
771 views

MySQL Server Not Starting on Boot

I have installed MySQL on a RHEL 5 server and I want to set it up so that the server starts on boot. I've ran the chkconfig --list mysqld command and it's currently running on levels 3, 4 and 5. ...
0
votes
1answer
721 views

RHEL5 with Apache 2.2.3; MySQL 5.0.77; PHP5.1.6

Apologies if I'm asking an already asked question, but have searched and can't find any similar to this, so here goes. I have RHEL5 running Apache 2.2.3 (prefork) with MySQL and PHP. Up until a ...
1
vote
2answers
3k views

MySQL tmpdir on /dev/shm with SELinux

On RHEL5, I have a small MySQL database that has to write temp files. To speed up this process, I would like to move the temporary directory to /dev/shm by putting the following line into my.cnf: ...
1
vote
2answers
459 views

Is it a good idea to alter MySQL system priority from default?

I'm running MySQL 5.0.x on RHEL 5.3. I read in the MySQL Manual (here) that 'it is essential to run the mysqld process with the highest possible priority on the 2.4 kernel to achieve maximum ...
-1
votes
3answers
557 views

Which version of MySQL should I install on 32-bit RHEL 5?

$ uname -a Linux host.domain.com 2.6.18-128.1.1.el5 #1 SMP Mon Jan 26 13:59:00 EST 2009 i686 i686 i386 GNU/Linux I would like to install MySQL under /usr/local and not use the RPM installer. ...
2
votes
3answers
562 views

MySQL connection spike out of nowhere

We're running a website spread across three severs. Two of them are load-balanced web servers, and the last is a dedicated mysql server. The mysql server is running RHEL5 64-bit using a ...