Get the most out of your Centmin Mod LEMP stack
Become a Member

MariaDB 10 - mariadb10fix.sh moved posts

Discussion in 'MariaDB & General MySQL news & discussions' started by RoldanLT, Oct 10, 2014.

  1. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:18 PM
    1.11
    10.2
  2. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:18 PM
    1.11
    10.2
    Specifically this:

    InnoDB: Memory barrier is not used

    InnoDB: Using CPU crc32 instructions

     
  3. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:18 PM
    1.11
    10.2

    With this script looks like it stops nginx, Why?
    After the script is run nginx is not running.
    I have to start it manually.

    And also what temporary files/folders need to delete after running this script?
    Like /home/mysql10fix.
     
  4. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:18 PM
    Nginx 1.13.x
    MariaDB 5.5
    Last edited: Oct 10, 2014
    • Like Like x 1
  5. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:18 PM
    1.11
    10.2
  6. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:18 PM
    Nginx 1.13.x
    MariaDB 5.5


    It's just a note regarding whether your cpu supports crc32 instructions which started with Intel Nehalem platform and introduction of SSE4.2 support

    Virtulbox instance i used for that log output you are comparing didn't have cpu flag support for SSE4.2 hence mine says not using CPU crc32 instructions. As to memory barrier instructions it's another thing specific to my virtualbox instance. As my live KVM based VPS server with MariaDB 10 in non-virtualbox shows same as yours
    Code:
    141008  3:34:08 [Note] InnoDB: Using mutexes to ref count buffer pool pages
    141008  3:34:08 [Note] InnoDB: The InnoDB memory heap is disabled
    141008  3:34:08 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    141008  3:34:08 [Note] InnoDB: Memory barrier is not used
    141008  3:34:08 [Note] InnoDB: Compressed tables use zlib 1.2.3
    141008  3:34:08 [Note] InnoDB: Using Linux native AIO
    141008  3:34:08 [Note] InnoDB: Not using CPU crc32 instructions
    141008  3:34:08 [Note] InnoDB: Initializing buffer pool, size = 48.0M
    141008  3:34:08 [Note] InnoDB: Completed initialization of buffer pool
    141008  3:34:08 [Note] InnoDB: Highest supported file format is Barracuda.
    141008  3:34:08 [Note] InnoDB: 128 rollback segment(s) are active.
    141008  3:34:08 [Note] InnoDB: Waiting for purge to start
    141008  3:34:08 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.20-68.0 started; log sequence number 1601336
    141008  3:34:08 [Note] Plugin 'FEDERATED' is disabled.
    141008  3:34:08 [Note] Plugin 'ARCHIVE' is disabled.
    141008  3:34:08 [Note] Plugin 'FEEDBACK' is disabled.
    141008  3:34:08 [Note] Server socket created on IP: '::'.
    141008  3:34:08 [Note] Event Scheduler: Loaded 0 events

     
    • Like Like x 1
  7. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:18 PM
    Nginx 1.13.x
    MariaDB 5.5
    no temp files besides contents of /home/mysql10fix which you may want to download as a backup just in case
     
    • Like Like x 1
  8. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:18 PM
    1.11
    10.2
    That for the clarification Eva :)
    New insights for today :)
     
  9. RoldanLT

    RoldanLT Well-Known Member

    3,830
    929
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,258
    Local Time:
    7:18 PM
    1.11
    10.2
    So far no problem on my config and the output for mysqladmin var | tr -s ' ' ? :)
     
  10. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:18 PM
    Nginx 1.13.x
    MariaDB 5.5
    Looks okay as far as I can see
     
    • Like Like x 1
  11. pamamolf

    pamamolf Well-Known Member

    2,533
    231
    63
    May 31, 2014
    Ratings:
    +394
    Local Time:
    2:18 PM
    Nginx-1.13.x
    MariaDB 10.1.x
    What is this fix for?
     
  12. eva2000

    eva2000 Administrator Staff Member

    29,033
    6,589
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +9,782
    Local Time:
    9:18 PM
    Nginx 1.13.x
    MariaDB 5.5