youdidwhatwithtsql.com
youdidwhatwithtsql.com » Linux from Scratch
http://www.youdidwhatwithtsql.com/category/linux/linux-from-scratch
Archive for the ‘Linux from Scratch’ Category. Partitioning setup for Linux from Scratch in VirtualBox. Posted on July 28, 2015, 8:50 pm, by Rhys, under Linux. Read the rest of this entry ». Getting started with osquery on CentOS. Remove an id field from a mongoexport json document. RPM Query on multiple servers with Python and Fabric. Fork of Nagios custom dashboard. On Using sp rename with schemas. On Using sp rename with schemas. On mmo: Getting started. On mmo: Getting started.
youdidwhatwithtsql.com
youdidwhatwithtsql.com » fdisk
http://www.youdidwhatwithtsql.com/tag/fdisk
Posts Tagged ‘fdisk’. Partitioning setup for Linux from Scratch in VirtualBox. Posted on July 28, 2015, 8:50 pm, by Rhys, under Linux. I’ve finally taken the plunge and committed, to untarring and compiling, a bucket load of source code to complete Linux from Scratch. I’ll be documenting some of my setup here. I’m far from an expert, that’s why I’m doing this, but if you have any constructive criticism I’d be glad to hear it. I’m using […]. Read the rest of this entry ». Fork of Nagios custom dashboard.
youdidwhatwithtsql.com
youdidwhatwithtsql.com » Blog Archive » MariaDB Compound Statements Outside Stored Procedures
http://www.youdidwhatwithtsql.com/mariadb-compound-statements-stored-procedures/2107
MariaDB Compound Statements Outside Stored Procedures. Posted on June 25, 2015, 3:40 pm, by Rhys, under DBA. It’s always been a small annoyance that the MySQL. Flavour of SQL wouldn’t allow you to use if else logic or loops outside of a stored procedure or trigger. There were ways around this but it’s not as nice if you’re coming from TSQL. This is rectified in MariaDB from 10.1.1. ATOMIC /* SQL CODE HERE */. Here are a few examples;. Running on the default port.'. ITERATE LOOP WITH IF ELSE. On mmo: Gett...
youdidwhatwithtsql.com
youdidwhatwithtsql.com » Bash
http://www.youdidwhatwithtsql.com/category/bash
Archive for the ‘Bash’ Category. Laquo; Older Entries. Delete all but the most recent files in Bash. Posted on April 10, 2016, 12:59 pm, by Rhys, under Bash. I’ve been reviewing a few things I do and decided I need to be a bit smarter about managing backups. I currently purge by date only. Which is fine if everything is working and checked regularly. I wouldn’t want to return from a two week holiday to find my backups had been failing, nobody checked […]. Read the rest of this entry ». Posted on October ...
youdidwhatwithtsql.com
youdidwhatwithtsql.com » Linux From Scratch
http://www.youdidwhatwithtsql.com/tag/linux-from-scratch
Posts Tagged ‘Linux From Scratch’. Partitioning setup for Linux from Scratch in VirtualBox. Posted on July 28, 2015, 8:50 pm, by Rhys, under Linux. Read the rest of this entry ». Getting started with osquery on CentOS. Remove an id field from a mongoexport json document. RPM Query on multiple servers with Python and Fabric. Fork of Nagios custom dashboard. On Using sp rename with schemas. On Using sp rename with schemas. On mmo: Getting started. On mmo: Getting started. On Console input with Powershell.
youdidwhatwithtsql.com
youdidwhatwithtsql.com » DBA
http://www.youdidwhatwithtsql.com/category/dba
Archive for the ‘DBA’ Category. Laquo; Older Entries. MariaDB: subquery causes table scan. Posted on April 25, 2016, 6:15 pm, by Rhys, under DBA. I got asked today to look at some slow queries on a MariaDB 10 instance. Here are the anonymized results of the investigation I did into this and how I solved the issue… There were a bunch of queries, expected to run very fast, that were taking 10-15 seconds to execute. The queries were all […]. Read the rest of this entry ». Emo: Launch an elasticsearch cluster.
youdidwhatwithtsql.com
youdidwhatwithtsql.com » Linux
http://www.youdidwhatwithtsql.com/tag/linux
Posts Tagged ‘Linux’. Laquo; Older Entries. The blame game: Who deleted that file? Posted on February 2, 2017, 12:27 pm, by Rhys, under Bash. I’ve recently had an issue where a file was disappearing that I couldn’t explain. Without something to blame it on I search for a method to log change to file and quickly found audit. Audit is quite extensive and can capture a vast array of information. I’m only interested in monitoring a specific file here. This […]. Read the rest of this entry ». Posted on May 19...
youdidwhatwithtsql.com
youdidwhatwithtsql.com » Blog Archive » Partitioning setup for Linux from Scratch in VirtualBox
http://www.youdidwhatwithtsql.com/partitioning-setup-linux-scratch-virtualbox/2121
Partitioning setup for Linux from Scratch in VirtualBox. Posted on July 28, 2015, 8:50 pm, by Rhys, under Linux. I’ve finally taken the plunge and committed, to untarring and compiling, a bucket load of source code to complete Linux from Scratch. I’ll be documenting some of my setup here. I’m far from an expert, that’s why I’m doing this, but if you have any constructive criticism I’d be glad to hear it. I’m using VirtualBox. And an installation of CentOS. Add a VirtualBox HDD. Identify the new device.
youdidwhatwithtsql.com
youdidwhatwithtsql.com » MariaDB
http://www.youdidwhatwithtsql.com/category/mariadb-2
Archive for the ‘MariaDB’ Category. Laquo; Older Entries. MariaDB: subquery causes table scan. Posted on April 25, 2016, 6:15 pm, by Rhys, under DBA. I got asked today to look at some slow queries on a MariaDB 10 instance. Here are the anonymized results of the investigation I did into this and how I solved the issue… There were a bunch of queries, expected to run very fast, that were taking 10-15 seconds to execute. The queries were all […]. Read the rest of this entry ». Posted on June 12, 2015, 11:01 ...
youdidwhatwithtsql.com
youdidwhatwithtsql.com » Linux
http://www.youdidwhatwithtsql.com/category/linux
Archive for the ‘Linux’ Category. Laquo; Older Entries. The blame game: Who deleted that file? Posted on February 2, 2017, 12:27 pm, by Rhys, under Bash. Read the rest of this entry ». Getting started with osquery on CentOS. Posted on September 29, 2016, 6:20 pm, by Rhys, under Linux. Read the rest of this entry ». Emo: Launch an elasticsearch cluster. Posted on April 16, 2016, 5:34 pm, by Rhys, under DBA. I’m getting a bit more into elasticsearch and I’ve started up a github project to conta...I’v...