Skip to content

Instantly share code, notes, and snippets.

View uhlhosting's full-sized avatar
🏠
Working from home

Viorel-Cosmin Miron uhlhosting

🏠
Working from home
View GitHub Profile
[mysqld]
innodb_read_io_threads = 2
innodb_write_io_threads = 4
innodb_buffer_pool_size = 1G
innodb_buffer_pool_load_abort =ON
#innodb_buffer_pool_load_at_startup =1
#innodb_buffer_pool_dump_at_shutdown =1
innodb_buffer_pool_instances = 1
innodb_log_file_size = 256M
innodb_log_files_in_group = 2
root@panel [/]# bash engintron.sh install
**************************************
* Installing Engintron *
**************************************
--2016-02-09 17:20:58-- https://github.com/nuevvo/engintron/archive/master.zip
Resolving github.com (github.com)... 192.30.252.131
Connecting to github.com (github.com)|192.30.252.131|:443... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: https://github.com/engintron/engintron/archive/master.zip [following]
--2016-02-09 17:20:58-- https://github.com/engintron/engintron/archive/master.zip
Aborted clientsDocumentation 10 The number of connections that were aborted because the client died without closing the connection properly.
Aborted connectsDocumentation 1 The number of failed attempts to connect to the MySQL server.
Created tmp disk tablesDocumentation 2.8 k The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.
Handler read rndDocumentation 186.5 k The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
Handler read rnd nextDocumentation 10.7 M The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans.
Reading mysql slow query log from /var/log/mariadb/slow_query.log
Count: 52305 Time=0.09s (4678s) Lock=0.00s (3s) Rows_sent=664.9 (34778098), Rows_examined=156717.0 (8197080631), Rows_affected=0.0 (0), 11users@localhost
SELECT option_name, option_value FROM wp_options WHERE autoload = 'S'
Count: 27639 Time=0.02s (422s) Lock=0.00s (1s) Rows_sent=3503.8 (96841712), Rows_examined=4278.0 (118238764), Rows_affected=0.0 (0), 2users@localhost
SELECT
st.value AS tra,
s.value AS org,
s.domain_name_context_md5 AS ctx
FROM wp_icl_strings s
@uhlhosting
uhlhosting / bots.py
Created February 3, 2016 20:50 — forked from edsu/bots.py
see what your bot traffic is like
#!/usr/bin/env python
"""
Hack to look for user agent strings in typical Apache style log and
count up the number of requests by bots vs non-bots. The list of bot
user agents comes from http://www.user-agents.org/ but has had some
agents added to it, since the user-agents.org list is pretty out of date, e.g.
no Bing?!
"""
MariaDB [(none)]> SHOW GLOBAL VARIABLES;
+--------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value
root@panel [/boot]# ls
./ initramfs-3.10.0-327.4.4.el7.x86_64kdump.img System.map-3.10.0-327.4.5.el7.x86_64.debug
../ initramfs-3.10.0-327.4.5.el7.x86_64.debug.img vmlinuz-0-rescue-55a560fbc9e2604f899cee05aeacc7fb*
config-3.10.0-327.4.4.el7.x86_64 initramfs-3.10.0-327.4.5.el7.x86_64.img vmlinuz-3.10.0-327.4.4.el7.x86_64*
config-3.10.0-327.4.5.el7.x86_64 initrd-plymouth.img .vmlinuz-3.10.0-327.4.4.el7.x86_64.hmac
config-3.10.0-327.4.5.el7.x86_64.debug symvers-3.10.0-327.4.4.el7.x86_64.gz vmlinuz-3.10.0-327.4.5.el7.x86_64*
grub/ symvers-3.10.0-327.4.5.el7.x86_64.debug.gz vmlinuz-3.10.0-327.4.5.el7.x86_64.debug*
grub2/ symvers-3.10.0-327.4.5.el7.x86_64.gz .vmlinuz-3.10.0-327.4.5.el7.
@uhlhosting
uhlhosting / my.cnf
Created January 31, 2016 19:11 — forked from fevangelou/my.cnf
Optimized MySQL configuration
# Optimized MySQL configuration by Fotis Evangelou - Updated Jan 2016
#
# The settings provided below are a starting point for a 4GB-8GB RAM server with 4 CPU cores.
# If you have less or more resources available you MUST adjust accordingly to save CPU, RAM and disk I/O usage.
# To fine tune these settings for your system, use MySQL DB diagnostics tools like:
# https://launchpad.net/mysql-tuning-primer
# or
# http://blog.mysqltuner.com/download/
# Note that if there is no comment beside a setting, then you don't need to adjust it.
@uhlhosting
uhlhosting / default.vcl
Created January 30, 2016 03:35 — forked from fevangelou/default.vcl_PREFACE.md
The perfect Varnish configuration for Joomla (& other CMS based) websites
#################################################################################
### The perfect Varnish configuration for Joomla (& other CMS based) websites ###
#################################################################################
# USE: Place the contents of this configuration inside the main
# Varnish configuration file, located in: /etc/varnish/default.vcl (root server access required - obviously)
# IMPORTANT: The following setup assumes a 2 minute cache time. You can safely increase
# this to 5 mins for less busier sites or drop it to 1 min or even 30s for high traffic sites.
@uhlhosting
uhlhosting / chpass.sh
Created January 20, 2016 23:53
Change password for all cpanel users
ls -1 /var/cpanel/users | while read user; do
pass=`</dev/urandom tr -dc "A-Za-z0-9*-/+.*=_\|\\#" | head -c16`
echo "$user $pass" >> passwords.txt
/scripts/realchpass $user $pass
/scripts/ftpupdate
done