I'm having some performance issues on IIS with my PHP and MySQL applications. I'm also starting to see some errors.
One of my main apps is vBulletin. I've tried posting there for help, but not many people there have experience with IIS.
See this thread:
[url]
What is the best way to reduce the delay in DNS resolution for vistors to our hosted domains?
- Using multiple servers that spread across different geographic locations?
- Writing a script that contacts major DNS servers and queries our domains, so that they keep this
info in their cache?
I am considering to upgrade to MySQL 5.0. I am using 4.1 at present. Now I wonder if it will really improve performance... I really have some busy databases... Also wonder if 5.0 is fully downwards compatible to 4.1
View 2 Replies View RelatedI have a site that runs from a MySQL database. The database isn't big, it has only 16.1 MB on 17 tables with 103,978 records, and all are properly indexed.
My problem is that my MySQL has a particular problem with this database because I'll have to wait around 5-10 minutes to receive the query results.
I've tuned MySQL, I've tuned Apache and in the daily usage i have usually low Load Averages of 0.19 0.22 0.40. My server specs are Intel P4 at 3GHz with HT, 2Gb of RAM (in dual Chanel), 2 Hdd of 250Gb (backup) and 300Gb (main hdd), both with 16 mb cache. I'm running Debian 3.1 with 2.6 kernel and there is no swapping to disk as i had previous on the 2.4 kernel.
I will post my.conf below and maybe you'll give me a suggestion.
Code:
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "/var/lib/mysql/my.cnf" to set server-specific options or
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# [url]
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[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
#
# For compatibility to other Debian packages that still use
# libmysqlclient10 and libmysqlclient12.
old_passwords= 1
#
# 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
#
key_buffer= 32M
key_buffer_size= 32M
max_allowed_packet= 16M
myisam_sort_buffer_size = 32M
table_cache= 3072
sort_buffer_size= 4M
read_buffer_size= 4M
read_rnd_buffer_size= 4M
join_buffer_size= 2M
thread_stack= 512K
wait_timeout= 300
max_connection = 60
max_connect_errors= 10
thread_cache_size= 100
long_query_time= 2
max_user_connections= 50
interactive_timeout= 100
connect_timeout= 15
tmp_table_size= 64M
open_files_limit= 3072
max_heap_table_size = 64M
#
# * Query Cache Configuration
#
query_cache_limit= 2M
query_cache_size = 64M
query_cache_type = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log= /var/log/mysql.log
#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
log-queries-not-using-indexes = /var/log/mysql/mysql-index.log
# 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
# See /etc/mysql/debian-log-rotate.conf for the number of files kept.
max_binlog_size = 104857600
#binlog-do-db= include_database_name
#binlog-ignore-db= include_database_name
#
# * BerkeleyDB
#
# According to an MySQL employee the use of BerkeleyDB is now discouraged
# and support for it will probably cease in the next versions.
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!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# If you want to enable SSL support (recommended) read the manual or my
# HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt.gz
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
[mysqldump]
quick
quote-names
max_allowed_packet= 64M
[mysql]
#no-auto-rehash# faster start of mysql but no tab completition
[isamchk]
key_buffer= 32M
sort_buffer_size= 32M
read_buffer= 16M
write_buffer= 16M
[myisamchk]
key_buffer = 32M
sort_buffer_size = 32M
read_buffer = 16M
write_buffer = 16M
I thought that i might need to start rewriting my code in order to be able to fix things but i need at least another opinion from someone who knows more.
I have published 2 articles about MySQL benchmark results. They can be viewed here:
- super-smack: [url]
- sql-bench: [url]
If you have any results to compare, please let me know, either here or via comments.
question regarding hard disk performance.
Right now i have a busy running forum Running on a Single Xeon 5335 with 4GB of RAM,
single 73GB SCSI 15K. And the site seems running fine most of the time except at peak.
The load sometime goes up to 8 for about 1 hour. So i am looking to upgrade my server.
The next server i am thinking about is
Single C2Q 9300, 8GB of RAM, 1x750GB SATAII as primary drive for for webserver, 1x150GB Raptor 10K to serve MYSQL only.
I wonder if the HDD performance on my current server server with future server be the same of better? Since the future server has better CPU and RAM, the only thing i worry is the HDD performance.
So in short, Single SCSI 15K V.S Combination of SATA + RAPTOR. What do you guy think?
i am using Litespeed as webserver and i also will be using litespeed on future server.
I was wondering if there is a significant performance gain if you use PHP 5.25 and MySQL 5x instead PHP 4.47 and MySQL 4.22?
Let's say that the scripts to be used are all compatible to the said versions.
I've decided to give VPS a shot. So...
I'm runnning the same query on a 1 & 1 VPS, where the MySQL server is local, and on a 1 & 1 shared server (where the MySQL server is remote).
The MySQL version on the VPS machine is 4.1, while on the shared server it's 4.0.
The exact same query takes 20x longer (!) on the VPS.
I have the hatchling plan on HostGator. Is there a PHP and MySQL open-source application where I can put up there to test its performance on running PHP and MySql applications? I want to see if there is any performance issue on this host before migrating a large ZenCart app to it.
What are people's experience on HostGator running PHP and MySQL?
Which Is better and would give me better mysql Performance since mysql eats up huge amounts of CPU and RAM.
AMD 64Bit 3200 Or a Intel Core 2 Duo 1.86 GHz
I know theres many other factors involved but I need to know which processor would perform better with mysql.
I'm going to be rolling out a php/mysql driven site soon and I'm pretty much resigned to the fact that the mysql performance dreamhost has given me isn't going to cut it, its probably too oversold. Simple one table one column selects can take 30 seconds or time out depending on how badly the server is being hammered. HTTP requests are usually snappy, but the mysql performance is bogus.
What is a good host for me to launch this site with? Storage wouldn't need to be too terribly high, at least initially. I'm tempted by MediaTemple's slick marketing, but I've seen on here that some people have had poor sql performance (contrary to what some personal friends have experienced, so I'm torn). I was reading about downtownhost on here, but their load times seemed slow when I hit a couple domains listed on here that are hosted by them.
This host needs to be located in the US. Honestly, I like dreamhost and their panel, save for the sql sluggishness I'm getting.
During my poking around performance tips I found the DELAY_KEY_WRITE option (and innodb_flush_log_at_trx_commit = 0 for innodb)
which supposedly for mysql will disable the immediate disk flush for every transaction written and instead update only once every second at most?
One thing I've never had to restart on my vps is mysql, it's been great. So is this safe to turn on? Am I risking corruption? Will the performance gain be worth it with only a 16M cache?
I am using dreamhost host 3 of my web sites and 1 blog. Dreamhost is great, offers alot space and bandwidth.
but I think they are oversellling their space, sometimes it gets really slow. (overselling ? ok, I dont really know, but sometimes its really slow, and most my asian readers said need to refresh to load the page. I am wondering if theres a way to check if they are overselling or not.)
I am thinking about buying vps, even tho, I still got 5 month left with dreamhost.
I found 2 vps companies are highly recommanded on this forum, JaguarPC and LiquidWeb.
theres already a post compared both companies in terms of price and service. I say I will pick JagarPc, cuz, its basic plan just 20 USD, and htey got promotion now, its even cheaper. and basic Liquidweb vps plan is 60 bucks.
I am wondering why Jagarpc is so cheap , are they overselling? how can we check if they are overselling.
I found a few posts saying how good jaguarPc is. and they are not overselling, but those members just signed up this month, and only have 1-3 posts. I cannot really trust those new members.
Can someone share their experience with JaguarPC? compare JaguarPc performance and liquidweb performance. antoher question is switch from dreamhost to JaguarPC basic vPS plan, will performance gets better?
last question: VPS account allows 3 IP, 3ip = 3 domains? if not, how many domains can I have?
What can be disabled (Mail related) if the only domains on the server use google apps "gmail" for mail? I only really need roots mail. Anyone tried this yet, I figured I asked before I use trial and error.
antirelayd
exim
imap
pop
does anyone know of a google apps alternative seeing as google apps is no longer free.
View 4 Replies View RelatedI want to shift my mail to Google Apps (standard version). Currently my DNS is pointed towards 1and1 dedicated servers (having problems with 1and1 mail services). Want to keep hosting with them but change the Email to Google apps.
The Registrar of the domain is Netfirms, Inc.
My current Settings for nameservers in Nefirms CP are:
ns29.1and1.com
ns30.1and1.com
Google Instructed me to verify first by creating a CNAME, which I did in Netfirms control panel.
'googlexxxxx.mydomain.com' Pointing to 'google.com'
DONE.
Google gave me the MX records to enter in the Netfirms panel.
ASPMX.L.GOOGLE.COM
ALT1.ASPMX.L.GOOGLE.COM
DONE.
It's been more than 24 hours, neither MX updated not that CNAME lookup 'googlexxxxx.mydomain.com is propogating.
What I am supposed to do here? I am waiting here for last 24 hours. I think that I have to set up these settings with my registrar (Netfirms) rather than it has to do something with 1and1?
Any suggestions?
I'm using cpanel and google apps. I made mail in google apps mail@mydomain.com
I set up MX entries. When I sending mail from e.g. yahoo or hotmail to mail@mydomain.com I can receive it. But when I'm sending mail from php contact skript which is located at my site I cannot receive mail, like it doesn't exist. why?
attending to clients and their email inbox limits is occuring more frequently
i'd prefer to minimize this chore, especially now i have some clients using IMAP it means the server fills up rapidly.
google apps -just for handling email- seems attractive (6GB free) compared to increasing the monthly fee for extra server space which seems to be kind of expensive at my webhost.
i would actually prefer to keep using the Webmail interfaces offered on the servers but i dont think my clients will change their bad habits of filling up their inbox, and lets not forget the increasing levels of SPAM.
what are other people doing with email?
are many people outsourcing it to google?
i'd appreciate any other ideas or suggestions.
I was considering using Google Apps for domains, for my other domains but would like to hear people's opinions on it first.
Do you use/recommend Google Apps for domains?
Why do you use/recommend it, if you do? or Why do you not use/recommend it?
You use FCName for setting cnames in the dns info. for google apps like calender, docs etc., right!!! then how do you provide the ttl values.
View 2 Replies View Relatedi am trying to use a custom url (example: mail.mydomain.com) for my google apps e-mail.
i can't seem to figure out how to set up the CNAME in WHM to allow this to occur and google apps' help function is not well ...
Thought of sharing this with all.
Issue:
Php function was returning wrong time. There was a difference of 1 hour between the server time and the php time. Due to this ,most of the functions on the site were not working properly.
Fix :
For checking the php time, put the following code in a file, say time.php
Code:
<?php
$time = time();
$result = date(”Y-m-d (D) H:i:s”,$time);
echo “Current date and local time on server = $result “;
?>
Execute the php script.
Code:
[root@localhost ~]# php -a time.php
Interactive mode enabled
Current date and local time on server = 2017-01-30 (Mon) 18:04:25
To get the server time , issue the following command :
Code:
[root@localhost ~]# date
Mon Jan 30 17:04:25 IST 2017
You can see the difference of one hour between the server time and the php time.
For fixing this, you need to install the PECL timezonedb module.
Code:
[root@localhost ~]# pecl install timezonedb
At the end , you might see the following message :
==========================
Build process completed successfully
Installing ‘/usr/local/lib/php/extensions/no-debug-non-zts-20060613/timezonedb.s o’
install ok: channel://pecl.php.net/timezonedb-2009.6
configuration option “php_ini” is not set to php.ini location
You should add “extension=timezonedb.so” to php.ini
==========================
So , add the line ” extension=timezonedb.so” to the php.ini file and restart apache.
There shouldn’t be any mismatch in time now.
i just can't get this app to start up automatically.
i've put a script with execute permissions into my /etc/init.d/ folder, and ln'ed it to my rc.d/rc5 directory as S50myscript.
no go. and i don't even know where to look in the server logs to see what the issue is?
I currently got signed up with Hawkhost and I love the interface so far. I bought all my domain names through Name Cheap. I wanted to see what you guys thought would be the best set up...
I would like to use Google Apps to host my email and not hawkhost.
I have two options: I can have hawkhost host my DNS or NameCheap. Do you guys think it would be better to let Namecheap host my DNS and just point the www record to my website?
Just curious what your guys were on letting the webhost host the DNS and if there were any cons with that.
I'm sure hawkhost is reliable, but I just don't like putting all my eggs in one basket and would prefer to have Google host my email...
I have setup the DNS records for my domain, just need it confirming by someone.
Domain is registered using godaddy, so using their default nameservers and modified the records:
A Records:
Host Points To TTL
@ http_Serverip 1 Hour
ftp ftp_Serverip 1 Hour
www http_Serverip 1 Hour
* http_Serverip 1 Hour
cnames:
Host Points To TTL
www @ 1 hour
MX records:
Priority Host Goes To TTL
10 @ aspmx.l.google.com. 1 Week
20 @ alt1.aspmx.l.google.com. 1 Week
30 @ alt2.aspmx.l.google.com. 1 Week
40 @ aspmx2.googlemail.com. 1 Week
50 @ aspmx3.googlemail.com. 1 Week
Hope you can work out the above tables, I have website pointing to a server and mail pointing to google apps.
If I have set up google apps for domain, do I need any MTA/SMTP server running on my server?
View 3 Replies View RelatedOur company uses Google Apps for Domain (and we are very satisfied with it). Until recently, we were accessing our email via[url], but we then realized that it can be accessible via [url]by updating CNAME and MX records for our DNS zone. We have full access to WHM and cPanel.
However, what we are trying to accomplish, if possible, that, when someone types [url], it does NOT redirect him/her to [url], but it remains on that very domain. For example, the address for GMail inbox in that case would be [url]
I have a question regarding Google Apps when it comes to my email login. (Have searched extensively on Google App's support, but to no avail)
I have created the email address kim @ kimstewart.ca through Google Apps and have set my MX records through HostGator. Propagation looks to now be complete and my emails are sending and I am able to receive. However, when I access my emails through the Google Apps dashboard, it takes me to this rather long and convoluted URL:
[url]
I was hoping to just be able to log into www.gmail.com and enter my email/password to be able to login. It this not possible? Or do I need to do some more tinkering from Google Apps in order to make this work? (I also have an iGoogle account I would like transfered over to my Google Apps email.)
mod_evasive bans some of the legit users (galleries , typo3 etc.) with following settings:
<IfModule mod_dosevasive20.c>
DOSHashTableSize 3097
DOSPageCount 10
DOSSiteCount 150
DOSPageInterval 1
DOSSiteInterval 3
DOSBlockingPeriod 10
</IfModule>
Somebody have an idea for some less restrictive but still usefull rules?
If I am using Google Apps for Domain, how can I send mail from my physical server (like from scripts)?
View 6 Replies View RelatedNot sure if it's the best forum to ask this, but it's related to hosting.
I have a Windows hosting for our business and send a newsletter twice a week to almost 10,000 subscribers through the hosting mail server.
I'd like to move to google apps so we can use the gmail interface. The problem is that I see Google apps has some limitations for sending mails (500 per user per day if I understood right, no matter if it's free or premier account).
Does anyone send a newsletter through Google apps? What can I do?