Configuring MySQL/Apache To Run A Larger Website More Efficiently
May 12, 2007
I'm running a comic site on a dedicated linux box that has weekly releases. When a new release comes out I'll typically get 4000-5000 unique hits an hour. The problems started when I set up a MySQL download logging system, that would query and display the file names when the user loads the site, and update +1 when they download a comic. Yesterday after a release, the site became very slow to access, and after about 20 seconds you'd connect and be able to browse freely at nice speeds but if you went idle you'd have to wait about 20 seconds to connect again. The other domains on the server were running fine, and I could access my whm fine as well, the server load was 0.10 or lower.
I'm assuming there's a max connection limit somewhere either on the mysql or apache side that's restricting the site from handling the load it's getting. I've poked around google and researched it a bit but couldn't really find much. I don't have an enormous amount of time to invest in this because it's just a hobby so I'd appreciate any help one of you could offer!
View 2 Replies
ADVERTISEMENT
Sep 22, 2008
I have setup php and mysql on a windows IIS 6 server. php has installed fine and works but I have 2 problems
1. When i browse to http://localhost i get a 403 error but when browsing to http://localhost/index.php it works fine. It makes me think that the server does not know what extension to default to when doing a directory listing
2. I have phpmyadmin installed and the cfg file is set to do a 'config' authentication. That works but everytime i go to submit a form to create a new database or anything i get prompted with an HTTP user/pass. I'm not sure if this is a phpmyadmin issue or a php configuration issue
View 1 Replies
View Related
Jul 25, 2007
I'm using Windows XP and installed Apache, PHP 5 and MySql 5. They were all working before, but recently I had to format my hard drive. Fortunately, I had an image of my computer created from before but MySql was not installed when that image was created.
After deploying that image, everything seems to be working fine. The server is running and PHP scripts are executing as well. But I can't seem to have MySql to work. I've followed many tutorials online, but have no luck.
I have edited the php.ini file to point to the correct directory that holds the extentions or dll's. I also enabled the following:
extension=php_mbstring.dll
extension=php_mysqli.dll
extension=php_mysql.dll
I already tested to see if MySql was correctly installed by using the command line client and it seems to be installed. I was able to log in and see the default databases created.
But when I run the following php script
<? phpinfo() ?>
I don't see the MySql section anywhere and that's why I'm assuming that PHP is not currently working with MySql for me. However, interestingly, I do see the "mbstring" section, which I assume should show only if MySql is working with PHP. But nothing else related to MySql info shows up. I've attached part of the screen shot if it helps you.
View 3 Replies
View Related
Mar 24, 2008
Since I have never worked on the server end of things I had a quick question for all you web hosting gurus.
Is it possible to have PHP installed on ONE single server and still have the ability for the server to work with both MS Access AND MySQL at the same time?
I would think YES, but I am being told by our server branch at my current job that this is not the case. They claim there is no way for the server on one machine to be able to handle both types of databases. Are they right?
If they are wrong and it is possible to have one server run both type of databases, what steps would be necessary to set up the server to handle both types? Do we need to tweak the php.ini file or is there another method of allowing the server the ability to work with both MySQL and MS Access.
Sorry if this question seems stupid or odd, as I said, I have minimal experience on the server end but I am confident that a server can handle both.
View 10 Replies
View Related
Dec 28, 2006
I'm over here trying to rebuild php with GD in WHM, I go through the entire motion of Apache Update (with GD selected as a PHP Module) and ummmm... after it's done, I check my phpinfo() and there is no GD section, let alone has the build date been changed.
View 9 Replies
View Related
Oct 28, 2008
i couldn't find a more suitable category to put this post in: I am setting up a development server local to my office here, so that we can develop projects using an SVN app, but the SVN system needs SSL for logging in. i am now going round in circles where httpd.exe cannot start as a service from the apache monitor, with the following error:
The Apache service named reported the following error:
>>> httpd.exe: Could not reliably determine the server's fully qualified domain name, using 192.168.1.84 for ServerName
in the windows event viewer.
I'm using:
Windows XP Home edition, SP3
Apache 2.2.9
full computer name is devserver
workgroup is WORKGROUP
I used openssl bundled with this version of apache to generate the SSL certificate, and they all seem to be ok. When i change the line
SSLEngine on
in the httpd-ssl.conf file, the apache service starts when the SSLEngine is off, but not when the SSLEngine is on.
i have trawled the internet but not found any answer. ive checked thru httpd.conf and httpd-ssl.conf several times but i just can't see anything wrong (although im not entirely experienced!).
View 4 Replies
View Related
Dec 10, 2013
I am really having trouble getting a virtualhost to work for an SSL certificate.. my browser just will not load the page..I have tried several different articles on how to setup a virtualhost and none of them seem to work.
My ssl.conf [URL] .....
*Note: I did purchase an SSL certificate - it is not self signed.
View 13 Replies
View Related
Apr 7, 2014
I've been trying to figure out some IP blocking with no success. The environment is UNIX and Apache version is 2.2.22-14.
The site is on a hosted solution and doesn't have a firewall due to the virtualization software limitations. I've tried setting something similar to the following:
Code:
<Directory /home/username/mysite.com>
#IP Blocks
Deny from 1.2.3.1/24
Deny from 1.2.4.5
etc..
but with no success. I've also tried it in the <Location> tag with no success.
The way I'm testing this is editing the conf and then bouncing the apache server.
View 4 Replies
View Related
Aug 15, 2005
I posted this problem in the PHP forum without a response. I thought this forum might be better.
View 0 Replies
View Related
Apr 27, 2006
I'm currently trying to configure apache 2 to handle subdomains. This is on a local machine (not tied to any domain names) and I'm only doing it to research how the final structure of a site 'could' be setup.
Basically I have a single install of Apache 2 running. The outcome eventually should be to have specific sub domains that all point to the same document root as the actual domain name. So eventually I will have:
http://www.mydomain.com
http://subdomain1.mydomain.com
http://subdomain2.mydomain.com
with both subdomains showing the content at mydomain.com (there is reasoning behind this but I'm not gonna go into that).
I have apache setup as follows:
NameVirtualHost *:80
<VirtualHost *:80>
ServerName daneastley
DocumentRoot "C:/Program Files/Apache Group/Apache2/htdocs"
</VirtualHost>
<VirtualHost *:80>
ServerName subdomain1.daneastley
DocumentRoot "C:/Program Files/Apache Group/Apache2/htdocs"
</VirtualHost>
<VirtualHost *:80>
ServerName subdomain2.daneastley
DocumentRoot "C:/Program Files/Apache Group/Apache2/htdocs"
</VirtualHost>
Now on my local machine, only the top one works - the subdomains dont. if I add the following into my hosts file in windows, they all work:
127.0.0.1 daneastley
127.0.0.1 subdomain1.daneastley
127.0.0.1 subdomain2.daneastley
the problem being, that I wish to test this enviroment on the local network. How would I go about having every computer being able to access this? I'm assuming it comes down to DNS stuff.
View 0 Replies
View Related
Oct 23, 2013
have a website that sources a number of jquery plugins, when I load the site in chrome or firefox the javascript console is saying that these files were not loaded.
The server is a localhost and the files are local.
The google jquery file loads fine.
how I need to configure the apache config file to deal with javascript.
View 2 Replies
View Related
Mar 24, 2009
Anybody know the best place to get a really cheap server with at least 250GB drives? I'm assuming most providers offer HDD's of that size on relatively cheap systems now if we're just looking at SATA.
The machine doesn't need to be anything special, I don't need a ton of bandwidth.
Basically this will be an extra backup machine to pull backups from servers instead of my usual "pushing" of backup data.
So to clarify, I'm looking for a simple machine pretty much anywhere with some drive space! VPS just won't cut it because the drivespace they provide is too expensive (yes, I understand they have nice drive setups though).
RAID etc is not needed, I'm not running anything mission critical but would like to have more locations in place to hold backups for me. WHT worries me alot
View 14 Replies
View Related
Jul 21, 2009
i have a msi server with three seagate HD,
and use seagate ST336607LC to do raid5.
the raid card is adaptec 2200S,
it is installed with centos with cpanel.
today,the websites shows 500 internal error and i asked the DC reboot,
minutes later,the websites run well.
but minutes later,it down again,and i ssh to reboot,
minutes,it shows file system problem,it seems readonly?...in my memory.
and i ask the DC to reboot again,
and i still can not login,and the DC staff tell me it shows with "operation system not found"...
and i go to DC,
it shows there is no logical drives... and operation system not found.
and i try to use ctrl+a to access raid control panel,
it shows there is no raid setting....
and i try to verify the hds in raid control panel,
it shows my 3rd hd has defect and ask if want to assign new block,
at begining,i chose no,it still can not load the os.
and then i chose yes to reassign the block and passing the verify,
but it still can not load the os.
i can not get any ST336607LC now,
i want to ask can i use larger HD to replace the 3rd hd?
if yes,after replacing and booting,
should i reset the raid configuation?
View 7 Replies
View Related
Jul 11, 2008
the device which i transfer the full backups to through ( wget ) is full 100 %
Disk /dev/sda2 (/) ............ 100 %
i want to know if there is some safe way to make the space of the device larger?
as the cpanel is suspended for that reason
and how to know the files in that device and delete what i don't want
centos 5.2
cpanel 11.23
View 13 Replies
View Related
Jul 29, 2009
How to disable cPanel's backup feature for accounts larger than 1GB?
View 4 Replies
View Related
Jan 6, 2014
OS: CentOS 5.9 (Final)
Panel version: 11.5.30 Update #28, last updated at Dec 26, 2013 04:20 AM
php: php53u 5.3.27-1.ius.el5
php.ini
upload_max_filesize = 20M
memory_limit = 128M
post_max_size = 20M
Browsers: Chrome Version 31.0.1650.63 m and IE 8
smaller files upload fine, though when reaching the 10MB and above level, after the attachment loads the new message window defaults to the Your Session Has Expired. Please Login Again.
Are there any settings that I am missing, or is this a current bug in this version of Horde?
View 9 Replies
View Related
Apr 19, 2008
have just had a website created for me where I can store my photos on. It uses JSP + MySQL for the databse which stores the photo IDs, photo location etc. I want to get it up and running on the net but have no idea how to do this!
View 14 Replies
View Related
May 9, 2013
I've installed apache on my windows 2008 vps . It's run and when I browse localhost , it's works fine . But when I enter the vps ip address , it says Chrome could not connect to ... , I'm sure that httpd is running on port 80 (I checked it via netstat -ao and task manage ) ....
View 1 Replies
View Related
Dec 20, 2013
I m newbie to apache server. I have created a web site using apache server with theURL... tutorial. I m able to access my web site on my ip address bt unable to access it using other ip of linux system. I m CentOS user. I can ping that ip with my ip. I have edited files as described in the tutorial.
View 1 Replies
View Related
May 27, 2014
I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.
View 1 Replies
View Related
Mar 2, 2014
I have 3 computers on the same network. One running apache2 on Ubuntu 12.04 and the others with Windows7. I want to access the website I set up from a Windows machine. When I type in the URL, domain.com, I get a 404 error. When I type in 127.0.1.1/domain.com I get the directory listing for the website. I have to actually type 127.0.1.1/domain.com/public_html/ before the website can actually be seen. I would like to get rid of the public_html part. I am brand new to all this.
View 1 Replies
View Related
Jan 23, 2014
How do I add multiple web pages to my server?
View 6 Replies
View Related
May 23, 2015
I'm trying to fix a problem with open proxy on my website. It's running ubuntu & apache2. I also run pfsense for a firewall with snort. I have a SSL for the website, so I have regular port 80 redirect to https.
At first I did notice right away when I checked & saw this happen that proxy was turned on. So I got that turned off.
My firewall is still allowing these bad IPs to port 80. I would like to figure out what I could turn on the firewall or snort to stop those connections in addition to what needs fixing in apache. I've read the solution is to make the redirects go to a 403 error page.
I also tried adding a mod_security rule but ended up blocking all people from website, though I may have accidentally turned some other rules on too.
There are a few different problems it looks like.
First - It looks like they're trying to connect to my HTTPS then redirect to an ad through my domain name?
Second - It looks like they're still trying to use my website for open proxy but directly accessing ib.adnxs.com through my port 80. My logs indicate I'm redirecting to a 301 page.
View 2 Replies
View Related
Feb 4, 2013
We have a Joomla based website and we are using the inbuilt cache to make the website fast enough for our users... but it really isn't working well... i would say.
The Joomla Cache is very limited and we were thinking if we can enable a server side cache for apache/php or something like that... which would work above Joomla and make all the contents cacheble.
View 14 Replies
View Related
Feb 12, 2015
I have a VPS and run few websites. I am not good in Apache and Linux. I just got a dedicated IP address for one of my domains. I like that the website opens just by typing the IP address in the address bar of the browser. How can I activate that?
View 5 Replies
View Related
Mar 14, 2015
So, let me start off by saying I am completely new to website and FTP server hosting. I've hosted game servers in the past so I know about port forwarding and the like but this is obviously a step-up. I've managed to get a fully-functioning FTP server that works great on the domain I'm using but the website using Apache just gives people a blank white screen (as stated in the description). I'm using port 55567 for the website as I don't know want to use 80 because of security risks and what not. The domain being used is delawaretexasrepository.t28.net. Below are the error.log, httpd.conf and httpd-vhosts.conf.
httpd-vhosts.conf: [URL] ....
httpd.conf: [URL] ....
error.log: [URL] ....
View 8 Replies
View Related
Jul 18, 2013
We are getting infinite loops due to the user requesting the same page continuously , even if apache sends a 200. It is happening randomly once every two or three weeks for different users.This issue is not confined to one browser it is happening with firefox 21, firefox 5, ie 8, etc. It is not happening to the same user again.
It is a PHP based website with custom CMS.We are never able to replicate this issue.Is this something related to a plugin installed on a browser ?
PHP Version 5.3.8
Mysql
Apache 2.0
SUSE
View 1 Replies
View Related
