Mysql Insert/Update Makes Apache Go Crazy
I run a wordpress blog with apache2+mysql5+php5 in a Debian vps with 1024mb ram (plus swap).
When you read the website everything works quick and smooth, but when you have to add data to the database (edit posts, write posts, write comments) something weird happens.
monitoring the system with the top and I see that, for example, as soon as an article has been posted (already got the "article posted" message in the page) the free ram goes suddenly down (some seconds) from 800mb to 0. Swapping starts and the website stops responding. in the meanwhile cpu "wa" goes high (90%++).
Typing ps aux I can see that is not mysql process's fault, actually it seems more that it's apache to cause this ram hogging, in fact an apache restart brings back tons of free ram.
this is my current my.cnf:
Code:
client]
port= 3306
socket= /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket= /var/run/mysqld/mysqld.sock
nice= 0
[mysqld]
#
# * Basic Settings
#
user= mysql
pid-file= /var/run/mysqld/mysqld.pid
socket= /var/run/mysqld/mysqld.sock
port= 3306
basedir= /usr
datadir= /var/lib/mysql
tmpdir= /tmp
language= /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address= 127.0.0.1
#
# * Fine Tuning
#
myisam_sort_buffer_size=64M
max_connect_errors=20
connect_timeout=15
interactive_timeout=100
join_buffer_size=1M
sort_buffer_size=1M
read_buffer_size=1M
bulk_insert_buffer_size=16M
key_buffer= 64M
max_allowed_packet= 16M
thread_stack= 128K
thread_cache_size= 8
max_connections = 600
table_cache = 256
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log= /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
#log_slow_queries= /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
#server-id= 1
#log_bin= /var/log/mysql/mysql-bin.log
# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
#expire_logs_days= 10
#max_binlog_size = 100M
#binlog_do_db= include_database_name
#binlog_ignore_db= include_database_name
#
# * BerkeleyDB
#
# Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
skip-innodb
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Apache Is Going Crazy
OS: Linux RedHat 5 From time to time Apache is going crazy and just keeps going down. After restart it works for like 2 minutes and fails. I thought the keep_alive was after all this but apache fails no matter if its on or off..
View Replies!
View Related
Apache Do Not Update
i enable Mbstrings and Soap in easyapache in Cpanel. after 24 hours i restart my server and some things get eror. tmp folder become read only. easy apache give below eror : Code: Died at /var/cpanel/perl/easy/Cpanel/Easy/Utils/BackGround.pm line 40. and all site have eror for tmp and mysql. i change tmp folder but some eror don't solved. Code: Can't create/write to file '/tmp/#sql_1f42_0.MYI' (Errcode: 30) SQL=SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt FROM jos_menu AS m LEFT JOIN jos_menu AS p ON p.parent = m.id WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= '0' GROUP BY m.id ORDER BY m.parent, m.ordering Warning: Invalid argument supplied for foreach() in /home/music/public_html/modules/mod_tpmenu/tpmenu/dropdown/menu.php on line 127 Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /home/music/public_html/modules/mod_tpmenu/tpmenu/dropdown/menu.php on line 150 this is mount command : Code: /dev/mapper/VolGroup00-LogVol00 on / type ext3 (rw,usrquota) proc on /proc type proc (rw) sysfs on /sys type sysfs (rw) devpts on /dev/pts type devpts (rw,gid=5,mode=620) /dev/sda1 on /boot type ext3 (rw) tmpfs on /dev/shm type tmpfs (rw) none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw) /usr/tmpDSK on /tmp type ext3 (rw,noexec,nosuid,loop=/dev/loop0) and this is fstabs : Code: /dev/VolGroup00/LogVol00 / ext3 defaults,usrquota 1 1 LABEL=/boot /boot ext3 defaults 1 2 tmpfs /dev/shm tmpfs defaults 0 0 devpts /dev/pts devpts gid=5,mode=620 0 0 sysfs /sys sysfs defaults 0 0 proc /proc proc defaults 0 0 /dev/VolGroup00/LogVol01 swap swap defaults 0 0 /usr/tmpDSK /tmp ext3 defaults,noauto 0 0
View Replies!
View Related
Apache Update Problems (yum)
Just started running a new VPS and have tried to update apache through WHM and I get this error : Checking Update System........Your operating system's rpm update method (yum) was not able to locate the glibc package. This is an indication of an improper setup. You must correct this error before you can proceed. Someone told me to check out yum so I ran a command that he told me too and got this output : Traceback (most recent call last): File "/usr/bin/yum", line 29, in ? yummain.main(sys.argv[1:]) File "/usr/share/yum-cli/yummain.py", line 94, in main result, resultmsgs = base.doCommands() File "/usr/share/yum-cli/cli.py", line 381, in doCommands return self.yum_cli_commands[self.basecmd].doCommand(self, self.basecmd, self.extcmds) File "/usr/share/yum-cli/yumcommands.py", line 150, in doCommand return base.updatePkgs(extcmds) File "/usr/share/yum-cli/cli.py", line 672, in updatePkgs self.doRepoSetup() File "/usr/share/yum-cli/cli.py", line 109, in doRepoSetup self.doSackSetup(thisrepo=thisrepo) File "/usr/lib/python2.4/site-packages/yum/__init__.py", line 338, in doSackSetup self.repos.populateSack(which=repos) File "/usr/lib/python2.4/site-packages/yum/repos.py", line 200, in populateSack sack.populate(repo, with, callback, cacheonly) File "/usr/lib/python2.4/site-packages/yum/yumRepo.py", line 91, in populate dobj = repo.cacheHandler.getPrimary(xml, csum) File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 100, in getPrimary return self._getbase(location, checksum, 'primary') File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 93, in _getbase self.updateSqliteCache(db, parser, checksum, metadatatype) File "/usr/lib/python2.4/site-packages/yum/sqlitecache.py", line 382, in updateSqliteCache cur.execute("DELETE FROM "+table+ " where pkgKey in %s" % delpkgs) File "/usr/lib/python2.4/site-packages/sqlite/main.py", line 244, in execute self.rs = self.con.db.execute(SQL) _sqlite.DatabaseError: unable to open database file Its the database error that worries me, can anyone help me out with how to fix this? Running WHM 11.2.0 cPanel 11.11.0-S16999 CENTOS Enterprise 5 i686 - WHM X v3.1.0
View Replies!
View Related
Update MySql Via FTP
Recently one customer asked if he could upload his MySql database to subfolder in his root and have MySql pick it up from there instead from default location. This sounds crazy, but request is legitimate, and I was wondering what could be done to enable this user update MySql db this way, or what would be the closest alternative?
View Replies!
View Related
Error When Trying To Run Apache Update (cPanel)
I got a new server online today with a fresh installation of centos and cPanel: WHM 11.15.0 cPanel 11.18.1-R20683 CENTOS Enterprise 5 i686 on standard - WHM X v3.1.0 I have done the initial setup (ip's nameservers etc..) but when I try and run apache update I get the following: Premature end of script headers: /usr/local/cpanel/whostmgr/docroot/cgi/easyapache.pl: Please check /usr/local/cpanel/logs/error_log for the exact error. I look in the log file but it just repeatse the above error and doesnt supply any additional info.
View Replies!
View Related
POP Server Error After Apache Update
I run a dedicated server with WHM/cPanel (10.8.0). I was recently supposed to update the Apache installation to add a module, but instead of clicking "load previous config" I clicked on "start build" by mistake. This brought the installation back to default. I waited till the build was finished and then added all the modules I could remember having installed earlier. This made Apache not wanting to start. I went back to the default and then recompiled apache over and over again, adding 1 o 2 modules every time. Apache booted up fine, but for some reason my mail is suddenly acting up. I keep getting the following error on one of my domain in my client: Code: Unable to connect to POP server mail.example.com. Error sending password: -ERR Maildir invalid (no 'cur' directory) When I click OK, I get: Code: Unable to connect to POP server mail.example.com. Error sending password: Operation now in progress I have a couple of other accounts in the mail client. None of them are receiving mails, even though I can see that there are new mails present in the mailbox via webmail. My exim is configured to use mbox as far as I know. So I don't understand why I'm getting an invalid maildir message.
View Replies!
View Related
CPanel Just Setup, Doesn't Want To Update Mysql
I finally broke down and just got a cPanel license to fix my multiple account problems, and had it installed... But now I have a problem that I can't seem to fix - MySql won't update to 4.1.21, its stuck at 4.1.18 which means I can't use PHP 5+... I can't update to MySQL 5.0+ because my databases (Which I have yet to move over) are 4.1 and should probably stay 4.1 until I know for sure it won't break anything. Does anyone know whats going on and how I can fix this? I've tried "/scripts/mysqlup" and "/scripts/upcp --force", as well as Apache update in WHM, and manual cPanel update in WHM. Heres what it says when I use mysqlup: Quote: MySQL Setup Script Version 7.0 This is the MySQL installer for OS FreeBSD mysql-client-4.1 (4.1.18_1) is already installed. mysql-server-4.1 (4.1.18_2) is already installed. Install Complete
View Replies!
View Related
Used Apache Update/some PHP Scripts No Longer Working
Having some issues here, I used Apache Update to install WHMCS as I didn't have Curl installed. Well had some issues using the username and password as it couldn't connect to the database, my modernbill and phpnuke scripts still work but some other scripts like joomla, some shopping cart software, and other MYSQL scripts are not working. I've run test scripts to see if I can connect to the database, got the following error with the PHP test script Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'data_invoice'@'localhost' (using password: YES) in /home/data/public_html/test2.php on line 4 I cannot connect to the database because:Access denied for user 'data_invoice'@'localhost' (using password: YES) Also attempted it in SSH and getting a similar error that access is denied. Username and password are correct. I believe I upgraded PHP which my guess is what caused this. I've searched the forum for a few solutions and I had the problem in the past which I fixed it, but it's been a while.
View Replies!
View Related
Server Update, Too Many Apache Processes But Low Load
I have 2 almost similar webservers: debian 3.2, P4 3GHZ, 1 Gb ram, kernel 2.6, apache2, php4 Initial apache2.conf: Code: Timeout 4 KeepAlive Off KeepAliveTimeout 2 ServerLimit 1500 <IfModule prefork.c> StartServers 10 MinSpareServers 10 MaxSpareServers 15 MaxClients 1500 MaxRequestsPerChild 3000 </IfModule> I update the sources.list on server 1 to mirrors of the new debian 4 etc . I run apt-get update and apt-get dist-upgrade . A whole bunch of things get updated (it was long time ago that I did this anyway). After some troubles with /boot/grub/menu.lst the server boots ok, and everything is well. This server used to have loads of 15-25 at peak times, but after the update its running very smooth with loads of 2-3 at the same peak times. I dont know why exactly, as I noticed updates in OS , kernel version (from 2.6.8x to 2.6.18) , apache2 , php (4.4.4-8+etch1) , and I also needed to update eaccelerator from 0.94 to 0.95 . A few days later I update server 2. Everything seems to go the same, although the kernel version stays at 2.6.8-3-686. I dont think kernel version at start was exactly same at server 1. But the new php version is the same as server 1, and everything else looks the same too. But when peak times are coming up, this server starts to have troubles. It is quickly rising to total of 200-300 processes , while server 1 always stays stable at 60-70. Server 2 also reacts slow if I click somewhere on the site. It takes 5-10 seconds to show a new page. However the load stays pretty low at 1-2 . I see no big cpu usage and also no big memory usage. I have the impression that this server 2 is somehow wasting a lot of apache processes and is making things hard for itself without a real reason. When I check the seperate mysql database server, I also notice a lot of processes. Around 200-250 whereas it used to be 40-60. Sometimes this adds up so hard, that all webservers are blocked because mysql has too much processes. When I check the mysql connections, I see a few dozen things like 'unauthen ip:port Connect login' just hanging. All of them have the ip of webserver 2. Those extra apache processes are somehow hanging on to the mysql server without really doing something. I dont know what is happening, but this server is underperforming very badly now. I managed to limit the problem by drastically lowering ServerLimit and MaxClients on webserver 2 , but this is no real solution. The server is still slow, at least now its not bringing down the others. My question : what should I check for now ? I noticed a different structure in the conf files in debian etch, maybe something new has a bad influence on my old conf files? Is there something wrong with the combination of kernel+php version? I have no idea, please point me in the right direction so I can learn from this.
View Replies!
View Related
Apache 2.2 / Php 5 Update: Calling Files Behind Root
With my old Apache 1 and PHP4 I was able to pull files from behind the public_html using a php file without any problems. Is there a reason why this does not work with Apache 2.2 and PHP5? the piece of coding below is what grabs the image. Right now i'm just seeing a red X for each image. PHP Code: if ($private == 1) { header("Content-type: image/jpeg"); $im = imagecreatefromjpeg('/home/site1/private/' . $type . '/' . $mid . '-' . $iid . '.jpg'); imagecolorallocate($im, 255, 255, 255); imagejpeg($im); imagedestroy($im); }
View Replies!
View Related
Media Change: Please Insert The Disc Labeled
I just bought a new dedicated server, and when I try to apt-get something (anything like, bzip2, build-essential) I get this error: Quote: Media change: please insert the disc labeled 'Debian GNU/Linux 5.0.0 _Lenny_ - Official i386 CD Binary-1 20090214-16:29' in the drive '/cdrom/' and press enter I mean it's pretty self-explanatory, but seeing as how I can't put the CD in, because the box is not here, I have no clue what I'm supposed to do. I've had a couple VPS's before, and never encountered this problem. I'm running Debian 5.0 stable.
View Replies!
View Related
What Do I Insert Under DNS In My Registrar's Domain Options
I was able to finally set up a dedicated server, and now I'm finallly off to the easier stuff. Two quick questions: 1) How do I make it so my domain name takes me to my server's address? You know, just like how shared hosts give you the nice little DNS addresses that make everything magically work. I could just forward the domain to my server's IP, though that would not display the domain name in every page, the way it's supposed to be. 2) When I visit my server's IP, it gives me the apache welcome screen saying everything was successfully installed. That page is locaed under /var/www/apache2-default. I find that "var" directory a bit strange, is it supposed to be there? And more importantly, when I add the real stuff I want on my site, should it all go under the "apache2-default" directory? It seems to be set as the default home page dir, right?
View Replies!
View Related
File And Directory Permissions Is Driving Me Crazy
Until recently i had never used a Linux server, as i used to have a windows server. I now have a Linux VPS I am now at my wits end with file permission problems I use Joomla a lot for my websites, and i also develop and program many modules and components for it, but at the moment every time i upload a module (which is a zip file with php files that is put onto the server in the right place via php) it sets the ownership to "nobody" rather than the username so i cant access it via ftp, as it says you don't have permission or the file may not exist. Is there anyway the server can be set so it will by default set the file to have an owner name that will allow ftp access to it without me having to learn SSH Putty (which is all i have done today) or contacting my hosting company every time? I am spending more of my time with these permission problems than doing my work, it driving me barmy!
View Replies!
View Related
What Makes Free Hosts Different
Apart from being free, of course. I can see thousands of free webhosts, many of which even don't put ads, and still support Databases, custom domains, even unbelievable bandwidths. Still, how does premium webhosts remain at the top? Or what is the problem with these free hosts?
View Replies!
View Related
What Makes You Sign Up With A Provider
I'd like to get some feedback on what makes people sign up with a provider. On the flip side, what turns you away from a provider? Their site, feedback etc? Personally, I like to see a provider that has reliability, stability and excellent customer care.
View Replies!
View Related
Finding What Makes Up All That Bandwidth
I got a cPanel notification that one of my client's had exceeded their bandwidth and so the site was down. Checking, I found in AWStats that nearly 400+ MB was web traffic. It looks normal to me. However, AWStats simply grouped them all together under 'Others' without providing clear details. Is there any other way I can find out what made up that 400+MB traffic?
View Replies!
View Related
What Dedicated Server Features Makes You Go WOW!
Hey, I'd be interested to hear a bit about the dedicated server features that would "turn you on" as potiential dedicated server client. What would make you go "WOW, thats cool", which features that would be indifferent to you and which ones you'd rather be with out...and why? Thanks a lot for your input. I've listed a few options, but please feel free to post more below! (also, just to make it clear, we (uk2group.com) does not offer all of these services, so this is not a lame attempt to spam or promote our services...)
View Replies!
View Related
365 Main Makes AOLs' Dumbest Business Top 15 List
On July 24, data-center operator 365 Main issues a press release touting its 24/7 reliability & backup generators that keep the data center continuously running. That day a power outage hits and three of its backup generators fail, taking down high-profile customers including Craigslist, RedEnvelope and Technorati. [url]
View Replies!
View Related
Apache Mysql Autentification
I am attempting to configure mod_auth_mysql on Mandriva linux. It seems that database is set well since if I attempt to log as a valid user with invalid password, the logs says "user xxx password mismatch. Thus it reads the database OK. If I provide correct password I got configuration error screen and log message "no Authn provider configured, configuration error: could not check access". But I set AuthMySQLAuthoritative ON !! I spend the full afternoon with this and I will be more then gratefull for some help. Vaclav <Directory /var/www/html/test> AuthName "Awstats" AuthType Basic AuthMySQLUser apache AuthMySQLHost localhost AuthMySQLEnable On AuthMySQLPassword xxxxx AuthMySQLDB apache AuthMySQLUserTable mysql_auth AuthMySQLNameField username AuthMySQLPasswordField passwd AuthMySQLPwEncryption none AuthMySQLAuthoritative On require valid-user </Directory> LoadModule auth_basic_module modules/mod_auth_basic.so LoadModule authz_host_module modules/mod_authz_host.so LoadModule mime_magic_module modules/mod_mime_magic.so LoadModule mime_module modules/mod_mime.so LoadModule status_module modules/mod_status.so LoadModule autoindex_module modules/mod_autoindex.so LoadModule alias_module modules/mod_alias.so LoadModule rewrite_module modules/mod_rewrite.so LoadModule info_module modules/mod_info.so LoadModule negotiation_module modules/mod_negotiation.so LoadModule dir_module modules/mod_dir.so LoadModule imagemap_module modules/mod_imagemap.so LoadModule actions_module modules/mod_actions.so LoadModule log_config_module modules/mod_log_config.so LoadModule userdir_module modules/mod_userdir.so LoadModule cgi_module modules/mod_cgi.so LoadModule env_module modules/mod_env.so mod_auth_mysql is in extramodules
View Replies!
View Related
NFS With MySQL / Apache
i am setting up a new load balanced cluster for the first time. It is turning out pretty well so far, I was wondering if you guys see any future problems with this setup. So far it is working well. I have one server that is the dedicated network file server. Then two others that mount the file system from the NFS. I have mysql and apache installed on both servers. They both share the NFS mount using read and write privs. I haven't put a load on the setup yet, but I was under the assumption that this couldn't be done with MySQL, but it seems to be working great. If this does work out, it seems MySQL would be scaled just as easy as apache. Everysite in the system could be setup to use localhost which would be the same server it is served up with apache.
View Replies!
View Related
(mysql/php/apache)
I recently have got a VPS and it needs optimizing. Please would someone look at my specs and help me set some good values for a website that runs a fairly small forum. Plesk 8.1.1 Guaranteed RAM 384MB Maximum RAM 768MB RedHat Enterprise 4 AS MySQL 4 PHP 4 Apache2 my.cnf Code: [mysqld] set-variable=local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 skip-bdb set-variable = innodb_buffer_pool_size=2M set-variable = innodb_additional_mem_pool_size=500K set-variable = innodb_log_buffer_size=500K set-variable = innodb_thread_concurrency=2 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid skip-bdb set-variable = innodb_buffer_pool_size=2M set-variable = innodb_additional_mem_pool_size=500K set-variable = innodb_log_buffer_size=500K set-variable = innodb_thread_concurrency=2 httpd.conf Code: ServerTokens OS ServerRoot "/etc/httpd" PidFile run/httpd.pid Timeout 120 KeepAlive Off MaxKeepAliveRequests 100 KeepAliveTimeout 15 <IfModule prefork.c> StartServers 2 MinSpareServers 1 MaxSpareServers 5 ServerLimit 10 MaxClients 10 MaxRequestsPerChild 4000 </IfModule> <IfModule worker.c> StartServers 2 MaxClients 10 MinSpareThreads 1 MaxSpareThreads 4 ThreadsPerChild 25 MaxRequestsPerChild 0 </IfModule> Listen 80 LoadModule access_module modules/mod_access.so LoadModule auth_module modules/mod_auth.so LoadModule auth_anon_module modules/mod_auth_anon.so LoadModule auth_dbm_module modules/mod_auth_dbm.so LoadModule auth_digest_module modules/mod_auth_digest.so LoadModule ldap_module modules/mod_ldap.so LoadModule auth_ldap_module modules/mod_auth_ldap.so LoadModule include_module modules/mod_include.so LoadModule log_config_module modules/mod_log_config.so LoadModule env_module modules/mod_env.so LoadModule mime_magic_module modules/mod_mime_magic.so LoadModule cern_meta_module modules/mod_cern_meta.so LoadModule expires_module modules/mod_expires.so LoadModule deflate_module modules/mod_deflate.so LoadModule headers_module modules/mod_headers.so LoadModule usertrack_module modules/mod_usertrack.so LoadModule setenvif_module modules/mod_setenvif.so LoadModule mime_module modules/mod_mime.so LoadModule dav_module modules/mod_dav.so LoadModule status_module modules/mod_status.so LoadModule autoindex_module modules/mod_autoindex.so LoadModule asis_module modules/mod_asis.so LoadModule info_module modules/mod_info.so LoadModule dav_fs_module modules/mod_dav_fs.so LoadModule vhost_alias_module modules/mod_vhost_alias.so LoadModule negotiation_module modules/mod_negotiation.so LoadModule dir_module modules/mod_dir.so LoadModule imap_module modules/mod_imap.so LoadModule actions_module modules/mod_actions.so LoadModule speling_module modules/mod_speling.so LoadModule userdir_module modules/mod_userdir.so LoadModule alias_module modules/mod_alias.so LoadModule rewrite_module modules/mod_rewrite.so LoadModule proxy_module modules/mod_proxy.so LoadModule proxy_ftp_module modules/mod_proxy_ftp.so LoadModule proxy_http_module modules/mod_proxy_http.so LoadModule proxy_connect_module modules/mod_proxy_connect.so LoadModule cache_module modules/mod_cache.so LoadModule suexec_module modules/mod_suexec.so LoadModule disk_cache_module modules/mod_disk_cache.so LoadModule file_cache_module modules/mod_file_cache.so LoadModule mem_cache_module modules/mod_mem_cache.so LoadModule cgi_module modules/mod_cgi.so Include conf.d/*.conf User apache Group apache ServerAdmin root@localhost UseCanonicalName Off DocumentRoot "/var/www/html" <Directory /> Options FollowSymLinks AllowOverride None </Directory> <Directory "/var/www/html"> Options Indexes FollowSymLinks AllowOverride None Order allow,deny Allow from all </Directory>
View Replies!
View Related
Two Servers One For Apache And One For Mysql
we plan to buy one server for apashe and one for mysql. So first server will handle apache + cpanel + exim Dual Processor Dual Core Xeon 5140 - 2.33GHz (Woodcrest) - 2 x 4MB cache 8 GB FB-DIMM 3 x 73GB 15k RPM SA-SCSI Linux RHE 4 ES second will handle only mysql Dual Processor Quad Core Xeon 5345 - 2.33GHz (Clovertown) - 2 x 8MB cache 8 GB FB-DIMM 3 x 73GB 15k RPM SA-SCSI Linux RHE 4 ES Server will be used for forums about 4000, 5000 Simultaneous users.
View Replies!
View Related
Apache And MySQL For New Server
I just got a new box, can someone tell me the recommend values for Apache and MySQL config? It's a Xeon 3060, 2GB of memory, 2x250GB SATAII. I have a few static sites and a high traffic mysql/php forum with ~600,000 posts and about 60 members active in 15 minute intervals.
View Replies!
View Related
DRIVING ME CRAZY... Why "-force"
What's the difference between /scripts/upcp -force and not using -force? What's the difference between a forceful restart and a graceful restart? Heres my conversation with the support people from my Host... They had to update cpanel to fix a problem I was having. Techs: I am going to forcefully upgrade the cpanel.. David Howard: ok David Howard: what's the difference between a forceful upgrade and an upgrade? Techs: we use --force option Techs: with the command David Howard: well I know that, but why do forceful? Techs: I changed the "cPanel/WHM Updates" in the "update config" Techs: of WHM Techs: and is doing an upcp Techs: that will fix these type of issues generally.. David Howard: ok
View Replies!
View Related
Apache And Mysql Going Down Every Half Hour
I am facing an very typical problem, when I start apache and mysql both my site works good for half and hour or so then start getting slower and slower to load and after sometime becomes completely inactive. Then i have to restart both mysql and apache to get my site back. When sites became inactive I have to restart only apache to see it back.Restarting only mysql dont help at that time. Apache runs without any problem when running alone .(mysql stoped.)
View Replies!
View Related
What Sites Are Best For MySQL/Apache Optimization
I just switched to a new server - I went from a Dual Opteron 248 with 3GB of RAM to a Dual Clovertown with 4GB of RAM. Yet, despite having mild traffic right now, my load is rather high and my memory usage is like 80% (which is ridiculous, since that would mean I would be maxing out on the old box). For some reason, my servers usually lose access when I get around 400 people on TEXT-BASED, non-MySQL pages? How is that possible? I have really solid servers, yet people running basic Pentiums with 1 or 2GB never run into this issue. Is there any good, cheap site that would be able to properly optimize mySQL and Apache to lower the load and figure out why the memory usage is so high? Platinum Server Management never really got this done, so even though they're great for other support issues, please don't recommend them.
View Replies!
View Related
Uprgade Apache, Mysql, Php
I am running a few sites (business with modernbill, vbulletin forums) and wish to upgrade to... apache 2 mysql 5 php 5 w/ phpsuexec Any warnings on upgrading on a production server to apache 2 and mysql 5?
View Replies!
View Related
Apache/MySQL Hosting In 2 Locations -tutorial?
I'd like to have the ability to offer hosting in two geographical and network diverse locations for both Apache and MySQL. Two entirely different instances, with different everything. ie: high avail to the max. Obviously the MySQL part is harder due to the dynamic nature. I can appreciate the technical aspects of the question - such as data needing to replicate to 2 locations, dealing with static versus dynamic data, etc. In short, there's a few ways this could be done. I've not been able to find a guide in my Google searches, but I'm sure this is something that has been setup before. If you're someone with experience in having had set this up, perhaps it would be easiest if we just speak directly and work something out, either via payment or giving you a dedicated server on my network. My AIM name is IGSOBEHELPER. Please note that I am hoping to start a technical discussion about this, hence I am not posting the message in the employment section. I hope this is not off topic because of this.
View Replies!
View Related
Apache: Load Vhosts From MySQL Database
if it was possible to load vhosts from a MySQL database and the only solutions i found didnt work for me. Im running Apache on Windows. Has anyone seen anything that would work with Windows? The only alternative i can think of is to read the database info using PHP and output it to a vhosts config file. I dont want to do that though because it means restarting the server to load the new config and i hear that a lot of vhosts slows the server down
View Replies!
View Related
Best Apache/php/mysql Version Combo
What will be best combo of those 3 which is main core for running almost any web server.Presently i have latest mysql,apache and php installed,but some people says how that is not good beacuse newest version arenot tested yet well enough.
View Replies!
View Related
Do I Need Separate Apache & Mysql Servers Etc
here's my current setup has my stuff running on 2 separate "self contained" servers (eg; each runs their own apache/php/mysql): Main site/server: content: mostly static content (no mysql, very little php). currently has about 4tb/m traffic. in the summer it could push up to 6tb/m hardware: P4 2.8ghz. 1gb ram. this server has no problem handling the load. only problem is bandwidth (i have to get it off the current host) Forums site/server: content: running vBulletin. currently 400-500 peak (probably jump to 800 peak this summer) users active per 15 mins. hardware: 64bit dual Opteron 242. 4gb ram. it's absolutely griding that to a halt at peak times. it acts like 4gb memery isn't enough (it will run fine then eat through most of the 4gb. grind to a halt, then recover) personally i think it was setup/configured wrong but i've had multiple people look at it and nobody can find anything wrong in the apache/mysql settings. What I want to know: what type of server setup should I start migrating to? should I keep both parts of the site separate? eg; main site on one server, forums on another server(s)? what i've sorta been looking into is 3-server setup. (server1) main apache/php server. probably on unmetered (honestly don't think i'll find anything else that offers high enough traffic). run the main site and the vB php from here (server2) dedicated mysql 'read only' server (server3) dedicated mysql 'write only' server. and have mysql read/write synced and have all 3 servers networked directly together. i have a friend running a single mysql driven site using this setup and it works really well for him. is this overkill for me? should the current dual Opteron be able to handle the forums and i just need to hire someone smarter, or is there some other setup that would work better for me? i'm tight so i want to go cheap as possible, but I also realize i need room for summer traffic expansion that always hits us.
View Replies!
View Related
Apache Won't Start And MYSQL Optimization Server Experts
Can anyone recommend a Apached and MYSQL optimization expert? I just some optimization done on mysql and apache upgraded... but pache wouldn't restart with the following entries: MinSpareThreads 25 MaxSpareThreads 35 ThreadsPerChild 25 if i remove above then it starts... but my CPU spikes and I am getting a ton of errors emailed to me: Invalid SQL: SELECT COUNT(DISTINCT(userid)) AS count FROM vb_session WHERE vb_session.userid>0 AND vb_session.lastactivity>1245294346; MySQL Error : Out of memory (Needed 8388580 bytes) Error Number : 5 Request Date : Wednesday, June 17th 2009 @ 09:39:06 PM Error Date : Wednesday, June 17th 2009 @ 09:39:06 PM Its constantly complaining about this same query and i thought i removed all of the vbulletin options... i am pulling my hair out... cuz my server isn't swapping, ther are 0ver 8GBs in cache.... but my CPU goes up Here is original problem thread... [url] 2nd post has recommended config... and my subsequent probs
View Replies!
View Related
Apache + MYSQL Optimization For High End Server
I have a fairly high end server in which I have installed SIM. SIM is restarting Apache up to 10 times a day, presumably due to high load causing un-availability. On restart, Apache / MYSQL is stable until the load / mem usage begins to climb then it is restarted again. Here are my 'load' stats for today: Load for today High (2:18am): 4.63 Low (3:30am): 1.20 Mean: 1.84 Latest: 1.61 Mem usage for today High (1:36am): 9,192.9 MB Low (1:48am): 7,995.7 MB Mean: 8,683.1 MB Latest: 8,781.7 MB I have seen it using 20GB RAM before. I have tried to follow various optimisation guides but these seem tailored to less powerful servers. The web application I run on this server is almost entirely MYSQL based, with thousands of DB calls a day. Across the entire system I probably get 200,000 bot hits per day or even more. At peak times search engine bots are literally hammering the server. My server specs are: # Processor: Quad-Core Xeon Processor * 8 # CPU Speed: 3Ghz # RAM: 32 GB DDR2 # HDD: 36 GB 15k Raptor X2 + 1TB Sata # OS: 32Bit CentOS Changes / optimisation of the actual application is not possible. My configuration files are: My.cnf ....
View Replies!
View Related
MAMP (Apache, MySQL & PHP For Mac)
I was disappointed to discover how difficult it is to set up PHP, MySQL and virtual hosts on my MacBook Pro. I finally hired a computer science student to do it for me - but even he screwed it up. Then I discovered a preconfigured packaged called MAMP. I downloaded the free version and now have Apache, PHP, MySQL and phpMyAdmin up and running. That still leaves the biggest obstacle of all - creating virtual hosts. I checked out the MAMP Pro version ($50) at [url]and read "You can set up many virtual hosts." That doesn't make sense to me; shouldn't you be able to set up many virtual hosts even with the free version of MAMP? Or does MAMP somehow make it EASIER to create virtual hosts, and the Pro version simply allows you to make many of these simplified virtual hosts? If MAMP Pro does indeed make it easy to create virtual hosts, then I'll purchase it immediately. I'd be interested in other comments about MAMP. Unfortunately, its support forums are awfully lame; that's why I decided to post my questions here.
View Replies!
View Related
Load Balanced Servers Or Seperate Apache/MySQL
I currently have one server a Dual Xeon 5130 2GHZ (woodcrest) 2GB Ram. Running cPanel/WHM Now I run a website that is VERY PHP & MySQL Intensive and MySQL is ALWAYS the top of the process list, hogging a ton of usage. It's getting to the point where the site is needed a second server and I know there's a few options; but I'm not sure which one would be the best. They way I see it my two options are getting a 2nd server and setting up the two to do load balancing, or getting a 2nd server and setting one up for just Apache and the Other for MySQL and using the 2nd as a remote SQL server. If I do the Apache on a seperate server would I need such a powerful server? And if I also would want to upgrade this server along with getting a 2nd server would I be better of upgrading to 4GB of RAM or upgrading the processors?
View Replies!
View Related
Configuring MySQL/Apache To Run A Larger Website More Efficiently
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 Replies!
View Related
What Makes Server Cpu's Superior To Desktop Cpu's- Woodcrest Vs Conroe, Etc
wondering in general and specifically for woodcrest vs conroe and kentsfield vs clovertown I can't find either a) an explanation as to why the server cpu's are superior to the desktop equivilents or b) benchmarks comparing them. even mainstream hardware sites like tomshardware has benchmarks for server hdd's, but not server cpu's for some reason. apart from the ability to use dual cpu's in a single machine, what is the advantage? what warrants the price difference? are there benchmarks available anywhere to compare comparable models? (example, woodcrest xeon 5150 2.66ghz vs conroe c2d e6700 2.66ghz)
View Replies!
View Related
|
TRACKER
