Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: 1 [2]
16
Information / Re: Web site is going down at 300 visits - i have strong server.
« on: October 09, 2016, 10:58:55 AM »
Memcashe can help you but try to optimize it for dynamic content.
Also can you give us the output of the file my.cnf
in terminal type : cat /etc/my.cnf
As default you will have something like this :
My recommendation is that you install mysqltuner :
yum install mysqltuner
and when you run it (just type mysqltuner in terminal) you will get something like this:
so we edit /etc/my.cnf and add query_cache_size like this under mysqld section:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
query_cache_size = 128M
restart mysqld with command: service mysqld restart
Also can you give us the output of the file my.cnf
in terminal type : cat /etc/my.cnf
As default you will have something like this :
Code: [Select]
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pidMy recommendation is that you install mysqltuner :
yum install mysqltuner
and when you run it (just type mysqltuner in terminal) you will get something like this:
Code: [Select]
>> MySQLTuner 1.1.1 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.73
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 2K (Tables: 19)
[--] Data in InnoDB tables: 224K (Tables: 14)
[!!] Total fragmented tables: 14
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 15d 17h 44m 2s (153K q [0.113 qps], 66K conn, TX: 9M, RX: 8M)
[--] Reads / Writes: 99% / 1%
[--] Total buffers: 34.0M global + 2.7M per thread (151 max threads)
[OK] Maximum possible memory usage: 449.2M (23% of installed RAM)
[OK] Slow queries: 0% (0/153K)
[OK] Highest usage of available connections: 5% (8/151)
[OK] Key buffer size / total MyISAM indexes: 8.0M/122.0K
[!!] Key buffer hit rate: 75.0% (20 cached / 5 reads)
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 120 sorts)
[!!] Temporary tables created on disk: 36% (1K on disk / 3K total)
[!!] Thread cache is disabled
[!!] Table cache hit rate: 11% (64 open / 552 opened)
[OK] Open file limit used: 5% (55/1K)
[OK] Table locks acquired immediately: 100% (14K immediate / 14K locks)
[OK] InnoDB data size / buffer pool: 224.0K/8.0M
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Enable the slow query log to troubleshoot bad queries
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Set thread_cache_size to 4 as a starting value
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
>> MySQLTuner 1.1.1 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.73
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 2K (Tables: 19)
[--] Data in InnoDB tables: 224K (Tables: 14)
[!!] Total fragmented tables: 14
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 15d 17h 44m 2s (153K q [0.113 qps], 66K conn, TX: 9M, RX: 8M)
[--] Reads / Writes: 99% / 1%
[--] Total buffers: 34.0M global + 2.7M per thread (151 max threads)
[OK] Maximum possible memory usage: 449.2M (23% of installed RAM)
[OK] Slow queries: 0% (0/153K)
[OK] Highest usage of available connections: 5% (8/151)
[OK] Key buffer size / total MyISAM indexes: 8.0M/122.0K
[!!] Key buffer hit rate: 75.0% (20 cached / 5 reads)
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 120 sorts)
[!!] Temporary tables created on disk: 36% (1K on disk / 3K total)
[!!] Thread cache is disabled
[!!] Table cache hit rate: 11% (64 open / 552 opened)
[OK] Open file limit used: 5% (55/1K)
[OK] Table locks acquired immediately: 100% (14K immediate / 14K locks)
[OK] InnoDB data size / buffer pool: 224.0K/8.0M
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Enable the slow query log to troubleshoot bad queries
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Set thread_cache_size to 4 as a starting value
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
query_cache_size (>= 8M)
tmp_table_size (> 16M)
max_heap_table_size (> 16M)
thread_cache_size (start at 4)
table_cache (> 64) (>= 8M)
tmp_table_size (> 16M)
max_heap_table_size (> 16M)
thread_cache_size (start at 4)
table_cache (> 64)As you can see its recommendation is to change query_cacshe_size : so we edit /etc/my.cnf and add query_cache_size like this under mysqld section:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
query_cache_size = 128M
restart mysqld with command: service mysqld restart
17
Information / Re: Web site is going down at 300 visits - i have strong server.
« on: October 08, 2016, 09:03:00 AM »
Hi,
its very difficult to figure out whats wrong with just looking at the printcreen. I hope you have root access to the server. If so, please provide the output of those files:
/usr/local/apache/logs/
/var/log/suphp.log
/var/log/mysqld.log
also provide us the time when you had most load on the server so we can investigate.
On a side note, you can install htop so you can better view what process is using most of your resources:
as root type: yum install htop and when its finished you can type htop in the terminal to see how much memory and cpu you have at the moment, also you can see the top processes and how much memory/cpu are those using on the system. When you are done with viewing just press q and you will be dumped on the command line again.
Pozdrav
Bojan
its very difficult to figure out whats wrong with just looking at the printcreen. I hope you have root access to the server. If so, please provide the output of those files:
/usr/local/apache/logs/
/var/log/suphp.log
/var/log/mysqld.log
also provide us the time when you had most load on the server so we can investigate.
On a side note, you can install htop so you can better view what process is using most of your resources:
as root type: yum install htop and when its finished you can type htop in the terminal to see how much memory and cpu you have at the moment, also you can see the top processes and how much memory/cpu are those using on the system. When you are done with viewing just press q and you will be dumped on the command line again.
Pozdrav
Bojan
18
Migration from other control panels / Re: Email passwords
« on: June 01, 2016, 10:57:16 AM »
When you say that it will generate new passwords, does it mean that I will have to send new passwords to my clients?
Thanks
Thanks
19
Migration from other control panels / Email passwords
« on: June 01, 2016, 10:08:54 AM »
Hi all,
Just a quick question: will migrate script (cpanel to cwp) restore email account passwords?
thanks in advance
Just a quick question: will migrate script (cpanel to cwp) restore email account passwords?
thanks in advance
20
Information / Re: Which License used CWP?
« on: February 09, 2015, 12:04:26 PM »
Yes,
having this software free to use is really nice, it has many good features, the GUI is well designed ... everything you need to start hosting websites.
Its always good idea to know what kind of software you run on your server. For me personally it is a must. BSD has a nice licencing features since it allows you to incoroprate your code in closed source software:
ISPconfig that I use has BSD licence and their software is open source, not sure how well they do with donations but it seems they do ok.
having this software free to use is really nice, it has many good features, the GUI is well designed ... everything you need to start hosting websites.
Its always good idea to know what kind of software you run on your server. For me personally it is a must. BSD has a nice licencing features since it allows you to incoroprate your code in closed source software:
Quote
The BSD License allows proprietary use and allows the software released under the license to be incorporated into proprietary products. Works based on the material may be released under a proprietary license as closed source software.
ISPconfig that I use has BSD licence and their software is open source, not sure how well they do with donations but it seems they do ok.
21
Information / Re: Which License used CWP?
« on: January 21, 2015, 08:11:18 PM »
Any news about CWP licence? 
Pages: 1 [2]
