I've got this issue for past week.
Mysql Crashes with 111 error although it starts back up instantly.
but i can't seem to figure out why.
-Server Is Deb. Lenny + Direct Admin.
Quad Core 2.5, 8GB Ram.
-Mysql ver 5.3
-Htop shows mysql is most of the time using 33 - 50% CPU.
(the init.d name is /etc/init.d/mysqld )
-This is from the err log of last crash. code...
I'm currently running LAMP on an Amazon instance. The OS is from the Amazon 64 bit image.
Basically, every so often MySQL seems to go down. All of my sites fail to connect to their databases. I then have to SSH in and restart mysqld.
Heres the last 30 lines of /var/log/mysqld.log code...
I have a VPS running a web application served using Apache, that on average deals with 20-50 requests per second. It's usually above this point (50 requests per second) that the amount of memory that Apache uses is too high for the VPS and errors start occuring - web pages crash and VPS falls over for a minute or two before going back to normal levels.
I believe that MaxClients is the best way to reduce the amount of RAM that Apache uses and I am planning to reduce MaxClients from 256 (default value) to around 100. Each Apache process uses ~15MB and the server has 1900MB of ram in total - the server does nothing else other than run Apache and a few crons.
Current setting are:
Code:
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 3
# prefork MPM
# StartServers: number of server processes to start
[Code].....
I tried reducing MaxClients before which lead to massive slowness, so I need some other options as well.
Does my suggestion of reducing MaxClients to ~100 seems sensible? What are my options if the server experiences slowness again - optimise the application? What's the best way to reduce memory usage - move images to another web server?
I have been fighting with this for days. I upgraded from etch to lenny. I tried installing mysql-5.1. I have uninstalled, reinstalled, updated, upgraded, many, *many*, times. It just stubbornly refuses to work.
Quote:
I have just updated PHP from 5.1.6 to 5.3.6
on CentOS 5.6, After reboot I have tried to install php-mysql
but I got error says code...
Been working with this problem for over a week now and has come to a dead end, I have installed pureFTPD with MySQL on Debian 5 Lenny 64bit. My problem is I can't login with the users in the sql-database, but for some strange reason, I'm allowed to loggin as anonymous. Unix users can't login either.
I have followed the guide on: [URL]..
- Created a ftpgroup and ftpuser.
- Created a database ftpd
- Created a user vhosts and given access to ftpd db
My configurations files
/etc/pure-ftpd/auth/30mysql
Code:
/etc/pure-ftpd/db/mysql.conf
/etc/pure-ftpd/db/mysql.conf
[Code]...
I have been tearing my hair out with this. As part of a backend perl script i am holding the Epoch time as session data using apache session and mysql so i can delete sessions after an expiry period. When I retrieve the time it is about three months old even when i only just set it. The code example below best describes the problem:
View 5 Replies View RelatedI'm looking for a way to put a MySQL database in a server's memory. The disks aren't fast enough to keep up with the usage and I don't feel like going for a splitted web&db server yet because of the costs.
Because this involves risks (unless there's a way to read from the memory and write to the memory AND disks?), so I'd prefer that the DB gets copied automatically every hour or so to the local disks.
Been trying to upgrade home server for several days and it keeps hanging on the mysql upgrade. Here's the what apt-get says code....
View 3 Replies View RelatedI can't get mysql to update from lenny (mysql-5.0) to squeeze (5.1). apt tries to start the server but comes up with some kind of configuration script error.
View 1 Replies View RelatedI have a 2005 emachines desktop tri-booting WinXP, Puppy Linux 5.2.5, and Ubuntu 10.04 LTS AMD64. I installed Ubuntu 10.04 LTS today from DVD and ran the update manager. The only other package I've installed is GParted. The computer has crashed twice today. Once when using Firefox and once while idling. Pictures off screen are attached.
Specs:
871 MiB of memory
AMD Athlon(tm) 64 Processor 3200+
160GB hardrive, 19 GB Ubuntu partition, 1 GB swap partition, rest ntfs WinXP
60GB hardrive, 1GB Puppy partition, rest ntfs data partition
Hardware:
Internal graphics card (VGA), keyboard, and mouse
Using wireless USB adapter to access internet (Netgear WG111v2)
Has one CD drive and one DVD drive
I've been messing around with this for a while trying different mesa packages so far none of them have resolved the issue. XFCE, Fluxbox all work however kde wont load for some reason. Ive even tried using the drivers direct from dell as this is a poweredge t310.code...
View 3 Replies View RelatedI've had problems with Amarok crashing so I reinstalled. I think its the Nvidia Driver, so I read on another thread. I tried the uninstall and init 3 thing and needed gcc and a few more files that were not installed. In the end I had enough and reinstalled. Now Amarok runs. If I install the nvidia driver I have an idea that it will crash like Ayrton Senna, or maybe quicker. so is there a simple work around.
View 9 Replies View RelatedIt seems like it is mostly happening when I am running fire fox. The screen goes black (but in in sleep mode) and I have to push the power button. After I push power button the screen goes marron-ish with an ubuntu logo with a 4 animated dots and then turns off.
when I start the PC up again I get an error about the Power Manager not ending correctly. It has happened 3 times so far today alone.
Today I installed Lenny on a new server. The server didn't have any CD-Rom, so I tried putting the net install on a memory stick using unetbootin. The install went fine, but the problem was that the memory stick became sda and two SATA disks in the server became sdb and sdc.When I then tried to remove the stick, the SATA disks became sda and sdb, and it would not boot, because it had written the MBR on the stick.It hurried a little bit, so I had to take out a CD player from another computer, and connect it inside the server to get Lenny installed.But it would be cool if it was possible to install with the stick. And no more waste of CD-Rom players that will be used only once.
View 1 Replies View RelatedI 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 upgraded my MB, CPU and memory to 4G. I am running 32 bit Lenny. In the BIOS, I see about 3.8G memory. However, in Lenny I see only about 3.2G. Is it normal? Is there something I need to do to get the most out of memory this size, like setting highmem?
View 8 Replies View RelatedIts a "Geek Squad" memory stick from Best Buy. There has been a couple of other times (recently) that it was not recognozed but after a couple of attempt it loaded. But today it is not showing up at all.
View 8 Replies View RelatedI've been trying to install MySQL in Lenny via source binaries, following the instructions given on the MySQL official website[url]
But when i try to run the scripts/mysql_install_db --user=mysql command, doesn't work.
For the record, i'm particularly interested on installing MySQL with the generic source binaries.
I can't make Gentoo recognize my 2 rams of 512MB, It's seems to recognize just 891900 KB code...
I tried to recompile the kernel with 4gb ram support but I couldn't find the "High memory support" in "Processor type and features", I think because I have a amd64 OS.
Kernel version: linux-2.6.30-gentoo-r3
RAM: hynix 512MB HYMP564U64CP8-Y5 (Specification are here in PDF)
The upgrade actually went pretty well, except for what looks like a new "feature" to mysql-server-5.1. But I post here, because the issue seemed to be in "/etc/hosts" file. If it should really be somewhere else, feel free to move it. The problem is that I don't understand what this means. What potential problems do I have without a "127.0.1.1"? Or could this have been effected by some change to the "users" table in mysql? This mythtv server "musem" is my main machine, and is being remotely accessed by the Linux box next to my TV.
View 1 Replies View Relatedi'm new to Debian os and currently want to install php5 apache2 and mysql 5.1. But ive got problem to start the mysql services.The error on command prompt as belows:
[Code]...
Few months ago I downloaded a Turnkey virtual appliance with Wordpress pre-installed. I used this as a VM on my laptop and configured it. Then when everything looked good, I transfered it to my hosting provider (which is the company I work for) and they put the VM on ESX and connected it to the internet.Now I'm running into the issue that sometimes quite often and sometimes not for a week or so, the VM will hang.
View 2 Replies View Relatedlet me know how to clear cache memory ( RHEL 5.1 ) as it consumes almost 100% physical memory.
View 3 Replies View RelatedI have fedora version 8 with mysql 5.0.45 installed. I have also installed drupal. Recently drupal gave me an error "error code 28". When i checked it out it seemed to be with the db. When i tried to created a db (for testing purposes) in root...i wasn't able to. so then i tried to restart mysql ...it stopped but unfortunately i have not been able to get mysql back up...i get a message saying
"Timeout error occurred trying to start MySql Daemon".
we found that if we use 'top' to show the memory usage of a server (SuSe Linux 10), we can get virtual memory usage as well as 'Resident memory' usage. For virtual mem or a particular process, it is around 1.1GB, which is large but for resident memory, it only consumes 300MB. Are there anyone who knows what the differences are? I would also like to know whether the difference (1.1GB - 300MB) = 800MB are actually available for use by other applications in the system.
View 1 Replies View RelatedI have been setting up a vps I got out with bhost.net, with CentOS installed. I've been learning and have set up everying I need with the exception of ftp/sftp.
Using yum I installed vsftpd and ran into problems, thinking it was something I might of done I did a fresh install of CentOS and I still recieve the same problem on a fresh install so it is nothing I have done to the server.
The problem is when connecting via a sftp client I get an out of memory error. This error is listed in the putty faq ( url ) under A.7.5, there is a brief explaintion of the cure under A.7.6.
there is mention of a login script but I don't know where this is located. I'm a novice at Linux but by no means incompotent when it comes to computing.
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.
I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code: