my mysql is hogging my server resources andd sometimes crash it.Is there a way to increase memory it uses?I get this message alot..
Time: Mon Dec 6 08:21:33 2010 -0600
Account: mysql
Resource: Virtual Memory Size
[code]....
I installed ubuntu 10.10 a few days ago which ran very well on the live CD but after I upgraded to 11.04 Ubuntu uses just under 100% of my cpu after a few mins loged in and my ram usage increases by about 5MB per sec starting the second I log in. I am using Classic Gnome and it seems to do this wether I have metacity or compiz turned on. Does anyone know what is going on or know about a way to lower ether my cpu or ram usage
View 3 Replies View RelatedDuring random moments, pidgin will suddenly use up all of my processor, a large chunk of my ram (20% - 25% of 2 GB), and will become completely unresponsive. This lasts for maybe four or five minutes then returns to normal.Pidgin doesn't have any kind of terminal output when ran in a terminal, so I have no data to use that is of any help.
View 5 Replies View RelatedI'm running a linux cloud server with the following config
1.2ghz Processor allocation
752MB Ram
The site loads slow and clicking a link almost freezes the page for a second. Also, the page loads could be much faster. We've been running mysqltuner and have pretty much optimized all slow queries. Is there anything we can do to fine tune the server for faster and more responsive?
Httpd.conf
Timeout 20
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
<IfModule prefork.c>
code....
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
I am not an expert and have only been managing my server not too long. My server is running kind of slow so someone suggested running the 'top' command via shell, and I found a few things using major resources, but I don't know what they are or how to fix them. can someone suggest some things.
View 6 Replies View RelatedI am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 4 Replies View RelatedLast week my server crashed. I'm trying to diagnose the cause.
This is the relevant error message in /var/log/messages:
Code:
I'm assuming that I can conclude, then, that apache/httpd was the cause of the memory leak?
Next, I've been tracking my memory usage. Using top, this is an average memory load level for my server:
Code:
I'd like to confirm if my understanding of this data is correct, because Plesk indicates that my memory usage is only 50% or less. (Though I have read a number of reports indicating that Plesk's measurements are frequently wrong.)
Top says: Of the 2,073,156K total memory, 1,982,572K (95.63%) is being used, 90,584K (4.37%) is free. Of that sum, 421,948K (20.35%) are being used as buffers. Additionally, of the 2,096,472K of Swap, 60K is used, and 887,700K (42.34%) is cached.
My questions: Is my memory actually being 95% used? Or is the buffered quantity (20.35%) not a use of physical/virtual memory? (i.e. is it disk usage?) Does the amount of cached Swap influence the percentage of physical/virtual memory being used?
In other words, who is correct? Plesk says I'm using 40-50% of my memory, whereas top says 85-95%.
I am currently reading [URL] its an old document from 2006, so i am not really sure how much information in it is still valid.
View 1 Replies View RelatedIs it possible to like have SMS sent to your cellphone when the server crashes or a process on the server dies?
View 4 Replies View RelatedJust wanted to share this with anyone wanting to know.If your headless server crashes, GRUB2 (at least on Ubuntu Server) is designed to force the GRUB menu to load up next time it starts up, which means you are locked out of SSH until someone physically makes a kernel selection on the PC.To prevent this do the following change to your grub.cfg file.#nano /boot/grub/grub.cfg
I was looking for a solution for this for a long time and found no hel with google. Let me know if there is a better way.I aware this file will get overwritten and need reediting if the Kernel gets updated.
I am trying to share a couple of resources from my fedora 12 box to a windows vista, using samba. It seems absolutely fine to share any folder but as soon as I am trying to share a folder which is used as a mount point windows cannot access this folder. I get the following message from windows:"the network cannot be found". This must be due to some permission, but I cannot find which one.
Note that windows can access the folder but as soon as the device is mounted I v#can see the folder in windows but cannot access it. Here is a copy of the smb.config file:
[global]
workgroup = workgroup
server string = GAIA
security = share
;guest account = nobody
[Code]...
Note that I have been trying to execute the same with mounting and sharing a raid1, but windows cannot see it.
I have configured heartbeat and pacemaker with 2 nodes, all resources work well, all resources stars when some of them is down, when the host is down, pacemaker moves all resources to the other one, my configuration:
[code]...
i have the directive " resource-stickiness="INFINITY", when node1 is down, the node2 starts all resources and prevent failback again though the node1 is up, back i need move all resources to the first one when I certainly sure the node1 is runnig, is there some directive to tell pacemaker that move back again the to node1 automatically? i mean, is posibble to move back resources to node1 when It has passed certain time, maybe 1 hour or something?
I have OpenVPN running successfully on a CentOS Linux server. All remote clients connect without a problem and can ping the server LAN (10.5.0.0/24) . The server address is
10.5.0.1. All network shares on the server are available to the remote clients via SAMBA shares and this works well.The problem is that I am unable to get the remote clients to access services on the LAN clients. For example, there is a webserver running on a Windows XP PC (on the server LAN @ 10.5.0.2) with no firewall enabled. The remote VPN clients can ping this webserver at 10.5.0.2, but cannot browse the webserver at [URL]. All clients on the server LAN can however browse the webserver. The remote clients are using Windows XP and VISTA with OpenVPN 2.1.1.
I am new to VPNs and networking, but from my research, it seems as if this may be a routing issue. I would appreciate any help you may give in getting the remote clients to access the services on the LAN clients (other than the server @ 10.5.0.1).
The server configuration is:
local 192.168.10.6
port 1194
proto tcp
[code]...
I hope the server forum is the best match for my post, otherwise please redirect me.
I have a Fedora 12 Desktop machine running at a remote site and have no keyboard not a screen connected to it. After rebooting it remotely I was surprised to learn the machine did not come back up again. (It did when I tested it while I was on site).
[Code]...
How much resources are needed to run a mail server with approximately 75 boxes?
View 2 Replies View RelatedI have looked around a while for the answer, but nothing really fits. Here is the scenario. I have one server and a few openvz VE's running. I want to be able to auth whatever possible with LDAP. I have an LDAP server setup on the host and auth works for the server users. The tricky part for me is that every VE has their own domain. and if I can do that, they will also have the same login for their VE on said domain. I can setup users and the required software on the hosts and guest, but I guess I am confused at how to manage the multiple domain part of things.
not sure if proftp can do 'name based' stuff like apache, but if it can, we can point ftp.clientdomain.foo to the main server and handle it that way.
Im getting this error when i try to run mysql from a shell
Code:
ERROR 2002 (HY0000): can't connect to local MySQL server through socket
I have installed MySQL over yum on fedora.
but the path and file /var/lib/mysql/mysql.sock does not exist on my system?
I've tried /etc/init.d/mysql start, and it actually starts, or at least, it doesn't error out. But when I do pgrep mysql I get nothing, and when I try to login with mysql -p as root, I get
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
None of my other logins work, either, but since pgrep mysql didn't work, it's clear that MySQL just isn't running. I tried uninstalling and reinstalling mysql-server via apt-get, but I get the same thing. The logs in /var/log/syslog show this:
Apr 11 14:31:26 /etc/init.d/mysql[9774]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Apr 11 14:31:26 /etc/init.d/mysql[9774]: error: 'Can't connect to local MySQL server
[code].....
We have 2 servers, 1 is the webserver and the other is the Mysql server.
When transfering a 2GB file from the webserver to the Mysql server.
The webserver's connection to the mysql DB server dies completely.
Need to restart the MYSQL process in order for it to come back online.
During this connection downtime, when using phpmyadmin on the mysql server shows no problem running queries etc.
Scenario:A - Local Unix machineB - socks proxy server port 1080C - remote mysql server port 3306I want to connect to the remote mysql server(C) from local unix machine(A) using sock proxy(B).
View 1 Replies View RelatedI have a RHEL5 machine having mysql5.0.22 is installed in it. i also installed java through "jdk-1_5_0_19-linux-i586.bin" package, and its version is 1.5.0_19. I am trying to check if any JDBC driver for Mysql Server is installed on my system . How can I do this? If any driver is already installed How can I get the file path for those driver files? is it comes along with jdk packages? As i am not a programmer, and does't know more about jdbc.
View 1 Replies View RelatedI tried to install php from source file on centos server and i got the error as # ./configure --with-apxs2=/usr/local/packages/apache/bin/apxs --with-mysql --prefix=/usr/local/packages/apache/php --enable-force-cgi-redirect --disable-cgi --with-zlib --with-gettext --with-gdbm
checking for specified location of the MySQL UNIX socket... no checking for MySQL UNIX socket location... /var/lib/mysql/mysql.sock checking for mysql_close in -lmysqlclient... no checking for mysql_error in -lmysqlclient... no configure: error: mysql configure failed. Please check config.log for more information.
I have an e-mail production server that has been running fine for almost two years.
Notice mail was not serving today and login to a bunch of errors in messages
However, I think they are all from not being able to access MySQL and when I:
mysql -u root -p
I get:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
what the difference is between msql-server and mysql-community-server
View 5 Replies View RelatedI've just made my old, dusty computer into an Ubuntu Server. So far, i have installed a well functioned LAMP server, to host my Website. I have also installed a FTP-Server (proftpd) and i was wondering if i could manage my FTP accounts in MySQL so i could make an account creation page for it? If yes, how?
View 2 Replies View RelatedI like to run a mySql database server on a Ubuntu (which is no server) for local use only. Is there some instruction how to do this? I downloaded several DBMS but they all seem to assume a running server.
View 1 Replies View RelatedI would like to connect to a separate mysql server, yet I can't find any documentation on how to do this.How would one achieve this? I am running qmail on centos4.
View 3 Replies View RelatedI'm trying to move a mysql 5.1.50-community InnoDB database from one location to another.When starting the service I get:Starting MySQL.Manager of pid-file quit without updating file [FAILED]I've searched for a way to do this but I can only find people who describe what I've just done.
View 6 Replies View Related