We are using wordpress with MYSQL. Both the app and DB server are different with 6CPU and 6GB RAM and 32bit processor. We had noticed recently that mysqld process is taking too much of system usage- ranging upto 100% of CPU utilization while having the load of 1200-1600 concurrent users.
Pasting d my.cnf file-
# The following options will be passed to all MySQL clients
[client]
port= 3306
[code]....
I have been using ubuntu for 4 years now on my decent laptop with 2 Gb RAM, dual core centrino, etc etc. Yet, in all those years I have been using this superior OS, I still have to do hard shutdowns because some program runs wild. I have lately 2 scenarios where I have to interfere with the process:
1: amarok crashes and leaves the python script for the gnome shortcut keys running at 100% CPU. Or: thunderbird-bin keeps running after apparently clean close of Thunderbird. That's not really bothering me, I just kill both processes.
The bigger problem is scenario 2: 2: VLC starts eating all my RAM (for no reason), my SWAP starts filling and my computer becomes unusable for 10 minutes. Or: my matlab script is too big and eats up too much RAM -> same. Note: I have nothing against SWAP because at many other times it's very useful
These are stupid and annoying problems where there is an easy solution:
1) automatically kill the stupid process that runs at 100% CPU
2) automatically kill the stupid process that eats up all my RAM
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 **
Basically I have a machine with 16GB of RAM and have just discovered that using all of it can crash the whole system over one process. How could I run a process on the system in such a way that if more than 90% of system memory is used, the process immediately crashes?
View 3 Replies View RelatedI have just started to have a problem with Xorg it is always using at least 30% of my CPU, and the whole system does not run smooth so if I play a video it does not run smooth, it judders, also even if I drag an icon it judders across the screen. Im running Ubuntu 10.10 2.6.35-25-generic x86_64 VGA compatible controller: nVidia Corporation G98M [GeForce G105M] (rev a2)
View 5 Replies View RelatedAfter 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?
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)
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].....
I am running Apache 2.2.3 on a CentOS release 5.3 (Final) with 100 Sites. I've notice that Apache is making my server Swap around 200 MBs.
"http://www.xxx.yyy.zzz/server-status" doesn't show me too much to, so I am looking the behavior of specific httpd process.
ProcessID "18753" is the one for "http://www.xxx.yyy.zzz/server-status" in my browser.
This command show me (In KBs) how much virtual memory is that specific process using:
# /etc/init.d/httpd start
# grep Private_Dirty /proc/18753/smaps | awk '{ print $2 }' | xargs ruby -e 'puts ARGV.inject { |i, j| i.to_i + j.to_i }'
3012
... Running this command a lot of times it gives me the same output, but suddenly...
# grep Private_Dirty /proc/18753/smaps | awk '{ print $2 }' | xargs ruby -e 'puts ARGV.inject { |i, j| i.to_i + j.to_i }'
21708
Something make that process (and all the others httpd process too) to use a lot more memory!
Part of my httpd.conf:
# Timeout 120
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 3
<IfModule prefork.c>
StartServers 5
MinSpareServers 5
MaxSpareServers 20
ServerLimit 256
MaxClients 256
MaxRequestsPerChild 100
</IfModule>
<IfModule worker.c>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule> #
My server is running Mysql 5.1.34, vsftpd 2.0.5, BIND 9.3.4-P1 (as slave). I couldn't found anything running in the specific time that httpd processes start to use that much memory.
I am running 10.10 on a netbook (1.6Ghz Atom N270, 2GB RAM). Because it has limited resources, I am currently testing to see which apps I want to use.
Which should take more priority -- an application that uses less RAM or an application that uses less CPU?
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 **
I am kinda stuck while providing solution for the above problem. I have achieved the fail over using keepalived but not sure how can we replicate the data from one server to other seamlessly and have them in sync with each other. My prime requirement for this project is end user should not notice the fail over and replicated copy of data should be available on the secondary as well.
View 3 Replies View RelatedI just upgraded KDE on my openSuSE 11.2 installation. I have never had any problems doing this in the past, but this time, when I rebooted, I noticed that after a few seconds of idle time, my CPU usage goes sky high. I ran top in a console and noticed the culprit was xorg. I am using an NVIDIA card on an AMD64 3200+ with 1 gig of memory. KDE version is currently 4.5.85.
Like I said, I didn't have this problem until the last update. Any ideas as to what could be causing this?
I'm running desktop machine with with a core2 duo E6400 with 2GB RAM. I have completed a fresh install of Ubuntu 9.10 (fully updated). I have 10GB root, 2GB swap, 10GB home and 80GB data parititons.
I log in to main administrator account (first boot), create a new user (desktop) account and then use the switch user to log into the desktop account (so logged in to two accounts at the same time).
Whilst logged into the desktop account the CPU usage as seen in system monitor shows the two CPU's alternating at around 100% and the system slows down greatly.
Ubuntu 9.04 64-bit I just checked my system monitor and it looks like my memory is at a constant 900 MB's out of 4 gigs of ram. This seems high for only having firefox open.
View 5 Replies View RelatedI have recently upgraded from Kubuntu 9.10 to 10.04. I am having trouble with CPU usage by the X server. When running KDE programs (for example Kontact and Amarok) my computer is becoming very sluggish. This seems to be because X is using 90-100% of the CPU constantly when there are any changes to the application (any sort of redraw, even the mouse moving across the screen). I don't experience this with other applications (I am currently writing this from Chromium with no issues at all). Below is all the relevant information I can think to include.
INSTALL PROCESS: Fresh install from Ubuntu 10.04 LiveCD. My /home direrctory is on a separate partition so that has remained unchanged from 9.10. After installing Ubuntu, I installed the kubuntu-desktop package to install kdm and the KDE desktop.
The only real change from my last install is that /var is now also a separate partition (in a bid to save my MySQL data should I have to reinstall again) but it is on the same hard drive as my root partition and so shouldn't be causing any performance issues.
MY X SETUP: Three screen setup using onboard and PCI graphics cards. This worked perfectly before and, after reconfiguring X using nvidia-xconfig works almost as well again. Except that one of my monitors autodetects at 1280x1024 where before it was a higher (and widescreen) resolution.
The issue only presents itself when KDE application screens are visible and disappears when they are hidden (either minimised or closed) As far as Ican tell it could be an X, Qt or KDE issue. But I am not sure what versions of these will have been changed in the upgrade.
My problem seems to be very simple, it's high memory usage. I occasionally will use movie player to watch a few shows and I use firefox as well. My memory usage starts out real small about 500 mb but after using firefox lightly and movie player it jumps to almost 2 gigs and this is after they've been closed what gives? I've attached an image so you can see what I'm talking about.
View 7 Replies View RelatedI don't understand why I have a 800MB usage at startup. I didn't add any programs to start at startup. I do though have 10 primary partitions that are auto mounted at startup but it shouldn't use up so much, I have 2GB total RAM.
At startup nautilus uses ~400MB of virtual memory in the "system monitor"
Also which is RAM and which is SWAP in resources in system monitor: Virtual Memory && Memory?
-i figure vm is ram but thats not possible sometimes...it exceeds 2GB
I play RuneScape most of the time i'm on the computer and i always keep an eye on the performance. Yesterday and the days before, everything was going good, cpu usage it was causing was between 30 and 60%, now it wont go below 70%. It's always 70-99% for some reason :s i have set settings for graphics to OpenGL (they were like that before too with no problem) and it started causing high cpu usage. If i set it to Safe Mode in graphics settings it gets 100%, I never tweaked the drivers, i have a NVIDIA GeForce 9600 GT, i have the opengl thingies installed along with my nvidia driver. Ubuntu 10.10 32bit.
View 1 Replies View RelatedI am calling clock_gettime() function to get time with nano seconds accuracy. My program works fine on Ubuntu but have high CPU usage problem on CentOS 5. it takes 40% CPU on Ubuntu and 90% CPU on CentOS. Kindly give me solution so that I can reduce high CPU usage problem on CentOS. You can build this code like: "gcc -lrt gettime.c -o gettime.e"
[Code]....
I've installed my debian sid about one month ago (first xfce, next gnome) but noticed that it's kind of really slow. The upgrades take ages, launching (and using) firefox takes so much time,... In comparaison to my ubuntu, archlinux (on the same computer) or previous installation of debian there is clearly a problem somewhere.Today I tried to do a "top" sorted by mem usage : 3.5% xulrunner-stub, 2.1% dropbox, 1.4% aptitude (doing upgrade), 1.4% clementine,... nothing terriblebut still I've 2.7Gb or RAM used (more than 50%)
$ free -m
total used free shared buffers cached
Mem: 3967 26851282 0 79 1938
[code]....
Gnome-shell uses high percent of CPU (more than 90%) on Xorg. I have debian jessie on a Asus N53 ( Core i7 and Nvidia GT550 with nvidia optimus). I also installed bumblebee but nothing changed.
View 0 Replies View Relatedtop says there's only 12MB free (out of 1GB), but I can't figure out what's using all the RAM. rtorrent is using 13MB, and the rest are in bytes. (ran top as root)
[Code]...
as the title says my CPU goes on C0 state (100%) on every scroll and then returns down after a couple of seconds.
Is it normal?
I've checked this with powertop (and with my ears because I hear the fan noise...)
However, I would like to ask if anyone else is experiencing Higher than normal CPU usage with openSuSE 11.4 PR?? My system, which is probably similar to others, increases the air flow with the fan on the CPU when it is working hard. Mine gets rather noisy. (don't have it on the floor, but right next to me) This fan speed increase has been lots more prevalent in the newest version of openSuSE.
Have also used 'top' and it looks like xorg is one of the biggest hogs. However, when I use VMware it goes into hyper drive a lot.
yesterday when 10.04 got released i decided i'd install it and try it out, when i tried to run a java applet on it (runescape for example) the CPU usage got really high (around 100%), is that normal?
Info about my processor if you need:AMD Athlon(tm) 64 X2 Dual Core Processor 5000+ 2,61 GHz.This is my first time ever using ubuntu.
I've been using Ubuntu consistently for about three days now. I really, really love the interface and how everything works and all that, but I've been having a couple of weird problems with speed.
Graphics things seem to work really well. When I go into the overview of all my workspaces, it's instant and looks great. The problem is when I open and use some applications.
For example, when I open up the software center, it takes longer than it did the first time to start up. Also, when I drag windows off from being maximized, it takes literally about five seconds for it to show up as being dragged around by my mouse.
When I look at the system monitor, about 20% of my CPU cores are constantly being used. That's 20% each. I have a 3-core CPU, could that be the problem?
Another example: when I went to ..... just now, it would take a second for any volume changes in the video to register.
And I also have smooth scrolling in firefox, but it's very unresponsive now. It's slow as all hell. Even notifications are showing up more slowly.
So, what's the deal? What could I have done wrong?
CPU: AMD Phenom II X3 2.8Ghz
GPU: ATI Radeon HD 4860 1gb
RAM: 4gb
One more thing: I have really bad screen tearing when I try to move windows around, as if there isn't any vsync on. Where can I turn it on or fix this?
I'm still pretty new to Ubuntu and Linux, but I'm an advanced computer user. Since I feel linux is killing my CPU I think I'm going to boot back into Windows 7 for now, but if I can fix this problem I think I want to keep Ubuntu as my main OS after this, having Windows for games, unless I can get Wine to work right with them.
OSS, even though it's emulated *through* ALSA, consumes a microscopic fraction of straight ALSA's CPU usage. For example, when I'm playing something through ALSA with XMMS2, I'm getting about 25-30% CPU usage, but with OSS output, only 2%, tops. The same applies to any other application in which I can choose the output method. And, I'm on 10.04.
View 1 Replies View RelatedI use an Ubuntu 10.04 minimal install with only the packages I want, I like to keep things pretty slim.
On bootup, when I execute "startx", everything starts to load, this is fine. However, just off of a cold boot with only my startup apps running, conky shows around 450mb of RAM usage. It usually is only around 150 - 175.
Sometimes when I boot my computer Conky shows the normal RAM usage in the 150mb range, sometimes it's in the 450mb range.
My startup apps when I start X is openbox, tint2, wicd-gtk, feh (for wallpaper), and conky.
I open up htop when conky reports the weird RAM usage. htop also shows the weird RAM usage but I can't seem to find the memory hogging app.
Is this a kernel issue? I'm using the vanilla Ubuntu 10.04 kernel. Will recompiling from kernel.org fix this?
i am learning to using ubuntu as my server and learning using vps too
now i getting consfuse about my server memory usage i just have 3 sites , 1 blog site and 2 company profile but apache memory usage is more than 300MB and total of memory use in my server is more than 500 MB (maximum 512MB burst memory)
i am using drupal for my website is this normal ? because in last week, memory consumption in my server no more than 380 MB