sobrenome

+Clients
  • members_posts

    902
  • Joined

  • Last visited


5 Followers



About sobrenome

Recent Profile Visitors


5,815 profile views

sobrenome's Activity

  1. sobrenome added a post in a topic: RC4 today?   

    RC3 didn't work for me either. Wishing for RC4.
  2. sobrenome added a post in a topic: MariaDB with XtraDB   

    ​PHP 5.5 with fcgi and opcache. I am stuck in Cpanel, and they promised that in the next 2 months they are going to add PHP-FPM.
    Is there something that I can do to optimize fcgi besides opcache?
  3. sobrenome added a post in a topic: MariaDB with XtraDB   

    I guess I still need help from you. Look the New Relic analysis:
     
     

  4. sobrenome added a post in a topic: MariaDB with XtraDB   

    As soon as I get New Relic data I will post here. It's very exciting to see that a good setting can make a huge difference. The data you are posting is based in 3.4.7 or 4.0?
  5. sobrenome added a post in a topic: On the performance of IPS 4.0 vs 3.x   

    If you set the cache system to use mysql and memcached guest experience will be much faster.
  6. sobrenome added a post in a topic: RC3?   

    I hope I can upgrade this time with no errors.
  7. sobrenome added a post in a topic: MariaDB with XtraDB   

    I installed New Relic. Waiting for data.
    Latest mysqltuner recommendations:
    >> MySQLTuner 1.4.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 [!!] Currently running unsupported MySQL version 10.0.16-MariaDB [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +ARCHIVE +Aria +BLACKHOLE +CSV +FEDERATED +InnoDB +MRG_MyISAM [--] Data in MyISAM tables: 3G (Tables: 1034) [--] Data in InnoDB tables: 5G (Tables: 674) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 52) [--] Data in MEMORY tables: 0B (Tables: 2) [!!] Total fragmented tables: 191 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 11h 36m 24s (953K q [22.827 qps], 48K conn, TX: 17B, RX: 274M) [--] Reads / Writes: 67% / 33% [--] Total buffers: 8.2G global + 2.8M per thread (192 max threads) [OK] Maximum possible memory usage: 8.7G (56% of installed RAM) [OK] Slow queries: 0% (6/953K) [OK] Highest usage of available connections: 6% (12/192) [OK] Key buffer size / total MyISAM indexes: 128.0M/2.3G [OK] Key buffer hit rate: 95.7% (205K cached / 8K reads) [!!] Query cache is disabled [OK] Sorts requiring temporary tables: 0% (21 temp sorts / 33K sorts) [OK] Temporary tables created on disk: 22% (5K on disk / 24K total) [OK] Thread cache hit rate: 98% (721 created / 48K connections) [!!] Table cache hit rate: 1% (400 open / 20K opened) [OK] Open file limit used: 5% (216/4K) [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks) [OK] InnoDB buffer pool / data size: 8.0G/5.9G [OK] InnoDB log waits: 0 -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate 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_size (>= 8M) table_open_cache (> 400)  
  8. sobrenome added a post in a topic: MariaDB with XtraDB   

    ​This suggestion seems to be the best I have tried so far. But I really can't understand why TTFB is lower for a first time visitor and higher for a visitor that has files already cached.
    There is only one problem: 
    "bind-address = 127.0.0.1" makes the mysql down, it doesn't restart. Is it important? How to set it?
    What about tmp directory on RAM? Is it effective?
  9. sobrenome added a post in a topic: MariaDB with XtraDB   

    ​But InnoDB relies on RAM memory, isn't it?
  10. sobrenome added a post in a topic: MariaDB with XtraDB   

    ​Could you please post you my.cnf settings?
  11. sobrenome added a post in a topic: MariaDB with XtraDB   

    Yes, it's a dedicated server with a single HDD.
    I will install newrelic and post here the test results.
  12. sobrenome added a post in a topic: MariaDB with XtraDB   

    Not accurate. Range from 5 seconds to 0.02 seconds.
  13. sobrenome added a post in a topic: MariaDB with XtraDB   

    The strange thing is that first view TTFB is more than 50% lower than TTFB in repeated view.
    I am testing with webpagetest.org.
    Is there a better tool?
  14. sobrenome added a post in a topic: MariaDB with XtraDB   

    With the current settings, the first view TTFB gets around 400ms (nice) but the repeated view goes around 1100ms... (much worse than before)

  15. sobrenome added a post in a topic: MariaDB with XtraDB   

    tmpdir on RAM made no difference, it was barely used.
    When something was there, it was about 16kb for very short time.