Erric Rapsing reke592

MySql Display lock status

SELECT thread_id, object_name, lock_type, lock_mode, lock_data, index_name, lock_status FROM performance_schema.data_locks;

SSL Check public and private key if match

openssl x509 -noout -modulus -in certificate.crt | openssl md5
openssl rsa -noout -modulus -in private.key | openssl md5
openssl req -noout -modulus -in request.csr | openssl md5

Moved to git repository: https://github.com/denji/nginx-tuning

NGINX Tuning For Best Performance

For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx.

Generally, properly configured nginx can handle up to 400K to 500K requests per second (clustered), most what i saw is 50K to 80K (non-clustered) requests per second and 30% CPU load, course, this was 2 x Intel Xeon with HyperThreading enabled, but it can work without problem on slower machines.

You must understand that this config is used in testing environment and not in production so you will need to find a way to implement most of those features best possible for your servers.

	FROM mysql:8.0.15

	RUN echo "deb http://archive.debian.org/debian stretch main" > /etc/apt/sources.list && \
	apt-get update && \
	apt-get install -y libgoogle-perftools-dev

	# ENV LD_PRELOAD=/usr/lib/libtcmalloc.so.4

	@echo Off
	REM requirements:
	REM This Nginx build for windows, available at http://nginx-win.ecsds.eu/download/
	REM this build has fixed issues related to the 1024 worker_connection limit.
	REM rar.exe - for archive, replace this if you don't want rar.exe

	REM Current installation directory of nginx
	pushd c:\nginx

	REM Log folder name

	import 'package:flutter/material.dart';
	import 'package:animations/animations.dart';
	import 'package:sample/widgets/app_loading_indicator.dart';
	import 'package:pointer_interceptor/pointer_interceptor.dart';

	class ModalPrompt {
	static Future<R?> showProcessing<R>({
	required context,
	required String message,
	required Future<R> Function() process,

	import 'dart:async';

	class Debouncer {
	final Duration duration;
	Timer? debouncer;

	/// cancel previous action if recur within debounce duration
	Debouncer({
	this.duration = const Duration(milliseconds: 200)
	});

	const request = require('supertest');
	const { app } = require('../server');

	describe('Form input options', () => {

	it('GET /option/regions --> array public list regions', () => {
	return request(app)
	.get('/option/regions')
	.expect('Content-Type', /json/)
	.expect(200)

	@echo off
	REM this file is being called by apache via pipe in rotatelogs.exe
	REM adjustments to be made in apache httpd.conf (search for log_config_module)
	REM to rotate the logs every midnight
	REM CustomLog "\|bin/rotatelogs.exe -p c:/<path to this dir>/rarlogs.bat -l c:/<path to client>/logs/access-%Y-%m-%d.log 86400" common
	REM rotate when reached 100Mb limit
	REM CustomLog "\|bin/rotatelogs.exe -p c:/<path to this dir>/rarlogs.bat -l c:/<path to client>/logs/access-%Y-%m-%d-%H_%M.log 100M" common

	REM %1 new .log, %2 old .log
	set compress=1

	/** Sample usage:
	*
	* let _encrypt, _decrypt, _createIV;
	*
	* repo.useEncryption = async (encryption) => {
	* if (!toString.call(_encrypt).match(/Function/)
	* && !toString.call(_decrypt).match(/Function/)) {
	* let config = encryption.configure([
	* 'first_name',
	* 'last_name',

	-- Disclaimer: not a standard rule. just a collection of ideas/experience while doing a fullstack development task --

	identify the configurations that can affect the application restart, put those dynamic configuration in database. (eg. email config).
	create server.js (exports app and start function), and index.js (imports start function), so we can use the server.app for unit testing with supertest.
	identify the common functions and store them inside `commons` folder.
	create commons/errors to contain all the possible application errors we can throw, include the http status code.
	[frontend]
	eg. /commons
	'-- debouncer.dart
	'-- errors.dart