Tripp_UK

+Clients
  • Content count

    553
  • Joined

  • Last visited


4 Followers



About Tripp_UK

  • Rank
    Spam Happy

IPS Marketplace

  • Resources Contributor Total file submissions: 1

Tripp_UK's Activity

  1. Tripp_UK added a post in a topic: (MDX34) Work in progress   

    Looking forward to it.
  2. Tripp_UK added a post in a topic: Full SSL   

    As far as I could tell from my testing IPS4 works on Site-Wide SSL I think it auto-detects it as well because the setting under use HTTPS for Login was greyed out for me because I had site-wide SSL. So if you have SSL for everything you can't disable it - which I thought was nifty.
    So it shouldn't be a problem. If you don't have Site-Wide SSL but do have SSL I assume the button works as normal. If you don't have it at all I assume the button will be greyed out stating you don't have SSL activated. I'm not sure though. What I do know is IPS4 - Works with SSL (Site-Wide). Been using it since Beta 1.0.8
  3. Tripp_UK added a post in a topic: (MDX34) Work in progress   

    Only suggestion I have is; is there any way of controlling which usergroups can see it? That'd be a pretty neat thing. :)
  4. Tripp_UK added a post in a topic: [Eek. Help, please!] Would someone like to help me with my limited server?   

    Sorry for the late reply... Been busy again with a lot of things.
     
    I installed zend opcache, I had some improvements although something is a little "off" because sometimes it can take 42 seconds to load - which definitely isn't good. But TTFB is improved - drastically. 
     
    Before opcache:

     
    After opcache:

     
    I'm hoping it's "Settling Pains" and that it just needs to run for a little while. Once it's done so I'll do some more tests and look at (if still recommended) installing memcache.
     
    Opcache GUI:

  5. Tripp_UK added a post in a topic: Yet another critical SSL Security Flaw... "POODLE"   

    I don't have much information on it but I figured I'd warn people incase they didn't get the message, as I couldn't find it posted on here, and I figured people might like to know about it.
     
    If you use SSL you might want to check if you're vulnerable to the bug "POODLE" which affects those that have SSLv3 enabled ( https://www.ssllabs.com/ssltest/index.html )
    Information on POODLE: https://community.centminmod.com/threads/poodle-attacks-on-sslv3-vulnerability.1651/ (And you can Google it)
  6. Tripp_UK added a post in a topic: [Eek. Help, please!] Would someone like to help me with my limited server?   

    I did them in a space of 15 minutes. Is this "Spaced out" appropriately or would it be better of the period of an hour or something?
     

     
    I didn't make further changes to the MySQL config - I was going to, today but I'm guessing it's not the MySQL that's the problem (At least this much of a problem)?
  7. Tripp_UK added a post in a topic: [Eek. Help, please!] Would someone like to help me with my limited server?   

    Would running InnoDB and MyISAM in one database cause any performance problems? Because it's in the same Database - which is why I am asking. :)
  8. Tripp_UK added a post in a topic: [Eek. Help, please!] Would someone like to help me with my limited server?   

    InnoDB - Most likely ArrowChat.
  9. Tripp_UK added a post in a topic: [Eek. Help, please!] Would someone like to help me with my limited server?   

    Hello again;
     
    Okay I got some data (Just over 24 hours later);
     
    Top
    top - 06:28:22 up 1 day, 3:06, 0 users, load average: 0.00, 0.00, 0.00 Tasks: 41 total, 1 running, 40 sleeping, 0 stopped, 0 zombie Cpu(s): 1.3%us, 0.1%sy, 0.0%ni, 96.1%id, 2.5%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 2097152k total, 1154560k used, 942592k free, 0k buffers Swap: 2097152k total, 520904k used, 1576248k free, 339116k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 18047 SITE 20 0 292m 30m 9888 S 4.3 1.5 0:14.86 php 2575 mysql 20 0 2134m 404m 6372 S 0.3 19.8 1:55.51 mysqld 11927 nobody 20 0 2298m 84m 17m S 0.3 4.1 0:23.28 httpd 11984 nobody 20 0 2372m 87m 18m S 0.3 4.3 0:22.23 httpd 1 root 20 0 19236 1032 864 S 0.0 0.0 0:00.04 init 2 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kthreadd/169 3 root 20 0 0 0 0 S 0.0 0.0 0:00.00 khelper/169 164 root 16 -4 10644 256 252 S 0.0 0.0 0:00.00 udevd 602 root 20 0 179m 1160 804 S 0.0 0.1 0:00.26 rsyslogd 615 named 20 0 384m 4244 1912 S 0.0 0.2 0:00.58 named 649 root 20 0 66620 352 348 S 0.0 0.0 0:00.00 sshd 861 root 20 0 19612 984 840 S 0.0 0.0 0:00.11 dovecot 871 mailnull 20 0 70108 944 724 S 0.0 0.0 0:00.03 exim 875 dovenull 20 0 42496 2948 2516 S 0.0 0.1 0:00.00 pop3-login 876 dovenull 20 0 42360 2628 2448 S 0.0 0.1 0:00.00 imap-login 877 dovecot 20 0 13316 1032 936 S 0.0 0.0 0:00.02 anvil 878 root 20 0 13448 1124 972 S 0.0 0.1 0:00.06 log 880 dovenull 20 0 42356 2440 2384 S 0.0 0.1 0:00.00 pop3-login 881 dovenull 20 0 42360 2664 2448 S 0.0 0.1 0:00.15 imap-login 882 root 20 0 16412 1816 1108 S 0.0 0.1 0:00.12 config 883 dovecot 20 0 29452 1504 1320 S 0.0 0.1 0:00.22 auth 899 root 20 0 139m 27m 25m S 0.0 1.3 0:03.53 httpd 905 root 20 0 135m 1396 1324 S 0.0 0.1 0:00.08 pure-ftpd 907 root 20 0 133m 1384 1340 S 0.0 0.1 0:00.05 pure-authd 914 root 20 0 114m 744 648 S 0.0 0.0 0:00.64 crond 924 root 20 0 21544 464 372 S 0.0 0.0 0:00.00 atd 1009 root 20 0 34940 1748 1388 S 0.0 0.1 0:00.11 cPhulkd - proce 1020 root 20 0 111m 5152 2044 S 0.0 0.2 0:01.99 cpsrvd-ssl 1168 root 20 0 103m 776 504 S 0.0 0.0 0:00.09 cpdavd - accept 1180 root 20 0 38848 2420 1448 S 0.0 0.1 0:02.35 queueprocd - wa 1239 root 20 0 83728 6160 1612 S 0.0 0.3 0:12.30 tailwatchd 1250 root 38 18 31024 1256 764 S 0.0 0.1 0:00.15 cpanellogd - sl 2349 root 20 0 11308 1224 1220 S 0.0 0.1 0:00.00 mysqld_safe 11925 root 20 0 79720 9.9m 2900 S 0.0 0.5 0:00.05 leechprotect 11926 nobody 20 0 91540 3156 752 S 0.0 0.2 0:00.33 httpd 11928 nobody 20 0 2372m 89m 16m S 0.0 4.4 0:22.09 httpd 11985 nobody 20 0 2298m 81m 17m S 0.0 4.0 0:21.61 httpd 16611 root 20 0 19420 1540 1192 S 0.0 0.1 0:00.00 ssl-params 18260 root 20 0 27504 580 376 S 0.0 0.0 0:00.00 vzctl 18261 root 20 0 105m 1848 1500 S 0.0 0.1 0:00.00 bash 18285 root 20 0 14900 1240 988 R 0.0 0.1 0:00.00 top
     
    MySQL Tuner
    >> MySQLTuner 1.3.0 - Major Hayden >> Bug reports, feature requests, and downloads at >> Run with '--help' for additional options and output filtering [OK] Currently running supported MySQL version 5.6.17 [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM [--] Data in MyISAM tables: 541M (Tables: 2031) [--] Data in InnoDB tables: 13M (Tables: 178) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52) [!!] Total fragmented tables: 55 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 1d 3h 4m 30s (390K q [4.010 qps], 38K conn, TX: 25B, RX: 71M) [--] Reads / Writes: 63% / 37% [--] Total buffers: 248.0M global + 4.9M per thread (151 max threads) [OK] Maximum possible memory usage: 984.1M (48% of installed RAM) [OK] Slow queries: 0% (0/390K) [OK] Highest usage of available connections: 3% (6/151) [OK] Key buffer size / total MyISAM indexes: 8.0M/134.4M [OK] Key buffer hit rate: 98.5% (1M cached / 24K reads) [OK] Query cache efficiency: 71.1% (146K cached / 206K selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 3K sorts) [!!] Joins performed without indexes: 626 [OK] Temporary tables created on disk: 13% (580 on disk / 4K total) [OK] Thread cache hit rate: 99% (6 created / 38K connections) [!!] Table cache hit rate: 7% (2K open / 26K opened) [OK] Open file limit used: 7% (3K/50K) [OK] Table locks acquired immediately: 99% (139K immediate / 139K locks) [OK] InnoDB buffer pool / data size: 128.0M/13.3M [OK] InnoDB log waits: 0 -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Adjust your join queries to always utilize indexes Increase table_open_cache gradually to avoid file descriptor limits Read this before increasing table_open_cache over 64: Variables to adjust: join_buffer_size (> 4.0M, or always use indexes with joins) table_open_cache (> 2000)
     
    Response Time (Although I need to look for a better site to get detailed reports)

  10. Tripp_UK added a post in a topic: [Eek. Help, please!] Would someone like to help me with my limited server?   

    Yeah I missed the "top" command too, whoops.
     
    Here's my current my.cnf file in it's entirety:
     

     
    In over 24 hours time, I will post the results including top again. Thanks Grumpy. :)
     
    As for what's causing joins without indexes; I don't know. Is there anyway I can find out? There was a mod that's on here, that was causing "Slow Queries", I uninstalled that though. ( Board Index Face mod, I believe). I'm not sure if it's related to the the joins without indexes though.
  11. Tripp_UK added a post in a topic: Contact Form   

    Problem is if the person is logged in, they cannot logout if banned (I just tried it) so they can't send the message. I've set the permissions up in the app to allow banned members to access the form but currently it doesn't honour this at all. I assume you meant the permissions in the app it self, under " Groups allowed to use the contact form "?
  12. Tripp_UK added a post in a topic: Contact Form   

    I'm using 2.2.2, currently when a user is banned they can't use the form despite the permissions saying that they can. (Not good if that's where you do "Appeals") Is this fixed in 2.2.5?
  13. Tripp_UK added a post in a topic: [Eek. Help, please!] Would someone like to help me with my limited server?   

    Alright, Grumpy. I did as you suggested and the MySQL Config file was exactly where you said it was (I was previously never able to find it), and here are the results, 1 day and 15 hours later.
     
    mysqltuner results:
    >> MySQLTuner 1.3.0 - Major Hayden >> Bug reports, feature requests, and downloads at >> Run with '--help' for additional options and output filtering [OK] Currently running supported MySQL version 5.6.17 [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM [--] Data in MyISAM tables: 543M (Tables: 2031) [--] Data in InnoDB tables: 13M (Tables: 178) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52) [!!] Total fragmented tables: 54 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 1d 15h 25m 22s (907K q [6.394 qps], 90K conn, TX: 56B, RX: 168M) [--] Reads / Writes: 87% / 13% [--] Total buffers: 248.0M global + 4.9M per thread (151 max threads) [OK] Maximum possible memory usage: 984.1M (48% of installed RAM) [OK] Slow queries: 0% (1/907K) [OK] Highest usage of available connections: 4% (7/151) [OK] Key buffer size / total MyISAM indexes: 8.0M/135.3M [OK] Key buffer hit rate: 99.8% (14M cached / 24K reads) [!!] Query cache is disabled [OK] Sorts requiring temporary tables: 0% (0 temp sorts / 21K sorts) [!!] Joins performed without indexes: 4532 [OK] Temporary tables created on disk: 25% (4K on disk / 15K total) [OK] Thread cache hit rate: 99% (7 created / 90K connections) [!!] Table cache hit rate: 6% (1K open / 30K opened) [!!] Open file limit used: 86% (3K/4K) [OK] Table locks acquired immediately: 99% (848K immediate / 848K locks) [OK] InnoDB buffer pool / data size: 128.0M/13.3M [OK] InnoDB log waits: 0 -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Adjust your join queries to always utilize indexes Increase table_open_cache gradually to avoid file descriptor limits Read this before increasing table_open_cache over 64: Variables to adjust: query_cache_type (=1) join_buffer_size (> 4.0M, or always use indexes with joins) table_open_cache (> 2000) open_files_limit (> 4161)
     
    ioping results:
    4096 bytes from . (simfs /vz/private/169): request=1 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=2 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=3 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=4 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=5 time=0.2 ms 4096 bytes from . (simfs /vz/private/169): request=6 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=7 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=8 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=9 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=10 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=11 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=12 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=13 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=14 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=15 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=16 time=0.8 ms 4096 bytes from . (simfs /vz/private/169): request=17 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=18 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=19 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=20 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=21 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=22 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=23 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=24 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=25 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=26 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=27 time=0.0 ms 4096 bytes from . (simfs /vz/private/169): request=28 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=29 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=30 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=31 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=32 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=33 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=34 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=35 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=36 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=37 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=38 time=60.7 ms 4096 bytes from . (simfs /vz/private/169): request=39 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=40 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=41 time=0.0 ms 4096 bytes from . (simfs /vz/private/169): request=42 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=43 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=44 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=45 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=46 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=47 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=48 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=49 time=11.5 ms 4096 bytes from . (simfs /vz/private/169): request=50 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=51 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=52 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=53 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=54 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=55 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=56 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=57 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=58 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=59 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=60 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=61 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=62 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=63 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=64 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=65 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=66 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=67 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=68 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=69 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=70 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=71 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=72 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=73 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=74 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=75 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=76 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=77 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=78 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=79 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=80 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=81 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=82 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=83 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=84 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=85 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=86 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=87 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=88 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=89 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=90 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=91 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=92 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=93 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=94 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=95 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=96 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=97 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=98 time=21.4 ms 4096 bytes from . (simfs /vz/private/169): request=99 time=0.1 ms 4096 bytes from . (simfs /vz/private/169): request=100 time=0.1 ms ^C --- . (simfs /vz/private/169) ioping statistics --- 100 requests completed in 99561.7 ms, 985 iops, 3.8 mb/s min/avg/max/mdev = 0.0/1.0/60.7/6.5 ms
  14. Tripp_UK added a post in a topic: [Eek. Help, please!] Would someone like to help me with my limited server?   

     
    Okay I will run through those today and see what I can get. I have ran MySQL tuner before (recently in fact) here was the results:
    root@server [/]# perl mysqltuner.pl >> MySQLTuner 1.3.0 - Major Hayden <major@mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering [OK] Currently running supported MySQL version 5.6.17 [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +MyISAM +MRG_MYISAM [--] Data in MyISAM tables: 547M (Tables: 2031) [--] Data in InnoDB tables: 13M (Tables: 178) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52) [!!] Total fragmented tables: 62 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 4d 0h 53m 27s (1M q [4.943 qps], 157K conn, TX: 102B, RX: 320M) [--] Reads / Writes: 87% / 13% [--] Total buffers: 169.0M global + 1.1M per thread (151 max threads) [OK] Maximum possible memory usage: 338.9M (33% of installed RAM) [OK] Slow queries: 0% (22/1M) [OK] Highest usage of available connections: 31% (47/151) [OK] Key buffer size / total MyISAM indexes: 8.0M/137.1M [OK] Key buffer hit rate: 99.9% (27M cached / 39K reads) [!!] Query cache is disabled [OK] Sorts requiring temporary tables: 0% (14 temp sorts / 35K sorts) [!!] Joins performed without indexes: 8111 [!!] Temporary tables created on disk: 33% (29K on disk / 89K total) [OK] Thread cache hit rate: 99% (48 created / 157K connections) [!!] Table cache hit rate: 3% (2K open / 63K opened) [OK] Open file limit used: 84% (3K/4K) [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks) [OK] InnoDB buffer pool / data size: 128.0M/13.3M [OK] InnoDB log waits: 0 -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Adjust your join queries to always utilize indexes When making adjustments, make tmp_table_size/max_heap_table_size equal Reduce your SELECT DISTINCT queries without LIMIT clauses Increase table_open_cache gradually to avoid file descriptor limits Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C Variables to adjust: query_cache_type (=1) join_buffer_size (> 256.0K, or always use indexes with joins) tmp_table_size (> 16M) max_heap_table_size (> 16M) table_open_cache (> 2000) As for APC that was a long time ago on another server (a test server) completely. This server was apache, I switched to Nginx, that worked (666ms or so) until I activated SSL then it went up sky high. Go back to Apache (and the current configuration) and I got down to the first post on this topic. By updating my VPS's resource allowances; I got it down further but there is clearly room for more improvement.
     
     
    The revenue? None- as in absolutely zero. Not one cent. Well... Advertising pays for me to put advertising up of my own. As I said we're still a very small site.
     
    ======
     
    I upgraded the server, it's still OpenVZ (In the end, as I couldn't afford the ongoing expenditure of a XenVPS). I get 50Mb/sec (roughly) and 2GB RAM + 2GB "VSWAP"), I haven't had time to do much else other than changing my DNS from Cloudflare and setting my nameservers to by own domain. When I upgraded I noticed a speed increase, and again when I put my nameservers on my own domain other than ns.kate.cloudflare.com whatever (From when I tried Cloudflare) so right now; and no other settings have been changed I've got it down to:
     

     
    Which in my small world is a major achievement, getting it down from four digits to three. I will at some point be looking at removing XCache and putting on "Memcached" instead - but I am still a little vague on it. I think (one of many of) my Achilles heel here is that there is a configuration for these cache things or a Admin Control Panel which I can't seem to find or access, I remember there being one for one of them that I've used before - but it never cached anything (the cache was always empty). Anyway I will be looking into it today and I wanted to thank everyone for putting up with me and helping so far.
  15. Tripp_UK added a post in a topic: Moving from Shared to VPS, help   

    On a VPS I highly recommend installing CSF ( http://configserver.com/cp/csf.html )
     
    Take it from personal experience, jumping from Shared (Esp, managed) to VPS (Esp, unmanaged) is a huge and terrifying (and yet, exciting) leap with lots of stuff to learn about. But it's well worth it, and fun.

Status Feed

  1. Tripp_UK » Michael

    I LOVE your profile background! <3

  2. Tripp_UK

    What on earth is going on here?

  3. Tripp_UK

    Really unhappy with 3.2.0's handling of avatars... http://community.invisionpower.com/topic/342553-32-avatars/