0
votes
2answers
104 views

MariaDB Permission denied when using socket

Here is the gist of my problem: I have a web application that won't connect when the database has the host is set as localhost, however it will if I use the address 127.0.0.1. The error that PHP ...
0
votes
1answer
45 views

MySQL Dual-Primary Replication

I have 2 identical up to date dedicated MySQL servers and I just configured dual-primary replication on both, everything works as expected but the problem is that I have a lot of BIN files with very ...
0
votes
1answer
245 views

installing XtraBackup with libmysqlclient.so.18

Current situation I'd like to install XtraBackup on my VPS (Centos 5) where my main database is running. During the rpm install it told me that it misses a dependency called perl(DBD::mysql). When I ...
1
vote
2answers
638 views

Running mysql 5.5 on centos 5.9

I installed mysql using yum install mysql-server on centos 5.9 and realized it's version 5.0. I need version 5.5 so then I did yum install mysql55-server however I couldn't find a way to start server ...
-2
votes
1answer
49 views

Adding and Removing MySQL Databases via CentOS 6 - 64 bit

I have a VPS, and am having troubles with MySQL. I think I have created a database, but got lost. I need to know how to: Add a database, with the username, name of the database, and password. ...
-1
votes
3answers
1k views

Starting MySQL. ERROR! Manager of pid-file quit without updating file.

Im on CentOs v5.6 .When trying to start mysql im getting the following error Starting MySQL. ERROR! Manager of pid-file quit without updating file. In /var/log/mysqld.error.log i have the following ...
0
votes
1answer
406 views

CentOS 5: is %wa too high or optimal?

i have question about waiting for HDD. I'm not sure what is optimal %wa. Server running browser game, i know that there is a lot hdd writing but im not sure what is optimal %wa. Server running 8 ...
0
votes
1answer
3k views

How enable pdo_mysql

I am trying to install SpaceBukkit. I was wondering how I enable pdo_mysql. When trying to setup the MySQL part I get this error: The "pdo_mysql" extension is NOT loaded in your `php.ini`! Make sure ...
1
vote
1answer
216 views

Yum installing wrong MySQL version on CentOS 5 (Amazon)

I'm having trouble with a CentOS server running on AWS. This is CentOS 5.6 i386 from RightImage, but the problem was the same on all RightScale AMIs. When issuing the following command: yum install ...
0
votes
1answer
177 views

Mysql process taking all the memory

When I checked my process on VPS, I can see 18 instance of mysql running. What could be wrong? 1780 mysql 15 0 876M 142M 6744 S 0.0 8.1 0:00.51 /usr/libexec/mysqld --basedir=/usr ...
2
votes
1answer
676 views

How to install Percona XtraDB Cluster on x86 server?

I'm going to migrate from MySQL replication to Percona XtraDB Cluster. The problem I'm facing is one node is running on x86, and I cannot install Percona-XtraDB-Cluster-server from the Percona repo ...
-1
votes
2answers
191 views

Is this Mysql database server load too high?

I'm running a php website. I have two servers. Please help me to check is this Mysql Database Server load too high? I found the mysql CPU usage is always higher than 100%. Any suggestions to ...
2
votes
1answer
6k views

Trying to install phpmyadmin on centos - mysqli missing

Here is the error I get when trying to open my phpmyadmin directory: phpMyAdmin - Error The mysqli extension is missing. Please check your PHP configuration. I have done the steps in the following ...
4
votes
1answer
11k views

How to upgrade to latest PHP, MySQL, and phpmyadmin on CentOS 5.8 (32bit)?

I have searched around on the internet and cannot find a reliable source for installing the latest versions of PHP, MySQL, and phpmyadmin on CentOS 5.8 32bit with apache. I have tried a couple times, ...
2
votes
2answers
1k views

MySQL InnoDB ext3 block size

I'm looking for recommendations for ext3 filesystem block size for MySQL 5.6 using InnoDB. Running a CentOS 5.4 VM in VMware ESXi 5, VMFS 5 datastore on NetApp FibreChannel LUNs (which have 4k chunk ...
-1
votes
1answer
198 views

File conflig on package updates

I have a CentOS 5.X with Kloxo panel. It's a test enviroment but i have 2 pages there. I noticed theres 113 packets to be update (php, kloxo, wget, openssl, and a long etc) But when i do the ...
1
vote
1answer
264 views

mysql libs conflict with with mysql client

I am trying to get redmine up and running and its not been going well. Currently I am trying to install the required package mysql-devel and getting the error: Transaction Check Error: file ...
0
votes
2answers
496 views

How to optimization of MySQL server to be running many queries simultaneously

I was still new to the server, I have a hosting server, the specification DUAL CORE CPU, 4GB RAM, 500GB HDD. I use OS Centos 5 64bit, Kloxo Panel, Apache Web Server & MySQL sevrer. I have a ...
0
votes
1answer
699 views

installing RoundCube on CentOS 5.7 gives “ Cant Connect to the database ”

its been 3 days of struggling for installing roundcube and configuring it for me. i have a vps running centos 5.7 with kloxo 6.1.12 installed . first i tried upgrading the pre installed roundcube ...
1
vote
2answers
611 views

mysql2 gem not installing on CentOS 5.3

I'm trying to get the gem mysql2 installed on centOS5.3 but resulting in a conflict to mysql55. Sometimes (not always) I can install mysql55 and mysql55-server but after that I need to install ...
0
votes
3answers
658 views

Mysql full text search cause high usage CPU

We built a news site. Every day we will input tens of thousands data from web api. In order to provide a precision search service, our table use MyISAM, build fulltext index (title, content, date). ...
-2
votes
1answer
294 views

How to connect to MySQL database with HipHop PHP?

I installed hiphop php in CentOS 5.4 via yum with the repositories provided in the guide of the Git repository. Yum installed all the needed packages, including "mysql51". The problem is, i can't ...
0
votes
2answers
98 views

Unknown issue, brings MySQL down and requires a full reboot of the server

Don't know if anyone may have any brainwaves with this one. We have a website that is quiet heavily used (delivers 4+ million pages a month). Runs on a Dell Poweredge server, and has run fine for ...
4
votes
1answer
146 views

making sure daemons are safe

So I was wondering, what steps should we take to make sure PHP daemons are safe? One of the things that I read about was assigning the daemon to run as a user with limited priveleges? But how can we ...
1
vote
2answers
2k views

Can't start mysqld on centOS5 after attempting to upgrade to PHP 5.3

I tried to upgrade my system PHP from PHP 5.2 to 5.3 using starting with script http://www.atomicorp.com/installers/atomic.sh. I then used yum to update it. Everything seemed to work sweet but then I ...
0
votes
1answer
559 views

Installing Sphinx (2.0.1.beta) --with-mysql fails

I am trying to install sphinx on my centOS 5.6 x64 if I do yum install sphinx I get only 0.9,9 version, and I'd like to install 2.0.1-beta so I followed the instructions in their documentation and I ...
0
votes
2answers
397 views

CentOS/yum - Upgrading php 5.1 -> 5.3 without upgrading mysql 5.0 -> 5.1

I'm attempting to upgrade php from the centos default of 5.1.6 to 5.3.8 out of the Atomic repo, but when doing so, yum wants mysql to upgrade from 5.0 to 5.1, saying that php-mysql-5.3.8-1.el5 is ...
1
vote
2answers
10k views

How to clean up mysql installation on centos

mysql does not exist anymore but when i run yum remove mysql it says that the package is available but not marked for installation, i cannot install new mysql because of that, I need to completely ...
0
votes
1answer
501 views

CentOS Linux 5.4 -Your PHP installation appears to be missing the MySQL extension which is required by WordPress

I have just upgraded to PHP Version 5.3.3, on my CentOS Linux 5.4, when i tried to install wordpress it says Your PHP installation appears to be missing the MySQL extension which is required by ...
0
votes
1answer
138 views

Extremely slow MySQL performance after changing client server

I have a Magento web server (CentOS) that uses a crossover cable to connect to a MySQL database server. The other day, I upgraded the Magento server. I disconnected the crossover cable from the old ...
0
votes
2answers
380 views

Apache Delay in Requesting Web Pages During High Traffic

I have a server running CentOS 5, MySQL 5.1, and PHP 5.2. I have a problem that I'm not sure where to start in troubleshooting. It seems that during periods of high traffic, Apache will occasionally ...
0
votes
2answers
1k views

my.cnf values not applying - Optimizing mysql on centos Lamp

I have checked for other occurences of my.cnf and ive found only one occurence /etc/my.cnf. I then went ahead to fix in my values eg query_cache_size etc. after saving and literally rebooting, the ...
0
votes
2answers
2k views

How to install specific version of MySQL?

I installed from the repo, 5.0.77... including setup of PowerDNS (and the backend for MySQL). I tried setting up replication from my Master (which is MySQL 5.1.53) but it didn't work even though there ...
0
votes
2answers
620 views

can't connect to MySQL from localhost on Centos 5

I have a fresh install of Centos 5.5 on a new VPS and MySQL seems unable to resolve the keyword 'localhost' - if I use 127.0.0.1 instead it works fine. I checked the /etc/hosts file which is as ...
0
votes
2answers
1k views

Munin access to MySQL

According to several tutorials, the following should work: Create a new user in MySQL. $ mysql -uroot -p > CREATE USER 'munin'@'localhost'; > exit; Use that user in munin to access the ...
1
vote
1answer
2k views

Reducing MySQL RAM usage on CentOS

I have a vps with CentOS 5 (32bit) and it has 256mb of ram, although not much it is enough for me. On idle with 2 ssh connections active and httpd running it uses about 40mb of ram, but as soon as I ...
0
votes
2answers
764 views

Can't find my.cnf on my VPS

Hello, I am currently renting a VPS for the purpose of host a magento store. The VPS is running Centos5 with DirectAdmin. I have read a bit about how to optimize magento and one suggestion I have ...
0
votes
2answers
4k views

Installing MySQL on CentOS 5.5

I have to install the latest version of MySQL server community edition 5.1.51 (i think is the latest). I haven't installed any MySQL on this centos machine yet, but when I do a locate mysql - it shows ...
0
votes
2answers
546 views

Mysql Errcode: 17 Can't create/write to file '/tmp/…'

Can't create/write to file '/tmp/#sql_77a8_0.MYD' (Errcode: 17) I'm getting this for all softs of select queries. This problem is quite intermittent. Deleting the file fixes the problem but in an ...
1
vote
1answer
246 views

What is the easiest way to get XtraDB for MySQL running on CentOS 5

I'm having a lot of issues with a dedicated MySQL server and it seems like upgrading to the XtraDB version of InnoDB will probably have a positive effect, but I'm hesitant to get involved with it ...
1
vote
2answers
88 views

mysql installation fails

Whenever I try to install mysql 5.0.77 on CentOS 5.5, the installation goes fine. So the whenever I try: mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user ...
0
votes
5answers
336 views

Should we use Remote access for mysql

I'm not a system guy, this is first time I'm setting up a system. I have a remote system as developer point of view it would be good for me to have a remote access to the database. From security ...
1
vote
1answer
3k views

Failed depencies: libmysqlclient.so.16 is needed

I'm trying to install something on my server that requires mysqlclient, but looking at my RPM package list I have it ("MySQL-client-5.0.91-0.glibc23"). Doing a locate on libmysqlclient gives me this: ...
2
votes
2answers
4k views

Are MySQL databases always stored in /var on CentOS?

Are MySQL databases always stored in /var on CentOS? Specifically - If a new CentOS/cPanel server that needs to support MySQL, doesn't have that partition, but only has these, does that mean MySQL ...
0
votes
2answers
2k views

Timeout error occurred trying to start MySQL Daemon

Timeout error occurred trying to start MySQL Daemon. The above error comes when i run the following command "service mysqld start" this error comes on centos 5 after reboot the system please help ...
1
vote
1answer
169 views

What Could be Causing MySQLD to be very very slow to start but give no errors?

I have a brand new server running CentOS 5 with 16 cores and 20GB of RAM. In case it's important the machine is a Xen para-virutalised guest, but it's the only guest on the server and the server has ...