/ Register

Discover Centmin Mod today
Register Now

MariaDB Mysql tuning help

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

Tags:
Previous Thread Next Thread
Loading...
Page 2 of 2
  1. Jul 6, 2014 #21
    rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    2:10 AM
    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. Jul 6, 2014 #22
    eva2000

    eva2000 Administrator Staff Member

    54,931
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    4:10 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    yeah that is added by default but can delete it or not as skip-name-resolve would render it useless
     
  3. Jul 6, 2014 #23
    eva2000

    eva2000 Administrator Staff Member

    54,931
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    4:10 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    normal, yes only root should have grant permissions
     
  4. Jul 6, 2014 #24
    rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    2:10 AM
    Mainline
    10.2
    So better I delete it as I enable skip-resolve-name?
    Thanks a lot for the advice.
     
  5. Jul 6, 2014 #25
    rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    2:10 AM
    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. Jul 6, 2014 #26
    eva2000

    eva2000 Administrator Staff Member

    54,931
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    4:10 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Jul 6, 2014 #27
    rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    2:10 AM
    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. Jul 6, 2014 #28
    rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    2:10 AM
    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. Jul 6, 2014 #29
    eva2000

    eva2000 Administrator Staff Member

    54,931
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    4:10 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    leave it with TCP ;)
     
  10. Jul 6, 2014 #30
    eva2000

    eva2000 Administrator Staff Member

    54,931
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    4:10 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    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. Jul 6, 2014 #31
    rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    2:10 AM
    Mainline
    10.2
    Because your are very great, Thank You :)
     
  12. Jul 6, 2014 #32
    eva2000

    eva2000 Administrator Staff Member

    54,931
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    4:10 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    You're welcome, this thread will serve other forum members well as reference now :D
     
  13. Jul 6, 2014 #33
    rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    2:10 AM
    Mainline
    10.2
    Indeed (y)
     
  14. Jul 6, 2014 #34
    rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    2:10 AM
    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. Jul 6, 2014 #35
    rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    2:10 AM
    Mainline
    10.2
    Might help you also @eva2000 , I also added this on my xenforo config.php
     
  16. Jul 6, 2014 #36
    eva2000

    eva2000 Administrator Staff Member

    54,931
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,812
    Local Time:
    4:10 AM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
  17. Jul 6, 2014 #37
    rdan

    rdan Well-Known Member

    5,447
    1,408
    113
    May 25, 2014
    Ratings:
    +2,201
    Local Time:
    2:10 AM
    Mainline
    10.2
Previous Thread Next Thread
Loading...
Page 2 of 2

.