Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #21  
Old 13th October 2010, 18:38
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

Honestly I only skimmed through the utils site. But, I will look into setting up a web interface when I have time to find the destructions on what to do.

It's pointless to use SSH in my opinion...more of a pain to watch.
__________________
ISPC3 on Debian! It's great!
Reply With Quote
Sponsored Links
  #22  
Old 13th October 2010, 18:59
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,794
Thanks: 840
Thanked 5,612 Times in 4,423 Posts
Default

Which wordpress caching plugin do you use?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #23  
Old 13th October 2010, 21:06
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

Till, I am using W3 Total Cache.

Mark, any recommendations on a page outlining installing/setting up collectl output to a website? Not seeing it...
__________________
ISPC3 on Debian! It's great!

Last edited by crypted; 13th October 2010 at 22:27.
Reply With Quote
  #24  
Old 13th October 2010, 22:30
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

Here's the latest from tuning-primer.sh for Mysql:

Code:
SLOW QUERIES
The slow query log is enabled.
Current long_query_time = 10 sec.
You have 14077 out of 16432161 that take longer than 10 sec. to complete
Your long_query_time seems to be fine

BINARY UPDATE LOG
The binary update log is NOT enabled.
You will not be able to do point in time recovery
See http://dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html

WORKER THREADS
Current thread_cache_size = 8
Current threads_cached = 7
Current threads_per_sec = 0
Historic threads_per_sec = 0
Your thread_cache_size is fine

MAX CONNECTIONS
Current max_connections = 200
Current threads_connected = 4
Historic max_used_connections = 72
The number of used connections is 36% of the configured maximum.
Your max_connections variable seems to be fine.

INNODB STATUS
Current InnoDB index space = 64 K
Current InnoDB data space = 64 K
Current InnoDB buffer pool free = 95 %
Current innodb_buffer_pool_size = 8 M
Depending on how much space your innodb indexes take up it may be safe
to increase this value to up to 2 / 3 of total system memory

MEMORY USAGE
Max Memory Ever Allocated : 381 M
Configured Max Per-thread Buffers : 899 M
Configured Max Global Buffers : 58 M
Configured Max Memory Limit : 957 M
Physical Memory : 3.87 G
Max memory limit seem to be within acceptable norms

KEY BUFFER
Current MyISAM index space = 131 M
Current key_buffer_size = 16 M
Key cache miss rate is 1 : 1381
Key buffer free ratio = 0 %
You could increase key_buffer_size
It is safe to raise this up to 1/4 of total system memory;
assuming this is a dedicated database server.

QUERY CACHE
Query cache is enabled
Current query_cache_size = 32 M
Current query_cache_used = 28 M
Current query_cache_limit = 2 M
Current Query cache Memory fill ratio = 88.43 %
Current query_cache_min_res_unit = 4 K
However, 101653 queries have been removed from the query cache due to lack of memory
Perhaps you should raise query_cache_size
MySQL won't cache query results that are larger than query_cache_limit in size

SORT OPERATIONS
Current sort_buffer_size = 2 M
Current read_rnd_buffer_size = 256 K
Sort buffer seems to be fine

JOINS
Current join_buffer_size = 2.00 M
You have had 6 queries where a join could not use an index properly
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
If you are unable to optimize your queries you may want to increase your
join_buffer_size to accommodate larger joins in one pass.

Note! This script will still suggest raising the join_buffer_size when
ANY joins not using indexes are found.

OPEN FILES LIMIT
Current open_files_limit = 1210 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine

TABLE CACHE
Current table_cache value = 500 tables
You have a total of 391 tables
You have 452 open tables.
The table_cache value seems to be fine

TEMP TABLES
Current max_heap_table_size = 80 M
Current tmp_table_size = 80 M
Of 49835 temp tables, 39% were created on disk
Perhaps you should increase your tmp_table_size and/or max_heap_table_size
to reduce the number of disk-based temporary tables
Note! BLOB and TEXT columns are not allow in memory tables.
If you are using these columns raising these values might not impact your 
ratio of on disk temp tables.

TABLE SCANS
Current read_buffer_size = 128 K
Current table scan ratio = 1207 : 1
read_buffer_size seems to be fine

TABLE LOCKING
Current Lock Wait ratio = 1 : 1884
You may benefit from selective use of InnoDB.
__________________
ISPC3 on Debian! It's great!
Reply With Quote
  #25  
Old 14th October 2010, 07:55
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

Mark, my LOAD AVG was at 3.56 when I looked at TOP randomly. Started Collectl. Here's the output below up until the load avg was down to 1.10.

Code:
#         <--------CPU--------><-----------Memory-----------><----------Disks-----------><----------Network---------->
#Time     cpu sys inter  ctxsw Free Buff Cach Inac Slab  Map KBRead  Reads KBWrit Writes   KBIn  PktIn  KBOut  PktOut 
00:53:40   33  16    61   1138 162M 669M   1G   1G 129M   2G      0      0      0      0      0      6      0       4 
00:53:41   36   9    95    587 162M 669M   1G   1G 129M   2G     60      4      0      0      3     38     20      39 
00:53:42   44  21    52   1487 164M 669M   1G   1G 129M   2G      4      1   3760     29      4     49      4      46 
00:53:43    0   0    14     72 164M 669M   1G   1G 129M   2G      0      0      0      0      1      7      2       6 
00:53:44   25   8    22     94 164M 669M   1G   1G 129M   2G      0      0      0      0      1     10      5       8 
00:53:45   81  36    67    911 164M 669M   1G   1G 129M   2G      0      0   3228     18      2     16      1       9 
00:53:46   39  22    34   1319 164M 669M   1G   1G 129M   2G      0      0     52      8      4     30      4      25 
00:53:47    0   0    30     74 164M 669M   1G   1G 129M   2G      0      0      0      0      2     18      7      23 
00:53:48    2   1     5     61 306M 669M   1G   1G 129M   2G      0      0      0      0      1      9      1       7 
00:53:49    0   0    23     76 306M 669M   1G   1G 129M   2G      0      0      0      0      0      5      0       1 
00:53:50    0   0    20     88 306M 669M   1G   1G 129M   2G      0      0      0      0      2     20      2      18 
00:53:51   19   1    55    169 306M 669M   1G   1G 128M   2G     12      3    216      9      1      7      0       3 
00:53:52   50  30    39     61 306M 669M   1G   1G 128M   2G      8      2      0      0      3     44     35      42 
00:53:53    5   1    77    178 306M 669M   1G   1G 128M   2G      0      0      0      0      1     19     12      16 
00:53:54    1   0    27     72 306M 669M   1G   1G 128M   2G      0      0      0      0      3     46      3      35 
00:53:55   50   3    24    175 306M 669M   1G   1G 128M   2G      0      0      0      0      1     15      5       9 
00:53:56    3   0   147    233 306M 669M   1G   1G 128M   2G     56      4      0      0      2     30     27      31 
00:53:57    1   0    86    104 307M 669M   1G   1G 128M   2G      4      1   3452     22      6     75     82      93 
00:53:58   11   0    35    104 306M 669M   1G   1G 128M   2G      0      0    104     12      4     40      9      32 
00:53:59   50  28    88    200 306M 669M   1G   1G 128M   2G      0      0      0      0      2     14      1       6 
00:54:00   33   8    36    196 306M 669M   1G   1G 128M   2G      4      1      0      0      4     47      5      45 
00:54:01   50  15    10    962 306M 669M   1G   1G 128M   2G      0      0      0      0      2     16      6      13 
#         <--------CPU--------><-----------Memory-----------><----------Disks-----------><----------Network---------->
#Time     cpu sys inter  ctxsw Free Buff Cach Inac Slab  Map KBRead  Reads KBWrit Writes   KBIn  PktIn  KBOut  PktOut 
00:54:02   36  18    98   1210 306M 669M   1G   1G 128M   2G      0      0      0      0      1     12      1       7 
00:54:03    0   0    42     99 306M 669M   1G   1G 128M   2G      0      0   3672     17      5     63     41      61 
00:54:04    0   0    31     72 306M 669M   1G   1G 128M   2G      0      0      0      0      1     15      6      17 
00:54:05   42   4    66    244 289M 669M   1G   1G 128M   2G      0      0      0      0      2     21      1       9 
00:54:06   64  21    42    140 305M 669M   1G   1G 128M   2G      0      0      0      0      4     44      3      37 
00:54:07   17   9    38     76 306M 669M   1G   1G 128M   2G      0      0     24      5      2     20      9      16 
00:54:08    3   0    45    101 306M 669M   1G   1G 128M   2G      0      0   3352     21      2     21      2      15 
00:54:09   50  19    22   1335 306M 669M   1G   1G 128M   2G      0      0    112      6      2     12      2      11 
00:54:10   17  10     7    590 306M 669M   1G   1G 128M   2G      0      0      0      0      1      8      2       6 
00:54:11   13   1    23     90 306M 669M   1G   1G 128M   2G      0      0      0      0      0      3      1       3 
00:54:12    1   0   251     92 306M 669M   1G   1G 128M   2G      4      1   3668    230      2     17      2      17 
00:54:13    1   0   151    169 306M 669M   1G   1G 128M   2G      0      0    492     61      3     39     47      50 
00:54:14    0   0    32     94 306M 669M   1G   1G 128M   2G      0      0    220      7      2     29      2      22 
00:54:15    1   0    44     88 306M 669M   1G   1G 128M   2G      0      0      0      0      1     14      1      12 
00:54:16    0   0    78    190 306M 669M   1G   1G 128M   2G      0      0      0      0      3     34      9      37 
00:54:17    0   0    37     80 306M 669M   1G   1G 128M   2G      0      0      0      0      3     37      3      36 
00:54:18    0   0    38     97 307M 669M   1G   1G 128M   2G      0      0      0      0      2     28      2      28 
00:54:19    1   0   162    235 306M 669M   1G   1G 128M   2G      4      1    144     10      3     30     11      25 
00:54:20   39  15    99    112 306M 669M   1G   1G 128M   2G      0      0     88      8      7     83    146     142 
00:54:21   67  27   125    153 306M 669M   1G   1G 128M   2G    176      2      0      0      5     75    316     225 
00:54:22   41  23   120     87 306M 669M   1G   1G 128M   2G      0      0     32      2      5     51    168     129 
00:54:23    0   0   105    109 306M 669M   1G   1G 128M   2G      0      0      0      0      7     90    254     187 
#         <--------CPU--------><-----------Memory-----------><----------Disks-----------><----------Network---------->
#Time     cpu sys inter  ctxsw Free Buff Cach Inac Slab  Map KBRead  Reads KBWrit Writes   KBIn  PktIn  KBOut  PktOut 
00:54:24    0   0   107    128 306M 669M   1G   1G 128M   2G      0      0      0      0      4     64    221     159 
00:54:25    1   0   148     91 306M 669M   1G   1G 128M   2G      4      1   3560     28      4     54    152     120 
00:54:26    0   0    88     65 306M 669M   1G   1G 128M   2G      0      0      0      0      6     83    317     222 
00:54:27    7   0   125    135 306M 669M   1G   1G 128M   2G      4      1      4      1      3     40    167     120 
00:54:28   50  22    24    119 305M 669M   1G   1G 128M   2G      0      0      0      0      6     77    188     137 
00:54:29   19   7   160    128 305M 669M   1G   1G 128M   2G      0      0      0      0      2     21     39      40 
00:54:30    1   0   105    106 305M 669M   1G   1G 128M   2G     52      1      0      0      9    123    357     257 
00:54:31    0   0    54     88 305M 669M   1G   1G 128M   2G      0      0   3456     25      4     66    191     134 
00:54:32    0   0    31     63 305M 669M   1G   1G 128M   2G      0      0      0      0      1     14      1       7 
00:54:33    0   0    38     80 306M 669M   1G   1G 128M   2G      0      0      0      0      2     22      2      13 
00:54:34   32   7    30    163 305M 669M   1G   1G 128M   2G      0      0    108      7      2     18      7      17 
00:54:35   47  27    40    526 305M 669M   1G   1G 128M   2G      0      0   3184     22      2     12      1       8 
00:54:36    0   0    32    120 305M 669M   1G   1G 128M   2G      0      0      0      0      1     15      2      10 
00:54:37    0   0    71     90 305M 669M   1G   1G 128M   2G    416      5      0      0      1     19      6      18 
00:54:38    0   0    36     61 305M 669M   1G   1G 128M   2G      0      0      0      0      4     47    257     182 
00:54:39    0   0    21     81 305M 669M   1G   1G 128M   2G      0      0      0      0      1     17    176     123 
00:54:40    0   0    11     45 305M 669M   1G   1G 128M   2G      0      0      0      0      1     13      5      11 
00:54:41   39   5    37    163 305M 669M   1G   1G 128M   2G      0      0    112      8      0      7      0       3 
00:54:42  100  62    36     65 305M 669M   1G   1G 128M   2G      4      1     16      3      3     34     30      32
Curiously, my swap space is on hda which is the main hdd. I have an hdd which is a tarball backup (I create tarballs monthly of /var/www/ and so on). I'm thinking I should reconfigure it so that hdb has the swap. That should fix up some I/O right? It's SATA so I mean it would allow the system to use I/O on the primary hdd for primary purposes. It would then let the secondary hdd handle the swap. Right?
__________________
ISPC3 on Debian! It's great!

Last edited by crypted; 14th October 2010 at 08:12.
Reply With Quote
  #26  
Old 14th October 2010, 21:12
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

Any opinion on my question above???

Reposted:

Curiously, my swap space is on hda which is the main hdd. I have an hdd which is a tarball backup (I create tarballs monthly of /var/www/ and so on). I'm thinking I should reconfigure it so that hdb has the swap. That should fix up some I/O right? It's SATA so I mean it would allow the system to use I/O on the primary hdd for primary purposes. It would then let the secondary hdd handle the swap. Right?

Reason I'm reposting is that the datacenter techs believe that to be negligible. But, if it ends up swapping I figured it wouldn't be negligible at that point?
__________________
ISPC3 on Debian! It's great!
Reply With Quote
  #27  
Old 14th October 2010, 21:38
Antennipasi Antennipasi is offline
ISPConfig Developer
 
Join Date: Dec 2008
Location: Finland
Posts: 67
Thanks: 6
Thanked 13 Times in 12 Posts
Default

Quote:
Originally Posted by crypted View Post
Agreed. But, what is the best method to edit such settings with ISPC3 in use?

I'd love to limit PHP processes for my two popular websites (each racking in several thousand hits a day).
Do you use any php-accelerator? especially when only couple sites get most of hits using those will have very good results.

I have been on your seat, and i used APC and it was very sufficient. In debian install is very easy and configuration is childs play. APC can give 90% more power to Apache&php in frequently accessed sites.

Feel free to contact via PM if you want.
Reply With Quote
  #28  
Old 14th October 2010, 21:56
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

I installed xcache and memcache for PHP a couple of days ago.

APC is another type then?

Anyone feel free to comment on the above swap question!
__________________
ISPC3 on Debian! It's great!
Reply With Quote
  #29  
Old 15th October 2010, 11:37
drewb0y drewb0y is offline
Senior Member
 
Join Date: Sep 2010
Posts: 103
Thanks: 10
Thanked 14 Times in 7 Posts
Default

Quote:
Originally Posted by crypted View Post
I installed xcache and memcache for PHP a couple of days ago.

APC is another type then?
I think this (Alternative PHP Cache) is the APC referred to above.
I will look into adding this to my server as well.
__________________
ISPConfig 3.0.5.4p1 - The Perfect Server - Debian Wheezy (nginx, BIND, Dovecot, ISPConfig 3)
Installed on Debian 7.6 on a KVM VPS
Reply With Quote
  #30  
Old 15th October 2010, 18:02
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
 
Default

XCache has improved performance for sure. I'm going to let them run for another day or so, and then switch to APC and test that out.
__________________
ISPC3 on Debian! It's great!
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
problems with suexec gobokster Installation/Configuration 7 7th May 2009 14:33
Question about the hardware requirement for mysql cluster with load balancing??? johN5Five^ HOWTO-Related Questions 3 12th April 2007 18:06
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04
Apache with MYSQL trouble mandarin14 Installation/Configuration 4 4th December 2005 21:18
MySQL 5.0 and Apache 2.0.xx Lil'Brudder General 2 11th November 2005 02:08


All times are GMT +2. The time now is 19:25.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.