sobrenome

+Clients
  • Content count

    1,164
  • Joined

  • Last visited


4 Followers



About sobrenome

  • Rank
    Needs Serious Help

Recent Profile Visitors


6,485 profile views

sobrenome's Activity

  1. sobrenome added a post in a topic MariaDB with XtraDB   

    Thanks @RevengeFNF! I have followed your suggestions! In the next days I will post the new mysqltuner and new relic data.
    Do you know where can I check the tpmdir usage?
    I have addressed 1GB RAM for it, but when I check its use on Cpanel it's always a few kbytes. I would like to reduce the tpmdir size to the smallest safe size, I guess about 1MB, to use the RAM with memcache.
  2. sobrenome added a post in a topic Introducing ForumMob! - White label mobile apps for IPB   

    Keep up the good work! I am sure that the White-label App for IPS 4 will be a very requested.
  3. sobrenome added a post in a topic MariaDB with XtraDB   

    Thanks @RevengeFNF!!!
    Here is the result:
    >> MySQLTuner 1.5.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.20-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: 129) [--] Data in InnoDB tables: 7G (Tables: 674) [--] Data in MEMORY tables: 0B (Tables: 2) [!!] Total fragmented tables: 153 -------- Security Recommendations ------------------------------------------- [OK] There is no anonymous account in all database users [OK] All database users have passwords assigned [!!] There is not basic password file list ! -------- Performance Metrics ------------------------------------------------- [--] Up for: 22d 16h 14m 37s (87M q [44.419 qps], 2M conn, TX: 927B, RX: 51B) [--] Reads / Writes: 70% / 30% [--] Binary logging is disabled [--] Total buffers: 8.2G global + 2.8M per thread (192 max threads) [OK] Maximum reached memory usage: 8.4G (53.85% of installed RAM) [OK] Maximum possible memory usage: 8.7G (56.26% of installed RAM) [OK] Slow queries: 0% (89/87M) [OK] Highest usage of available connections: 28% (54/192) [OK] Aborted connections: 1.62% (46729/2875817) [!!] Key buffer used: 32.0% (42M used / 134M cache) [OK] Key buffer size / total MyISAM indexes: 128.0M/2.0G [OK] Read Key buffer hit rate: 99.7% (1B cached / 4M reads) [!!] Write Key buffer hit rate: 21.8% (186M cached / 146M writes) [!!] Query cache is disabled [OK] Sorts requiring temporary tables: 0% (3K temp sorts / 1M sorts) [!!] Joins performed without indexes: 8862 [OK] Temporary tables created on disk: 2% (219K on disk / 7M total) [OK] Thread cache hit rate: 98% (37K created / 2M connections) [!!] Table cache hit rate: 0% (400 open / 176K opened) [OK] Open file limit used: 2% (56/2K) [OK] Table locks acquired immediately: 99% (98M immediate / 98M locks) -------- InnoDB Metrics ----------------------------------------------------- [--] InnoDB is enabled. [OK] InnoDB buffer pool / data size: 8.0G/7.0G [OK] InnoDB buffer pool instances: 8 [OK] InnoDB Used buffer: 98.44% (516078 used/ 524280 total) [OK] InnoDB Read buffer efficiency: 100.00% (88229038442 hits/ 88229676769 total) [!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total) [OK] InnoDB log waits: 0.00% (0 waits / 1582445 writes) -------- Replication Metrics ------------------------------------------------- [--] No replication slave(s) for this server. [--] This is a standalone server.. -------- 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: http://bit.ly/1mi7c4C Variables to adjust: query_cache_size (>= 8M) join_buffer_size (> 128.0K, or always use indexes with joins) table_open_cache (> 400)New Relic data:

    Mysql my.cnf:
    [mysqld] ############################### # Basic Settings # ############################### skip-external-locking performance_schema = off #bind-address = 127.0.0.1 tmpdir = /var/mysqltmp ############################### # Fine Tuning # ############################### max_connections = 192 connect_timeout = 30 wait_timeout = 600 max_allowed_packet = 256M thread_cache_size = 128 tmp_table_size = 64M max_heap_table_size = 64M thread_handling = pool-of-threads ############################### # MyISAM # ############################### myisam_recover = BACKUP concurrent_insert = 2 ############################### # Query Cache Configuration # ############################### query_cache_limit = 128K query_cache_size = 0M query_cache_type = OFF ############################### # Logging and Replication # ############################### #general_log_file = /var/log/mysql/mysql.log #general_log = 1 ############################### # InnoDB # ############################### default_storage_engine = InnoDB innodb_log_file_size = 2G innodb_buffer_pool_size = 8G innodb_log_buffer_size = 32M innodb_file_per_table = 1 innodb_open_files = 800 innodb_io_capacity = 800 innodb_flush_method = O_DIRECT innodb_flush_log_at_trx_commit = 0 transaction-isolation = READ-COMMITTED open_files_limit=2048 
  4. sobrenome added a post in a topic MariaDB with XtraDB   

    I am stuck trying to upgrade mysqltuner in my channel box.
    I have followed this tutorial http://kb.enterprisevpssolutions.com/how-to-update-mysqltuner-pl-to-latest-version/
    And now the result is:
    -bash: ./mysqltuner.pl: No such file or directoryTried to reinstall again, but no success.
     
    I am using SSD now.
  5. sobrenome added a post in a topic MariaDB with XtraDB   

    Are you running IPS 4 already? Is there any specific tuning on MariaDB for the IPS 4?
  6. sobrenome added a topic in Product Feedback   

    Pages Templates and Email Templates in Themes
    Forums templates are located in the theme settings.
    Why page templates and email templates are not there?
    For me it's logical that the customisation should be treated as a theme thing.
    I have realised this after doing the customisation of a theme, pages templates and email templates on localhost.
    When I export the theme, pages templates and email templates do not follow.
    Email templates have to be downloaded one by one.
    And Pages templates are even worse, there is no download feature.
    • 1 reply
    • 63 views
  7. sobrenome added a post in a topic Support for Chrome Push Notifications   

    It's not that handful to the website users. Something more easy just like saying yes to a notification pop up is much better.
  8. sobrenome added a post in a topic App for iOS and Android   

    perfect! That's exactly whta I am looking for. Thanks @Joel R!
  9. sobrenome added a post in a topic Introducing ForumMob! - White label mobile apps for IPB   

    Sounds very nice! I was looking for something like this. I hope this project gets ready soon!
  10. sobrenome added a post in a topic Support for Chrome Push Notifications   

    Very nice if could be implemented to every browser.
  11. sobrenome added a post in a topic Support for Chrome Push Notifications   

    Very nice suggestion!
  12. sobrenome added a post in a topic IP.Pages Unique Fields   

    This feature is very import to avoid duplicated database records in databases that users can post content. I am willing to build a wiki database for certain professionals and having more than one record for the same person is really annoying. 
    I hope we get this feature soon.
  13. sobrenome added a topic in Product Feedback   

    App for iOS and Android
    IPS 4 is great. The responsive design is awesome. 
    But for cell phone perfect experience, an App that could use the phone notification function would be amazing.
    Imagine the phone notifying the user whenever there is a reply to its topic!
    I have very little knowledge in programming but I suppose that considering the responsive layout and the advanced IPS 4 technology, an App for the IPS 4 Community may not be very hard to develop.
    The most amazing feature would be to integrate the IPS 4 notification center to the user's phone notification system.
    IPS could sell the App to the community owners to let them customize the theme and the App name and icon to match the websites. Then the websites owners could offer the customised App in the Google Play Store and Apple Store.
    What do you think?
    • 4 replies
    • 157 views
  14. sobrenome added a post in a topic Pages Category Icon   

    Thanks a lot @Ralf Herrmann!!