davidkarban

- hosts: all:!freebsd
  remote_user: root
  gather_facts: false
  tasks:
    - name: Zajisti, ze mame python
      raw: dnf install python3 -y
      when: 
        - inventory_hostname != "serverc"
      register: result
      changed_when: "'Nothing to do.' not in result.stdout"

davidkarban

Query Planner

Engine Independent Table statistics: https://mariadb.com/kb/en/library/engine-independent-table-statistics/

Database design

Table schema

MySQL schema worst practices: https://docs.google.com/presentation/d/1q7e8wE5wz4aOglXhFjm1tndytWhwB3k9KqM3HQhwuMc/edit?usp=sharing

Indexes

Optimizer hints: https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html

davidkarban

autocmd BufRead *.yaml,*.yml 
        \ setlocal syntax=yaml autoindent
                \ sw=4 ts=8 sts=4 expandtab
                \ colorcolumn=78,120 

davidkarban

HW + OS tuning

Disks

• Fsync performance: https://www.percona.com/blog/2018/02/08/fsync-performance-storage-devices/

STORAGE

• ZFS performance tuning: http://open-zfs.org/wiki/Performance_tuning#MySQL
• HW RAID configuration: https://www.percona.com/blog/2011/06/09/aligning-io-on-a-hard-disk-raid-the-theory/

Memory, connections, threads

davidkarban

Pre flight check

Putty: https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html

Installation

Load test database

apt install git