BenMorel

<?php

/**
 * Quick script to display InnoDB inserts/updates/deletes/reads per second in real time.
 *
 * Sample output:
 *
 * Inserts       40,368.63 /s
 * Updates           19.98 /s
 * Deletes            9.99 /s

BenMorel

<?php

/**
 * Solves the following equations:
 *
 * a·x + b·y = c
 * d·x + e·y = f
 *
 * Returns an array with [x, y]
 */

BenMorel

<?php

use Brick\DateTime\LocalDate;
use Brick\DateTime\LocalTime;
use Brick\DateTime\LocalDateTime;

/**
 * Formatter for date-time classes.
 */
class DateTimeFormatter

BenMorel

<?php

/**
 * Converts a string using CR, LF, CRLF, or possibly a mix of these, to the given EOL character(s).
 *
 * @param string $text The text to convert.
 * @param string $eol  The line break character(s).
 *
 * @return string
 */

BenMorel

password=$(grep -oP 'temporary password(.*): \K(\S+)' /var/log/mysqld.log)
mysqladmin --user=root --password="$password" password aaBB@@cc1122
mysql --user=root --password=aaBB@@cc1122 -e "UNINSTALL PLUGIN validate_password;"
mysqladmin --user=root --password="aaBB@@cc1122" password ""

BenMorel

<?php

/**
 * Benchmarks BulkInserter at various batch sizes.
 *
 * Before running this script, make sure to:
 *
 * - set your PDO parameters in this file
 * - run composer install
 * - import setup.sql into your database

BenMorel

<?php

$sock = socket_create(AF_INET, SOCK_DGRAM, SOL_UDP);
socket_bind($sock, '0.0.0.0', 10000);

for (;;) {
    socket_recvfrom($sock, $message, 1024, 0, $ip, $port);
    $reply = str_rot13($message);
    socket_sendto($sock, $reply, strlen($reply), 0, $ip, $port);
}

BenMorel

set -e

sudo yum update -y
sudo yum install -y yum-utils wget

# EPEL repo
sudo yum install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
sudo yum-config-manager --enable epel

# Remi repo

BenMorel

<?php

/* Replace with your connection parameters & database name */

$hostname = 'localhost';
$username = 'root';
$password = '';
$database = 'test';

$pdo = new PDO("mysql:host=$hostname", $username, $password);

BenMorel

<?php

/**
 * Converts a text message to HTML.
 *
 * The following transformations are applied:
 * - Special characters are encoded to HTML entities,
 * - Lines of text separated by an emtpy line are converted to paragraphs,
 * - Newline characters are converted to `<br>`,
 * - Links and e-mail addresses are converted to HTML links,