Search results

  1. C

    Easiest way to use PHP-FPM in Apache+Nginx VPS?

    I have CentOS 6.5 Apache and Nginx reverse proxy VPS. I like to use php-fpm. So what is the easiest method to install it? I read cpXstack plugin, but looks like it can install only Nginx only VPS. I can't find anything about how to install it Nginx reverses proxy server. Can anybody...
  2. C

    Higher MySQL RAM usage, need to optimize

    Could you please tell me what do you mean by well optimized? Is it MySQL, Apach, Nginx optimization or anything else? I really need to reduce my VPS cost. Now I'm paying $40 in each month for 2.5GB dual core CPU managed VPS. It's too much cost for me. Monthly earning less than $120.
  3. C

    Higher MySQL RAM usage, need to optimize

    Thanks thinkbot your continuous support. :D
  4. C

    Instant Email notification when each cPanel user login [or login tracking ]?

    I enabled that option. But I think it only send an mail if the login failed, if the login success it's not send any mail. But I'm searching if send email notification when each cPanel account login succeeded or failed. - - - Updated - - - Got it. Thanks edigest.
  5. C

    Higher MySQL RAM usage, need to optimize

    Thanks thinkbot. Then if I need to downgrade the VPS, how do I determine its required RAM? :confused:
  6. C

    Instant Email notification when each cPanel user login [or login tracking ]?

    Yes yes, just enabled it. Lets see how it will work. Sorry what is LFD?
  7. C

    Higher MySQL RAM usage, need to optimize

    Normally after 24 hours left, (specially my sites backup plugins ran) I can see there's only 300-500MB free RAM. After the reboot I can gain more RAM. That's why I do it.
  8. C

    Instant Email notification when each cPanel user login [or login tracking ]?

    Hello all! Are there anyway to use instant email notifications when each cPanel user login to the account (web or SSH) with the IP address and host name? Or view the past each cPanel account user login time, IP and host name? Right now I enabled WHM login email alert, it works perfectly. But I...
  9. C

    Higher MySQL RAM usage, need to optimize

    Thank Thinkbot. Yes, I run it once I installed that script. But after that I rebooted the VPS several times. However before I take that log, I didn't run that command. Should I again take that slow query log? 19.00.00 to 00:00 is the peak time. That time according to the G analytics there's...
  10. C

    Higher MySQL RAM usage, need to optimize

    After the 24 hours left, this is my log. slow queries - Pastebin.com Could you please tell me what's the wrong in my database?
  11. C

    Higher MySQL RAM usage, need to optimize

    I just installed that package. How much time should I wait for take that report?
  12. C

    Higher MySQL RAM usage, need to optimize

    Is it ok if I adjust long_query_time=0.1 value. Because I can see lots of WordPress database error MySQL server has gone away for query errors in WordPress debug.
  13. C

    Higher MySQL RAM usage, need to optimize

    Thank you again think bot your support. These are the MUNIN screenshots. Looks like slow mysql queries started after tweak the my.cnf file. Is it its configuration issue or just a normal? MySQL RAM. Load. CPU
  14. C

    Higher MySQL RAM usage, need to optimize

    Thanks again. Yes, I have munin server monitor plugin. Again thank you so much for your help. :D
  15. C

    Higher MySQL RAM usage, need to optimize

    Thank you thinkbot your support. I checked the slow query log, it has lots of things. Most of the log query shows wp options table. Yes there are some wordpress plugin too. Specially security plugin (eg:-Wordfence Security) - - - Updated - - - Thanks again thinkbot. I just increased...
  16. C

    Higher MySQL RAM usage, need to optimize

    After the 24 hours, I get following result. I changed max_connections = 80 query_cache_size = 40M But no idea about following things, what could be the proper value for them? wait_timeout (< 30) interactive_timeout (< 28800) When I run MySQL tuning primer it gives...
  17. C

    Higher MySQL RAM usage, need to optimize

    Randomly I can see several MySQL server has gone away for query MySQL error. How do I fix it? eg:-
  18. C

    Need Apache optmization for reduce RAM usage

    I have a Linux VPS. This VPS is Apache+Nignx. The Apache global configuration uses default settings. Its Wordpress blog uses a W3total cache (disk enhanced cache, disk HTML, JS, CSS minify, XCache for database caching, browser cache and CDN) with cloudflare. A few months ago I have 5,000 daily...
  19. C

    Higher MySQL RAM usage, need to optimize

    Now I'm using thinkbot updated configuration. Looks like table_cache getting lower in every minutes. 20 minutes ago it's ratio is 98%, but now it's reduced to 10%. PHPMyAdmin advice to "Flushing the query cache". Here's it advice, This is the MySQL Tuner result. How do I fix this...