zir4k

Registered
Jun 19, 2017
2
0
1
Mashhad
cPanel Access Level
Root Administrator
Hi, i have a virtual server with this informations:
Code:
Processor Information
Total processors: 4

Processor #1

    Vendor
        GenuineIntel

    Name
        Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz

    Speed
        2098.983 MHz

    Cache
        20480 KB

Processor #2

    Vendor
        GenuineIntel

    Name
        Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz

    Speed
        2098.983 MHz

    Cache
        20480 KB

Processor #3

    Vendor
        GenuineIntel

    Name
        Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz

    Speed
        2098.983 MHz

    Cache
        20480 KB

Processor #4

    Vendor
        GenuineIntel

    Name
        Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz

    Speed
        2098.983 MHz

    Cache
        20480 KB
And This Memory Usage
Code:
Current Memory Usage

              total        used        free      shared  buff/cache   available
Mem:        4914228     2197908      206216      762836     2510104     1638356
Swap:       5017596        7980     5009616
Total:      9931824     2205888     5215832
i use from mariadb and have 4 Core CPU And 4GB Memory,Most of the times my avaible memory is to low and i have crash and should be restart my server.
There Is MY.CNF
Code:
[mysqld]
innodb_file_per_table=1
default-storage-engine=MyISAM
performance-schema=0
innodb_buffer_pool_size=90177536
max_allowed_packet=268435456
open_files_limit=10000
i want a best config for this information and help to optimize my server. thanks
for check my sites speed goto this url - Removed -
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,226
463
Hello,

Advice about tuning specific configuration values typically requires the help of a qualified system administrator. I'll leave this thread open for additional user-feedback, but I did want to note the "mysqladmin processlist" command is helpful if you are noticing bad MySQL performance. The command can help determine if any specific databases are responsible for the poor performance.

You can also find a list of companies offering system administration services if you do not receive sufficient user-feedback to this thread:

System Administration Services | cPanel Forums

Thank you.