aiphee

"use strict";

define([], function () {
  "use strict";

  var exports = {};
  Object.defineProperty(exports, "__esModule", {
    value: true
  });

aiphee

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

aiphee

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

aiphee

<?php

namespace App\Shell;

use Cake\Console\Shell;
use Cake\Core\App;
use Cake\Core\Configure;
use Cake\Network\Http\Client;
use Cake\Utility\Hash;
use ZipArchive;

aiphee

<?php
//...
public function shutdownProcess()
    {
        $result =  parent::shutdownProcess();

        try {
            $this->savePerformance();
        } catch (\Throwable $e) {
            $this->log('Nepovedlo se uložit výkon', LogLevel::WARNING);

aiphee

<?php
namespace App\Command;

use App\Application;
use App\Model\Entity\I18n;
use App\Model\Table\I18nTable;
use Cake\Console\Arguments;
use Cake\Console\Command;
use Cake\Console\ConsoleIo;
use Cake\Core\Configure;

aiphee

<?php
namespace App\Controller\Admin;

use App\Application;
use App\Controller\AppController;
use App\Model\Entity\User;
use Cake\Filesystem\File;
use Cake\Filesystem\Folder;
use Cake\Http\Response;
use Cake\I18n\I18n;

aiphee

http {
  upstream webpack_hot_server {
    server 127.0.0.1:9821;
  }
}


location ~ /js/compiled/webpack_hot/.*\.(js|json)$ {
  # Pass these requests to upstream of `yarn dev-hot` (webpack dev server)
  proxy_pass http://webpack_hot_server;

aiphee

import React from 'react';

interface IProps {
  children: unknown;
}

/**
 * Takes node content and makes JSX element out of it (kind of like dangerouslySetInnerHTML)
 * Careful, always sanitize input!
 * credit @yairEO https://github.com/facebook/react/issues/12014#issuecomment-1621382570