Server :: Server Slow : Apache Mysql Fine Tuning Server For Faster And More Responsive?
Apr 21, 2011
I'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?
I've been trying to set-up/tweek these param's in Apache to a setting suitable to the server for the amount of memory. When i look around some people say, hey.. just look at the memory used per process and then divide that by the amount of memory available and you get the number of processes that can be handled by Apache in one go before it starts swapping.
Well, for this i'd done this calculation and for me it turned out to be 200 approx concurrent connections. Well funny thing is, out MySQL server had a slow down so the Apache servers were running at approx 450 concurrent connections and weren't swapping in memory etc (still had 600MB free not including what was available in Buffers/Cache - 'free -m')... Thus if i had have set the limits to 200 then people would have been not getting to the site, so i'm kind of pleased that i happened to not have the time to set this yet.
My intention is to have EngineX on the frontend handling all static files, and Apache + mod_php in charge of handling PHP requests. I have optimized nginx to be as efficient as possible in handling static files, but have very little experience with Apache. Since Apache would only be processing PHP requests, would the standard Apache optimization guides suffice or would it best to configure it differently?
PS: this is a dedicated file server, the database is hosted separately.
I have changed my home network a bit, and everything works extremely fast, except for my apache server, which seems to serve webpages so slowly, it is abnormal. Even simple directroy pages are served in around 5 sec, and this is not a joke! It used to work pretty fast. What I have changed is that i replaced a hub with a switch, and that I linked my personal PC with my server together through a hub. I also installed Gnome desktop on the webserver machine. My network now looks like follows:
i've been having some problems the last few months with my server/apache getting really slow (pages loading slow) and the only way i can fix it is to restart apache which is quite annoying and is not fixing the problem but it gets to the point where pages are almost not loading so i have to keep restarting apache but after 2mins it'll be slow again and once again i'll have to restart apache...i forgot to say that memory usage is a little higher then normal (500mb-700mb compared to 250mb-300mb - but goes back to normal after restarting apache) and the load is also a little high but always under 1 (also note my server is on a 100mbits port and i can easily push 100mbits 24/7 with no problems at all so it's not bandwidth)
Running slackware13.1 with mysql on box2 and apache on box1 both in same lan. How do i configure mysql for apache connection? I have looked at many mysql config. howto which i can follow but i'm confused about whether the connection type is considered remote connection because the 2 services are on seperate boxes but are in same lan? Apache will be serving public webpages not just to the lan.
We are working on a new ERP for the company. This will run in MySQL 5.1.x, the GUI will be Web, the language PHP. This is a big project, is a good option to have the 3 applications in the same server or is better to have Mysql on 1 server and httpd+php on other server?
Speaking that I want to virtualize this app with Xen on Centos 5.5 as Host and the guest's will run Ubuntu.
I have a problem with AMXbans. My Linux is Slackware 13.0. , mysql is version 5.0.84, Apache/2.2.13,PHP 5.2.3 from locahost or real IP in internet explorer i see this error " Lost connection to MySQL server at 'reading initial communication packet', system error: 111". In /var/log/httpd/error_log I see this error:
" [error] [client IP] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>>function.mysql-connect</a>]: Lost connection to MySQL server at 'reading initial communication packet', system error: : 111 in /var/www/htdocs/web/include/config.inc.php on line 48, referer: http://My real IP/web/ //connect to db - "this is line 46" $config->db_host=gethostbyname($config->db_host); "this is line 46" $mysql = mysql_connect($config->db_host,$config->db_user,$config->db_pass) or die (mysql_error()); - "this is line 48"
I run mysqld on another server. I just switched to another dedicated server now, and i'm having trouble connecting to the mysqld server. If i run the php script from the bash console( php connect.php ) it works perfectly and connects to the mysqld server. However, if i run the script from apache ( http://localhost/connect.php ) it returns this: Can't connect to MySQL server on '(mysqld real ip)' (13) Mysql connection from another server(old httpd server) works perfectly, so it's not from the database server.
I have a debian box running Apache2 and PHP5.2.6 lenny.
When a request is made via https, php displays the content fine. If the request is made over HTTP the file is offered for download, rather than displaying it.
I know its probably something trivial but I've never seen this issue.
The plot thickens, I can display PHP over HTTP in some directories but not others (which offer the file for download)?
I am trying to solve a problem where Apache stats aren't displaying correctly in Munin. I've ran through quite a bit of checks and tests regarding Munin setup, but I think my issue is related to Apache, but my skill set there is lacking.
first, system info: monitored server: CentOS 5.3 2.6.18-128.1.1.el5
i have apache and mysql running, i can access my web server by visiting localhost on port 80 but for some reason when it doesnt work when i try using my ISP provided IP address... (it used to work).. i have my router setup with a DMZ on my LAN IP (my computers IP, this is the computer in my home network that serving with apache).. i also cant seem to shut down my mysql server (theres an update ive been trying to get) even when i use sudo...
Good tutorial, using images for a lamp server that has, MySQL,PHP, Apache, FTP with all the fruit for running a server that will host a Gallery, forum and main site
I know there's heaps around for Ubuntu 9.10, but its not quiet what I'm looking for as in Gd, ImageMagick and some extras for Apache mods
I need to tune the mysql and apache server for the comparatively busy webserver. My scenario is like this.
1. The Web request is around 2000 request at a time or more. 2. Each web request will generate one mysql query. 3. The query to database is all read. 4. This server load will be at peak for around 3-4 hours after that the load will subside. As the task will be published, around 300,000 will be viewing the page.
5 quad servers are deployed, load is balanced via DNS but performance is not as expected. Centos 5.5 is used as OS. Top command shows The mysql process is around 185%!
I just installed Centos 5.5 on one of my systems today and something is eluding me. Basically I had a web site and forum software (phpBB, but I don't think it's that, other forum software like Xoops does the same thing) running on Fedora 13, and I copied it over to the new Centos installation. Apache is running fine and displays a PHP test file and .html files just fine.
MySQL seems to be fine, I can log into that, show databases etc. Just can't get any forum software to know there is MySQL there. I did change the path of the site, and the databases, and edited /etc/my.cnf and /etc/httpd/conf/httpd.conf to reflect that. Thought I made the needed changes in /etc/php.ini but who knows. Seemed like everything should have tar'd up and moved easy, but not the case...
Just setup an Apache2 server, and I would like to setup a login. I also wanted to use the same method that is setup for vsftpd For vsftpd I've created a mysql database.... structured as:
Code: mysql> use vsftpd Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> describe accounts;
I have CentOS 5.5 x86_64 with Apache, php and mysql. I have just installed OTRS (helpdesk - trouble ticket system) on that server and no users. This system works with perl, apache and mysql. I notice that is slow to respond and at times unresponsive the apache welcome page. 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:
A Linux (CentOS5.3) server is setup with apache reverse proxy. The reverse proxy server is opened to outside and an internal server is mapped to ProxyPass configuration. SSL certificate is also installed on the Apache reverse proxy server. The problem is, it is extremely slow in serving http requests through reverse proxy. There is no problem with server resources or bandwidth. When the internal server is directly accessed through Internet, there is no delay. The backend server and the reverse proxy server are also on the same switch (same subnet). When I searched the Net, there were recommendations to enable cache in Apache. I did so as follows in httpd.conf.
But still there is no progress. Do I want to enable cache in ssl.conf too? Or is there any other workaround to speed up Apache reverse proxy. Is there a way to check that caching is happening?
I'm working on a side project where I would like to install three ubuntu server systems,each with only one task.So server0 would be the apache server, server1 would be the database and server2 would be the file server.which key terms I should be researching?
I started over combining the first parts of this guide: [URL]..ubuntu8.04 (Only the first few parts in terms of configuration and naming). Then I used this guide: [URL]..Surprisingly enough all steps worked.
1. Now I need to set up LAMP servers with MySQL master/slave replication and Apache rsync.
2. Next i need to add BIND to both my Load Balancers with master/slave backup and replication...
Are there any guides to look at to follow on these? Can tou point me to the right direction for BIND with replication.
I'm a total Linux noob, but I've needed a working development server for a while so I've put together an old celeron box running Ubuntu Server 10.10.The box runs fine, as does the Apache and MySQL servers, even if they did take a little while to fine tune!The problem I have is that vsftpd doesn't respond unless I'm logged on locally or via putty. As long as a local user is logged in, it's fine. If I try to connect when noone is logged in, then the connection times out waiting for the server message, and thereafter I have to login and stop / restart the vsftpd to make it work again.I'm not sure if the vsftpd is set to run on boot or on login and I have no idea how to check. Vsftpd is set to allow only local users, of which there is only one - so I can't check if it would work with any user logged in
we having more than 5000 users and will have 7 squid proxy servers with high end configuration upto 4gb ram n 320*5 HD in rhel4&5 most of them complaining that at peak hours their browsing speed is slow but we are having 1gbpgs link at peak hours i.e when established connections r flowing more than 550 browsing gets slow how to do fine tuning are squid is only responsible to access upto 600 connections
I am a GNOME user but because of the release of GNOME 3 i decided that i may have to start using KDE. So i installed KDE 4.6 from the qt-kde debian repository. It works more or less OK but i have a problem with the performance. It just doesn't feel as snappy as GNOME. For example if i have minimized Firefox when i maximize it it takes about a second for the window to draw and until then i just see and empty window. Or when i open nautilus it too takes a little to open and draw the window. Overall KDE seems a little unresponsive. Is this normal? And second, from time to time there seems to be huge performance issues - KDE suddenly becomes very slow - programs take a while to open, and the windows draw even slowlier than what i described previously. Also whenever there is a slowdown (like for example when i start a program) i hear some kind of scratching noises from a my laptop - like there is a heavy hard disk activity. I've heard that kind of noises before when doing something very demanding like compiling or archiving something.
Is there any way to make KDE more responsive and faster. I have disabled strigi and nepomuk.
I am running KDE on Debian Unstable with kernel 2.6.39-1-amd64 and NVidia driver 270.41.19 on a Thinkpad T61 laptop with Intel Core 2 Duo T9300, Nvidia Quadro NVS 140m and 4GB of Ram.
I 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.
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
