Want more timely Centmin Mod News Updates?
Become a Member

MariaDB Mysql tuning help

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by rdan, Jul 6, 2014.

Tags:
  1. rdan

    rdan Well-Known Member

    5,046
    1,237
    113
    May 25, 2014
    Ratings:
    +1,875
    Local Time:
    12:20 PM
    Mainline
    10.2
    And also, the dedicated user for my xenforo database I just created has no Grant:
    upload_2014-7-6_4-42-50.png

    Is that Fine?
     
  2. eva2000

    eva2000 Administrator Staff Member

    46,488
    10,557
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,390
    Local Time:
    2:20 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    yeah that is added by default but can delete it or not as skip-name-resolve would render it useless
     
  3. eva2000

    eva2000 Administrator Staff Member

    46,488
    10,557
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,390
    Local Time:
    2:20 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    normal, yes only root should have grant permissions
     
  4. rdan

    rdan Well-Known Member

    5,046
    1,237
    113
    May 25, 2014
    Ratings:
    +1,875
    Local Time:
    12:20 PM
    Mainline
    10.2
    So better I delete it as I enable skip-resolve-name?
    Thanks a lot for the advice.
     
  5. rdan

    rdan Well-Known Member

    5,046
    1,237
    113
    May 25, 2014
    Ratings:
    +1,875
    Local Time:
    12:20 PM
    Mainline
    10.2
    Bu doing all of this, my forum index load decrease from 0.13xxx to 0.0999-0.100xxx :D
    Thank You!
    I think I want to try socket instead of tcp :D
     
  6. eva2000

    eva2000 Administrator Staff Member

    46,488
    10,557
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,390
    Local Time:
    2:20 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    up to you, leaving it there shouldn't matter either way with skip-name-resolve

    You're welcome, the rest is now up to your as Centmin Mod is provided as is ;) :D
     
  7. rdan

    rdan Well-Known Member

    5,046
    1,237
    113
    May 25, 2014
    Ratings:
    +1,875
    Local Time:
    12:20 PM
    Mainline
    10.2
    Ow please don't leave me for switching to socket :D
    Is it Ok to use socket instead of tcp on XenForo?
    Like /var/lib/mysql/mysql.sock ?
     
  8. rdan

    rdan Well-Known Member

    5,046
    1,237
    113
    May 25, 2014
    Ratings:
    +1,875
    Local Time:
    12:20 PM
    Mainline
    10.2
    Thank You!
    Deleting it removes this warning:
    Code:
    140706  4:32:26 [Warning] 'user' entry 'root@server.domain.com' ignored in --skip-name-resolve mode.
    140706  4:32:26 [Warning] 'proxies_priv' entry '@% root@server.domain.com' ignored in --skip-name-resolve mode.
    
     
  9. eva2000

    eva2000 Administrator Staff Member

    46,488
    10,557
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,390
    Local Time:
    2:20 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    leave it with TCP ;)
     
  10. eva2000

    eva2000 Administrator Staff Member

    46,488
    10,557
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,390
    Local Time:
    2:20 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    nice improvement, i just enabled skip-name-resolve on the forums had to dig around as I forgot what my longview mysql password was LOL... but not much change for me still forum index around 0.07-0.10 :)

    Code:
    Page Time: 0.0895s
    Memory: 9.3642 MB (Peak: 10.2176 MB)
    Queries (15, time: 0.0114s, 12.7%)
     
  11. rdan

    rdan Well-Known Member

    5,046
    1,237
    113
    May 25, 2014
    Ratings:
    +1,875
    Local Time:
    12:20 PM
    Mainline
    10.2
    Because your are very great, Thank You :)
     
  12. eva2000

    eva2000 Administrator Staff Member

    46,488
    10,557
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,390
    Local Time:
    2:20 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    You're welcome, this thread will serve other forum members well as reference now :D
     
  13. rdan

    rdan Well-Known Member

    5,046
    1,237
    113
    May 25, 2014
    Ratings:
    +1,875
    Local Time:
    12:20 PM
    Mainline
    10.2
    Indeed (y)
     
  14. rdan

    rdan Well-Known Member

    5,046
    1,237
    113
    May 25, 2014
    Ratings:
    +1,875
    Local Time:
    12:20 PM
    Mainline
    10.2
    I don't know if it's related but I just enable memcached on my pagespeed.conf also just few minutes :)
     
  15. rdan

    rdan Well-Known Member

    5,046
    1,237
    113
    May 25, 2014
    Ratings:
    +1,875
    Local Time:
    12:20 PM
    Mainline
    10.2
    Might help you also @eva2000 , I also added this on my xenforo config.php
     
  16. eva2000

    eva2000 Administrator Staff Member

    46,488
    10,557
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,390
    Local Time:
    2:20 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
  17. rdan

    rdan Well-Known Member

    5,046
    1,237
    113
    May 25, 2014
    Ratings:
    +1,875
    Local Time:
    12:20 PM
    Mainline
    10.2