/ Register

Learn about Centmin Mod LEMP Stack today
Become a Member

MariaDB 10 - mariadb10fix.sh moved posts

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

Tags:
Previous Thread Next Thread
Loading...
  1. Oct 10, 2014 #1
    rdan

    rdan Well-Known Member

    5,443
    1,402
    113
    May 25, 2014
    Ratings:
    +2,194
    Local Time:
    4:09 PM
    Mainline
    10.2
  2. Oct 10, 2014 #2
    rdan

    rdan Well-Known Member

    5,443
    1,402
    113
    May 25, 2014
    Ratings:
    +2,194
    Local Time:
    4:09 PM
    Mainline
    10.2
    Specifically this:

    InnoDB: Memory barrier is not used

    InnoDB: Using CPU crc32 instructions

     
  3. Oct 10, 2014 #3
    rdan

    rdan Well-Known Member

    5,443
    1,402
    113
    May 25, 2014
    Ratings:
    +2,194
    Local Time:
    4:09 PM
    Mainline
    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. Oct 10, 2014 #4
    eva2000

    eva2000 Administrator Staff Member

    54,110
    12,179
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,739
    Local Time:
    6:09 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Last edited: Oct 10, 2014
  5. Oct 10, 2014 #5
    rdan

    rdan Well-Known Member

    5,443
    1,402
    113
    May 25, 2014
    Ratings:
    +2,194
    Local Time:
    4:09 PM
    Mainline
    10.2
  6. Oct 10, 2014 #6
    eva2000

    eva2000 Administrator Staff Member

    54,110
    12,179
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,739
    Local Time:
    6:09 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+


    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

     
  7. Oct 10, 2014 #7
    eva2000

    eva2000 Administrator Staff Member

    54,110
    12,179
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,739
    Local Time:
    6:09 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    no temp files besides contents of /home/mysql10fix which you may want to download as a backup just in case
     
  8. Oct 10, 2014 #8
    rdan

    rdan Well-Known Member

    5,443
    1,402
    113
    May 25, 2014
    Ratings:
    +2,194
    Local Time:
    4:09 PM
    Mainline
    10.2
    That for the clarification Eva :)
    New insights for today :)
     
  9. Oct 10, 2014 #9
    rdan

    rdan Well-Known Member

    5,443
    1,402
    113
    May 25, 2014
    Ratings:
    +2,194
    Local Time:
    4:09 PM
    Mainline
    10.2
    So far no problem on my config and the output for mysqladmin var | tr -s ' ' ? :)
     
  10. Oct 10, 2014 #10
    eva2000

    eva2000 Administrator Staff Member

    54,110
    12,179
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,739
    Local Time:
    6:09 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Looks okay as far as I can see
     
  11. Oct 14, 2014 #11
    pamamolf

    pamamolf Premium Member Premium Member

    4,074
    427
    83
    May 31, 2014
    Ratings:
    +833
    Local Time:
    10:09 AM
    Nginx-1.25.x
    MariaDB 10.3.x
    What is this fix for?
     
  12. Oct 15, 2014 #12
    eva2000

    eva2000 Administrator Staff Member

    54,110
    12,179
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,739
    Local Time:
    6:09 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
Previous Thread Next Thread
Loading...

.