Server Configuration Help

@serveion
9 years ago
223 posts

hello i have install jamroom on my server, i have cpanel as a control panel

- Server Info -

Server CPU:
Server RAM: 29.3GB

- Performance Results -

Processor: 1.87
Database: 78.44
Filesystem: 2.33
Total Score: 97

is a vps uses 8 cpu 30 gb of ram 1.8 sshd HHD

there is anything the i need to configure in server side to give priority to make jamroom run faster?

the more i config jamroom the slower it gets

nothing else is installed on the server just jamroom.

I found this looking around the website.

https://www.jamroom.net/brian/documentation/guides

updated by @serveion: 04/27/16 03:33:27AM

@serveion
9 years ago
223 posts

Hello

Router Is using to much resources how can everything is a fresh install

Time: Fri Jan 22 17:28:09 2016 +0300
Account: devteam
Resource: Virtual Memory Size
Exceeded: 257 > 200 (MB)
Executable: /usr/bin/php
Command Line: /usr/bin/php /home/devteam/public_html/modules/jrCore/router.php
PID: 31317 (Parent PID:23731)
Killed: No

updated by @serveion: 01/22/16 08:21:15PM

@brian
9 years ago
10,148 posts

Your database performance is killing you, but the server load is very low for 8 processors (.53 means 1/2 of 1 CPU is being used). "router.php" will always show as the top process for JR, since almost every request into JR goes through it, so it is the "parent" script for everything.

By my guess I would say your cpanel is running some sort of accounting software on your MySQL server, and is throttling your DB access - your processor and filesystem scores are acceptable, but your DB score is very, very low.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@serveion
9 years ago
223 posts

Processor: 1.77
Database: 30.55
Filesystem: 2.17
Total Score: 97

I have make some changes to the my.cnf i seems to lower the mysql time to half i will try to figure out what else i can do to make this better, right now the page double the speed loading time i will try when i have a lot of data on the site.

thank you for the url and documentation you provide help me to reduce the mysql time.

Strumelia
@strumelia
9 years ago
3,603 posts

I had horribly low database scores when I was building my site (not even live yet, almost no activity, and my site was only 32GB of content...not that big) and had it on an Arvixe shared server. It used to take a whole 60 seconds or more just to click from one page to another. =8-(
Arvixe kept blaming stuff on my end instead of helping, telling me to optimize my images, telling me I was using too many resources, etc. It was impossible.
Simply moving my site to a Jamroom server solved all these issues right away for me, and it's been great and fast ever since. (Just my own experience, but you might consider that option.)
Here are my current scores on JR server:

--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

Strumelia
@strumelia
9 years ago
3,603 posts

....here were my old DB scores while my site was on the shared Arvixe server:

--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

@brian
9 years ago
10,148 posts

serveion:
thank you for the url and documentation you provide help me to reduce the mysql time.

Here's the mysqld section for a 1GB RAM JR server:

key_buffer              = 64M
max_allowed_packet      = 32M
table_cache             = 1536
table_definition_cache  = 1536
open_files_limit        = 10240
tmp_table_size          = 64M
max_heap_table_size     = 64M
sort_buffer_size        = 1M
read_buffer_size        = 1M
read_rnd_buffer_size    = 768K
max_connections         = 50
innodb_buffer_pool_size = 128M
innodb_flush_method     = O_DIRECT
innodb_flush_log_at_trx_commit = 0
ft_min_word_len         = 3
ft_stopword_file        = ""

I would consider that the minimum MySQL config for any decent performance.

Hope this helps!

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
updated by @brian: 01/26/16 04:19:46PM

@serveion
9 years ago
223 posts

hello

@brian
sorry took me a while to respond i was testing the server with different configuration with your settings i got my server to 700 i did modify some stuff a bit now this is my performance this is with a SSHD
i need to figure it out how to make it better for my server specs 8 cores, and 29gb I will continue testing. am sure then when i change the server HHD to SSD will make thing a lot faster but for now the server is running faster,

Thank you very much.

Server Info:

Server CPU:
Server RAM: 29.3GB

Performance Results:

Processor: 1.72
Database: 6.1
Filesystem: 1.87
Total Score: 826

[mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
key_buffer_size         = 10G
max_allowed_packet      = 32M
table_cache             = 1536
table_definition_cache  = 1536
open_files_limit        = 50240
tmp_table_size          = 200M
max_heap_table_size     = 200M
sort_buffer_size        = 1M
read_buffer_size        = 1M
read_rnd_buffer_size    = 1M
max_connections         = 200
innodb_buffer_pool_size = 128M
innodb_flush_method     = O_DIRECT
innodb_flush_log_at_trx_commit = 0
ft_min_word_len         = 3
ft_stopword_file        =

I change key_buffer to key_buffer_size i think key_buffer is deprecated(not 100% Sure)
http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_key_buffer_size
updated by @serveion: 01/27/16 02:54:26AM

@serveion
9 years ago
223 posts

@strumelia
am not running my website in shared hosting, I got a 1U server, with 8 cores and 72 gb ram, is in a data center in texas,
this works for me because i can create virtual machines, and test different stuff without incrementing my budget,
but am running cpanel on the server so configuring the server to run jamroom to the best speed possible is a bit time consuming. i want to have everything well configure.
when the server is fully configured i can make a backup and run similar installation in other dedicated server in case i need to expand my server with the cloud module etc. thinking ahead, am doing that right now because the server everything is fresh installed, i will try to bring the Total Score to 1200 at least.
updated by @serveion: 01/27/16 02:53:15AM

Strumelia
@strumelia
9 years ago
3,603 posts

Yes I understand- thanks!

--
...just another satisfied Jamroom customer.
Migrated from Ning to Jamroom June 2015

@brian
9 years ago
10,148 posts

That's way too much for the key_buffer - key_buffer is only used by MyISAM tables - JR uses InnoDB for the majority of the large tables - try this:

[mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
key_buffer_size         = 512M
max_allowed_packet      = 64M
table_cache             = 1536
table_definition_cache  = 1536
open_files_limit        = 50240
tmp_table_size          = 512M
max_heap_table_size     = 256M
sort_buffer_size        = 4M
read_buffer_size        = 4M
read_rnd_buffer_size    = 1M
max_connections         = 200
innodb_buffer_pool_size = 8G
innodb_flush_method     = O_DIRECT
innodb_flush_log_at_trx_commit = 0
ft_min_word_len         = 3
ft_stopword_file        =

50240 is VERY large for the open_files_limit - unless you are running hundreds of databases with hundreds of tables each, that can be lowered.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@serveion
9 years ago
223 posts

Hello

50240 is VERY large for the open_files_limit - unless you are running hundreds of databases with hundreds of tables each, that can be lowered.

yes I lower that a bit that number was set by cpanel when i first install it, am running 4 websites in here, so you right, i have fixed that.

I try your configuration and i think i have reach the maximum on this vps, I will try later with ssd harddrive, and see if that improve anything,

thank you so much for your help.

Server Configuration Help

Tags