• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Website Still Slow

silence

Well-known member
#1
I have spent weeks configuring it and I can't simply get it fast enough.
Here is my specs:

Nginx 1.3.15
PHP-FPM 5.4.13

MariaDB running on a SSD with this my.cnf:

Code:
[mysql]
 
# CLIENT #
port                          = 3306
socket                        = /var/lib/mysql/mysql.sock
 
[mysqld]
 
# GENERAL #
user                          = mysql
default_storage_engine        = MyISAM
socket                        = /var/lib/mysql/mysql.sock
pid_file                      = /var/lib/mysql/mysql.pid
bind-address                  = jeebus
skip-name-resolve
 
# MyISAM #
key_buffer_size                = 976M
myisam_recover                = FORCE,BACKUP
 
# SAFETY #
max_allowed_packet            = 16M
max_connect_errors            = 1000000
 
# DATA STORAGE #
datadir                        = /var/lib/mysql/
 
# BINARY LOGGING #
log_bin                        = /var/lib/mysql/mysql-bin
expire_logs_days              = 14
sync_binlog                    = 1
 
# CACHES AND LIMITS #
tmp_table_size                = 32M
max_heap_table_size            = 32M
query_cache_type              = 0
query_cache_size              = 0
max_connections                = 500
thread_cache_size              = 50
open_files_limit              = 65535
table_definition_cache        = 4096
table_open_cache              = 4096
 
# INNODB #
innodb_flush_method            = O_DIRECT
innodb_log_files_in_group      = 2
innodb_log_file_size          = 32M
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table          = 1
innodb_buffer_pool_size        = 8M
 
# LOGGING #
log_error                      = /var/lib/mysql/mysql-error.log
log_queries_not_using_indexes  = 1
slow_query_log                = 1
slow_query_log_file            = /var/lib/mysql/mysql-slow.log
Also php save session is running on memcached server, nginx cache going to a ramdisk.

VPS Info:
3 cores of a Intel(R) Xeon(R) CPU E5-2690 0 @ 2.90GHz
3 gigs ram
300gb hdd
16 gb ssd
I can't get it to resolve very fast, even though I'm using google's dns for resolving :(
What can I do?
 

WSWD

Well-known member
#4
Not seeing any delay or slowness here at all in Southern California. Everything loads almost immediately. Tried using 3 different Internet connections, and remote desktop on a server. You sure it's your server and not your Internet connection causing the issues?

The second place I would look is CloudFlare. People experience slowdowns with CF all the time.
 

WSWD

Well-known member
#7
Yes but the only reason I'm using CloudFlare is since I can use unlimited SSl tickets for like 20 a month.
If you aren't willing to at least try it, you're not going to know if that is the cause or not. You should also be able to access the website by bypassing Cloud Flare, to test it.
 

silence

Well-known member
#8
Do you know of any other service that offers ssl certificates without me having to buy 2 wildcard ones D:

And I'll attempt disabling later :)