Jump to content

Load times really slow - Please Review


jokerfool

Recommended Posts

I am running a dating site with 100k users and the load time of my users is about 5 secs.

 

Specs:

 

90 GB Storage 1.5 TB Monthly Transfer 2 GB Guaranteed RAM 4 GB Burst RAM
Full Specs
Hardware RAID 10 CentOS 5 or 6, 32 or 64-bit 4 IP Addresses Incredibly fast disk I/O

 

 Intel(R) Xeon(R) CPU L5320 @ 1.86GHz

    Speed
        627.305 MHz

    Cache
        4096 KB
8 cpus on hostmachine

 

This is my config file, can someone have a look at it and see if there are any changes I can make that will speed up the loads times, thank you.

 

[mysqld]

log-slow-queries = /var/lib/mysql/vps-slow.log
log-queries-not-using-indexes
long_query_time = 5
expire_logs_days=10
max_binlog_size=100M
safe-show-database
local-infile = 0

skip-networking
skip-innodb

query_cache_limit=8M
query_cache_size=256M
query_cache_type=1
# Reduced to 180 as memory will not be enough for 500 connections.
max_connections=125
max_user_connections=125
# interactive_timeout=100
interactive_timeout=30
# Reduced wait_timeout to prevent idle clients holding connections
# wait_timeout=100
wait_timeout=30
connect_timeout=10
thread_stack=128K
thread_cache_size=128
myisam-recover=BACKUP
#key_buffer_size - 64M for 1GB, 128M for 2GB, 256 for 4GB
key_buffer_size=64M
#join_buffer_size - 1M for 1GB, 2M for 2GB, 4M for 4GB
join_buffer_size=8M
max_allowed_packet=32M
table_cache=2048
table_definition_cache=2048
#sort_buffer_size - 1M for 1GB, 2M for 2GB, 4M for 4GB
sort_buffer_size=4M
#read_buffer_size - 1M for 1GB, 2M for 2GB, 4M for 4GB
read_buffer_size=4M
#read_rnd_buffer_size - 768K for 1GB, 1536K for 2GB, 3072K for 4GB
read_rnd_buffer_size=2M
max_connect_errors=10
#myisam_sort_buffer_size - 32M for 1GB, 64M for 2GB, 128 for 4GB
myisam_sort_buffer_size=64M

concurrent_insert=2
low_priority_updates=1

[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition

[isamchk]
#key_buffer - 64M for 1GB, 128M for 2GB, 256M for 4GB
key_buffer=128M
#sort_buffer - 64M for 1GB, 128M for 2GB, 256M for 4GB
sort_buffer=128M
#read_buffer - 16M for 1GB, 32M for 2GB, 64M for 4GB
read_buffer=32M
#write_buffer - 16M for 1GB, 32M for 2GB, 64M for 4GB
write_buffer=32M

[myisamchk]
#key_buffer - 64M for 1GB, 128M for 2GB, 256M for 4GB
key_buffer=128M
#sort_buffer - 64M for 1GB, 128M for 2GB, 256M for 4GB
sort_buffer=128M
#read_buffer - 16M for 1GB, 32M for 2GB, 64M for 4GB
read_buffer=32M
#write_buffer - 16M for 1GB, 32M for 2GB, 64M for 4GB
write_buffer=32M

[mysqlhotcopy]
interactive-timeout

Link to comment
Share on other sites

Can you be a bit more specific on what I need to do, I am not good at programming in mysql so anything you ask, please give me a quick description on what you need me to do and I can certainly go from there. Thanks for the reply.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.