Ubuntu Servers :: Mysqld Goes 100% Cpu Load And Freeze
Aug 15, 2010
as soon as mysqld starts it goes 100% cpu. I can stop it, there is no mysql_safe running, and I ran mysqlcheck -A -a -c -o -g --auto-repair -u root -p all is ok, syslog shows nothing important but I can't login to any account with mysql client it just sits there, using php it times out. I don't know how to fix the urgent situation...
Looks like it has been started after a release update to 9.10 or 10.4 (i did it in a row) I don't know if this bug is related [URL]
View 2 Replies
ADVERTISEMENT
Apr 18, 2011
installing mysql server manually. i have successfully installed mysql server but when i am try to create database, it shows error like this
ERROR 2002 (HY000): Can't connect to local MySql server through socket '/var/run/mysqld/mysqld.sock' (2)
** mysqld is not available in /var/run and error log file is also not available in /var/log **
View 5 Replies
View Related
Apr 10, 2010
After the upgrade from 8.10 to 9.04, all was well. But after the upgrade from 9.04 to 9.10, I lost the MySQL server. Now, I recall during the upgrade, I was asked if I wanted to keep the existing my.cnf file or replace it with a newer one. I did as suggested and kept the original as I had edited it before. The same question was asked with a couple other config files. I kept the original in each case. After the first step, I checked the server was running and the websites were up, all was well. After the update to 9.10, when I checked the server, I get the following error:
Code: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Can anyone point me in the right direction to getting this resolved?
View 2 Replies
View Related
Feb 27, 2011
I'm the lead Dev of GnackTrack and we're having issues with running MySQL on the LiveDVD.Once installed everything works fine, mysql can be connected to but when using the liveDVD we get the following error:
Code:
root@root:~# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Contents of /etc/mysql/my.cf point to /var/run/mysqld/mysqld.sock but because this is a liveDVD the actual file is located in:
/rofs/var/run/mysqld/mysqld.sock
[code].....
View 4 Replies
View Related
Aug 23, 2010
I am completely stumped. Found my web server (lighttpd) unresponsive this morning and had to hard cycle it. After some cleaning up, all was happy. However, after about an hour of handling a decent amount of web traffic, time freezes as far as the web server is concerned. I've got an hour of access.log data with the following date: [23/Aug/2010:20:42:58 -0500]
It never changes. The load average now reads 0.00 0.00 0.00 (which is totally inaccurate). And I am not able to successfully log in remotely. I have taken the server down 3 or 4 times today and after an hour or so of functioning normally, this is what happens. Additionally, the local time is now off by 30 minutes.Trying to force with ntpdate does nothing (or, at the very least, sets it to the same incorrect time)
View 4 Replies
View Related
Sep 8, 2010
I have 4 servers:
- One is loadbalancer, installed keepalived and ipvsadm - LV1
- One is failover for loadbalancer, installed keepalived and ipvsadm too - LV2
- The other servers was installed httpd and mysqld. (RealServer)
LV1 load balancing for both httpd and mysql. And it's working fine.
VIP for http: 192.168.1.110
VIP for mysql: 192.168.1.111
Now I want to setup a website on RealServers , with URL is [url], and this website connect to mysql via VIP 192.168.1.111, this means real servers will connect to their mysql via load balancer (LV!). I tried to connect mysql via VIP from real server but it cannot.
View 7 Replies
View Related
Feb 24, 2011
I need some help.Trying to set up bugzilla on my VM.After setting up the IP to use static i could log on to the url its not even loading up from command line its issueing an error.when i try to log on to mysql
bugzilla:~# mysql -u root mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
View 1 Replies
View Related
Feb 4, 2010
I'm running Ubuntu 8.04.4 LTS to host a moodle server in a school.. moodle is running OK - but I'm having problems with MySql Any mysql command generates:
unknown variable 'pid-file=/var/run/mysqld/mysqld.pid'
I've taken a look in unknown variable 'pid-file=/var/run/mysqld/ and there is no mysqld.pid file I have followed these instructions that I found elsewhere:
If there�s no mysqld.pid inside /var/run/mysqld directory, create mysqld.pid
# cd /var/run/mysqld
# touch mysqld.pid
[code]....
But after reboot the mysqld.pid file is missing again.. I can access mysql via phpmyadmin - but webmin fails with unknown variable 'pid-file=/var/run/mysqld/mysqld.pid'
View 8 Replies
View Related
Apr 26, 2010
Since /etc/rc2.d/S19mysql does not exists anymore, and then init.d/mysql uses /sbin/start, I am unable to use mysql server anymore: me@mycomputer~#start mysql [ret] ...... for hours this command never returns so that ^C aborts...
me@mycomputer~#ps axw |grep mysql ( no results, no mysql!!! ) me@mycomputer~#stop mysql [ret] no returns either!!! This upstart [start|stop] thing seems a total failure for mysql!!!
View 9 Replies
View Related
Feb 1, 2009
I've created a mysql user and he can connect Joomla to mysqld when everyone has full permissions to the mysql homedir but I know this is bad from a security standpoint. If I set mysql user as the only one with permissions then I can't connect. I know Joomla support is not very help from past experience, wish I could dump it for something else but it does work great once it is configured so I need to keep it around, can anyone make a guess as to what permissions I need to have set on mysql's home dir so that joomla can still connect yet I am more secure than now?
View 11 Replies
View Related
Apr 18, 2011
i have successfully installed mysql server but when i am try to create database, it shows error like this
ERROR 2002 (HY000): Can't connect to local MySql server through socket '/var/run/mysqld/mysqld.sock' (2)
** mysqld is not available in /var/run and error log file is also not available in /var/log **
View 4 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
May 5, 2011
i'm not the most knowlegable person but i have successfully installed mysql in the past. but now that i am attempting to install it again i'm getting this error during installation. has anyone seen this before?
mysql error: *Starting MySQL database server mysqld [fail] invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.0 (--configure): subprocess post-installation script returned error exit status 1
View 6 Replies
View Related
Feb 16, 2009
just built a computer and wanted to try out some linux.
First off I burned the Fedora 10 x86_64 disk image (using disk utility on my mac at 4x speed then verified it) to a dvd. I start the install. "x startup fails to load, falling back to text mode" comes up. I use the text install then. It gets to the actual installation of the different packages then a black screen shows up with white text that's highlighted red (sometimes it's blue). It then freezes and I reboot. Sometimes it freezes at different points and with different messages, but the description above is what happens most often.
I try writing it at 1x speed and verifying. same thing.I try the Live CD. It freezes.Then I tried Fedora 9. same thing.
Next I go to Ubuntu 8.10.I try the regular install, but the orange loading bar freezes.I try the Live CD-like install. It runs!...but when i go to install, when it gets to the partitioning part, it freezes and becomes unresponsive.
Each time it froze I let it sit for about 10 minutes, just to make sure it is in fact frozen. I've tried these installs numerous times.
View 9 Replies
View Related
Jun 9, 2009
I got Fedora 10 and I installed a proftpd server it works in local network but not from outside. Actually I can see it checks for user and pass but when it has to list the user dir it freeze. The server is behind a router. I am using passive ports 60000-60100 and I forwarded all connections to and from 21 to 60000-60100 onto internal (192.168.0.109) IP address.
[Code]...
View 10 Replies
View Related
Jun 4, 2010
I have a Ubuntu 10.04 fresh installation on my HP laptop. Installation successful and boot OK. But the desktop randomly freeze. During freeze(about 15s each time), all programs are not responsive. Sometimes I can switch program by click, but program seems locked. How can I know which module cause the freeze?
View 4 Replies
View Related
Jul 7, 2010
I have a virtual machine (VirtualBox) with Ubuntu 9.10 installed, I'm trying to install MySql community editor using the linux-generic package (the tar package), I followed all the procedure but I had a problem with the next line of code:
shell> scripts/mysql_install_db --user=mysql
I don't understand a lot about the command line, but I think this line of code is used to create the basic tables of the database (users and so on). the problem I got with this line of code is:
FATAL ERROR: Could not find mysqld
I googled it and after a while I found this blog:
azimbabu.blogspot.com/2009/07/mysql-5136-in-ubuntu-904-fatal-error.html
The blog says that the problem is a default instalation of SQL, and the solution is replace the file my.cnf in the location /etc/mysql for other file that comes with the package.
I didn't replace the file my.cnf, I only changed the name and it woked perfectly, and this is the problem, I don't understand why it worked.
Any one knows why this file is so important?What could happen if I delete this file?what is the purpose of the package mysql-common un Ubuntu?
View 3 Replies
View Related
Mar 13, 2010
I have installed x-11 server using the command
"sudo apt-get install xserver-xorg xserver-xorg-core"
and
"sudo apt-get install openbox"
On the Ubuntu server 9.10 I dont know how to load the GUI environment .
View 1 Replies
View Related
Apr 9, 2010
I have my own personal web server with xubuntu on it, but after I upgraded to 9.10 my wordpress blog stopped working.
View 9 Replies
View Related
Apr 17, 2011
Trying to track down reasons why mod_rewrite won't load, I found this site; hopefully, this will reduce the idiocy of this question.
Based on it and other sources:
Code:
graton# locate mod_rewrite.so
/root/share/openh323/lib/apache2/modules/mod_rewrite.so
/root/share/pwlib/lib/apache2/modules/mod_rewrite.so
[code]...
View 2 Replies
View Related
Oct 17, 2010
On my squeeze installation, when I shutdown my computer, there is an error message saying that "...cannot shutdown mysqld". I ignored it and there does not seem to have any ill effect.
edit: here is the exact message: "Stopping msql-server: mysqld failed"
View 2 Replies
View Related
Apr 22, 2010
I have an Ubuntu Server 8.04 that is operating fairly high CPU loads - Samba appears the culprit. I have 5 main shares with 17 users. Other packages include Apache (2 Wordpress sites for intranet only), YaCy (minimal indexing 10 pages/minute), and a MySQL business database with no more than 10 concurrent users. This only started in the last 2 weeks - updates are not the culprit.
View 1 Replies
View Related
May 4, 2010
I'm attempting to use mod_security with apache2 but it doesnt seem to load. Running Ubuntu 9.10.
Code:
$ ls -a mods-enabled/
. authz_host.load dir.load php5.load
.. authz_user.load env.load setenvif.conf
alias.conf autoindex.conf mime.conf setenvif.load
[code]....
View 1 Replies
View Related
Aug 3, 2010
I have a 10.04 32-bit virtual ubuntu server. I am trying to figure out how to setup load balancing. Here is how I planned out to do it, I need direction for what software I should use.
--Internet(1.2.3.4)
--Router
---Load Balancing Server (192.168.1.30), port 80, public as in port forwarded Load balancer sends traffic to either web server
---Web Server 1 (192.168.1.100)
---Web Server 2 (192.168.1.101)
I heard I should use rsync to keep the files concurrent, at this point rsync is the least of my worries. I need to know what load balancer I should use I have tried and failed with crossroads(xr), and balance. I can't seem to find a modern tutorial for either system. I looked at linux virtual server but that is like 5 years ahead of my current knowledge.
View 3 Replies
View Related
Oct 6, 2010
I have two machines fairly decent which I wish to cluster and run a vm (preferred choice virtualbox) on it, if possible with load balance.
View 1 Replies
View Related
Dec 22, 2010
how the heck to make this machine load my unreal server on bootup? /home/user/Unreal3.2/./unreal start
View 4 Replies
View Related
Apr 8, 2011
my servers are configured with:Ubuntu 10.10 server 64bit;Lighttpd MySQL-Server I need to make graphs for traffic (bandwidth usage) and cpu load every month. I tried to configure mrtg but after 48h, it didn't produce graphs.(I can't install apache2)
[Code]...
View 6 Replies
View Related
Sep 21, 2010
I need to test an application on a Ubuntu Server that works as a database server for the network.
On this server's /etc/mysql/my.cnf, I have:
Code:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = <server-ip-address>
This means that I can't access the mysql server from 127.0.0.1, right?
I tried adding the following entry to /etc/hosts.allow :
Code:
mysqld : 127.0.0.1 : allow
I feel like I need to restart the service that reads /etc/hosts.allow, is this approach correct?
Or on /etc/mysql/my.cnf I can have two (or more) bind-addresses entries?
View 5 Replies
View Related
Apr 19, 2010
I have several web servers running Ubuntu 8.04 64-bit server and occasionally Apache sends my load to 13 and higher.
Is there a log that actually tracks the system load levels and possibly the processes running at the time and their percentage of the load?
At the basic level what I am looking for would be a log of top but not exactly that.
View 1 Replies
View Related
May 10, 2010
I upgraded webserver to new ubuntu server 10.04 (x86-64). After upgrade the increased load from 0,3 to 1,4. On webserver running phpbb, which generating slow quieres, which not before upgrade to lucid. HW conf: Intel Core i7, 8GB ram, WD Raptor 10k rpm. Week17 upgrade to new version.
View 9 Replies
View Related
