SJ77 Posted June 27, 2016 Posted June 27, 2016 Got a new vps from godaddy Selected 4gb ram option setup IPS site, made live and server getting hammered!! Slooow please help.
SJ77 Posted June 27, 2016 Author Posted June 27, 2016 5 minutes ago, Cloud 9 said: Try a decent host ? Really not trying to start a who's the best host debate. Not sure that's even allowed here anyway. I am only seeking help from peers about improving performance. I admit I have much to learn. Looked around and this was what I could afford.
IveLeft... Posted June 27, 2016 Posted June 27, 2016 7 minutes ago, superj707 said: Really not trying to start a who's the best host debate. Not sure that's even allowed here anyway. I am only seeking help from peers about improving performance. I admit I have much to learn. Looked around and this was what I could afford. Its not, try CIC - They are really REALLY good for IPS software....... GD sucks though hence my try a better host......
SJ77 Posted June 28, 2016 Author Posted June 28, 2016 maybe it's mysql ??? [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.6.30 [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ----------------------------------------------------------------- [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA [--] Data in MyISAM tables: 871M (Tables: 264) [--] Data in InnoDB tables: 1G (Tables: 172) [OK] Total fragmented tables: 0 -------- Security Recommendations ------------------------------------------------------------------ [OK] There are no anonymous accounts for any database users [!!] User 'leechprotect@localhost' has no password set. [--] There are 605 basic passwords in the list. -------- CVE Security Recommendations -------------------------------------------------------------- [OK] NO SECURITY CVE FOUND FOR YOUR VERSION -------- Performance Metrics ----------------------------------------------------------------------- [--] Up for: 17h 23m 50s (11M q [183.753 qps], 675K conn, TX: 78G, RX: 7G) [--] Reads / Writes: 91% / 9% [--] Binary logging is disabled [--] Physical Memory : 4.0G [--] Max MySQL memory : 338.9M [--] Other process memory: 746.8M [--] Total buffers: 169.0M global + 1.1M per thread (151 max threads) [--] P_S Max memory usage: 0B [--] Galera GCache Max memory usage: 0B [OK] Maximum reached memory usage: 273.6M (6.68% of installed RAM) [OK] Maximum possible memory usage: 338.9M (8.27% of installed RAM) [OK] Overall possible memory usage with other process is compatible with memory available [OK] Slow queries: 0% (1/11M) [OK] Highest usage of available connections: 61% (93/151) [OK] Aborted connections: 0.00% (15/675047) [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance [OK] Query cache is disabled by default due to mutex contention on multiprocessor machines. [OK] Sorts requiring temporary tables: 0% (1K temp sorts / 679K sorts) [!!] Joins performed without indexes: 4318 [!!] Temporary tables created on disk: 45% (104K on disk / 230K total) [OK] Table cache hit rate: 98% (633 open / 642 opened) [OK] Open file limit used: 12% (638/5K) [OK] Table locks acquired immediately: 99% (13M immediate / 13M locks) -------- Performance schema ------------------------------------------------------------------------ [--] Performance schema is disabled. -------- ThreadPool Metrics ------------------------------------------------------------------------ [--] ThreadPool stat is disabled. -------- MyISAM Metrics ---------------------------------------------------------------------------- [OK] Key buffer used: 100.0% (8M used / 8M cache) [OK] Key buffer size / total MyISAM indexes: 8.0M/240.2M [OK] Read Key buffer hit rate: 99.7% (716M cached / 2M reads) [!!] Write Key buffer hit rate: 28.5% (104K cached / 74K writes) -------- AriaDB Metrics ---------------------------------------------------------------------------- [--] AriaDB is disabled. -------- InnoDB Metrics ---------------------------------------------------------------------------- [--] InnoDB is enabled. [!!] InnoDB buffer pool / data size: 128.0M/1.0G [!!] InnoDB buffer pool <= 1G and innodb_buffer_pool_instances(!=1). [OK] InnoDB Used buffer: 87.50% (7167 used/ 8191 total) [OK] InnoDB Read buffer efficiency: 99.92% (541302842 hits/ 541755760 total) [OK] InnoDB Write log efficiency: 93.88% (9801556 hits/ 10440607 total) [OK] InnoDB log waits: 0.00% (0 waits / 639051 writes) -------- TokuDB Metrics ---------------------------------------------------------------------------- [--] TokuDB is disabled. -------- Galera Metrics ---------------------------------------------------------------------------- [--] Galera is disabled. -------- Replication Metrics ----------------------------------------------------------------------- [--] Galera Synchronous replication: NO [--] No replication slave(s) for this server. [--] This is a standalone server. -------- Recommendations --------------------------------------------------------------------------- General recommendations: Set up a Password for user with the following SQL statement ( SET PASSWORD FOR 'user'@'SpecificDNSorIp' = PASSWORD('secure_password'); ) MySQL started within last 24 hours - recommendations may be inaccurate Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1 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 which have no LIMIT clause Variables to adjust: join_buffer_size (> 256.0K, or always use indexes with joins) tmp_table_size (> 16M) max_heap_table_size (> 16M) innodb_buffer_pool_size (>= 1G) if possible. innodb_buffer_pool_instances (=1)
Flitterkill Posted June 28, 2016 Posted June 28, 2016 Changing those last two innodb buffer pool variables as suggested at the bottom would be a great start. Pool size at 1.1G , buffer pool instance 1. All those variables to adjust are a good idea really. I have zero idea how GD whips up their VPS offerings but in some instances other tenants on your server can still hurt your own performance. It's far more noticeable on shared hosting of course, but not all VPS offerings are the same.
SJ77 Posted June 28, 2016 Author Posted June 28, 2016 6 minutes ago, Flitterkill said: Changing those last two innodb buffer pool variables as suggested at the bottom would be a great start. Pool size at 1.1G , buffer pool instance 1. All those variables to adjust are a good idea really. I have zero idea how GD whips up their VPS offerings but in some instances other tenants on your server can still hurt your own performance. It's far more noticeable on shared hosting of course, but not all VPS offerings are the same. yeah, it's insane. I have slow loading pages and no idea why. My memory seems fine, zero swap used., my cpu's are mostly idle. And IO looks fine. It's like WTF.. how can I have a server load of 27 correction.. server load of 39 plus!! .. UGHHH
Flitterkill Posted June 28, 2016 Posted June 28, 2016 Pretty sure that's everyone on the server - those are probably cpu cores. If you could (but want to keep this private) pm me a recent one of those first images you posted - the one with the processes. They are cut off so can't quite see what's on the tail end of those.
ASTRAPI Posted June 29, 2016 Posted June 29, 2016 Bad server and bad configuration and there are many much better vps's out there with much better prices ....
BRamburn Posted July 9, 2016 Posted July 9, 2016 I'm using Digital Ocean; 4GB and 4 cores i believe. runs really fast on nginx + php 5.6 + mysql. Did you configure the VPS on your own.
ASTRAPI Posted July 9, 2016 Posted July 9, 2016 Getting a vps with 4gb ram and 4 cores from Godaddy and getting a vps from another reputable provider with the same specs doesn't mean at all that will perform the same in any way. Godaddy vps's are very limited with a bit of outdated hardware.Sorry to say that. All starting from where are your users located from and then get a vps from some reputable providers that many users recommend you. Other than that as i can see you just try to fix your issue by yourself and if you don't know what to do, learning is something that can't be done in a few days in any way as there so many parameters related to check.... I will recommend you to hire someone to fix it for you and then that you will be relaxed start learning..... If you can't afford to hire someone then ask for free help here on the forums and maybe someone can help.....
SJ77 Posted July 9, 2016 Author Posted July 9, 2016 Thanks ASTRAPI This thread is a bit out dated. I've since dumped GD. I picked up OVH dedicated. Installed VestaCP running nginx and php-fpm. I had help to do all of the updates and initial setup. I totally have the hang of moving website and db around using ssh. but I still need to learn initial setup. I was able to install VestaCP on my own no problem but I have trouble updating to the newest php, newest mariadb, etc without breaking vestacp. Seems like it should be easy but you run the install and things break.. I don't get it. Anyway I ALSO now have a $3.45 / Month VPS to practice on. So any advice is welcome. I am determined to master this. Thank you
ASTRAPI Posted July 9, 2016 Posted July 9, 2016 That's why i always recommend to not use a control panel as it is much easier to perform this tasks Ok anyway....
AlexJ Posted July 10, 2016 Posted July 10, 2016 Changelog. That's the first thing I normally read before upgrading anything. You need to know what's being changed and what would affect you.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.