Skip to content

Instantly share code, notes, and snippets.

View gwinans's full-sized avatar

Geoff W. gwinans

  • Primarily a DBA and an absolutely terrible developer.
  • Mesa, AZ
View GitHub Profile
@gwinans
gwinans / mdl_lock_summary.sql
Created September 21, 2023 17:01
mdl lock summary
DROP PROCEDURE IF EXISTS procShowMetadataLockSummary;
delimiter //
CREATE PROCEDURE procShowMetadataLockSummary()
BEGIN
DECLARE table_schema VARCHAR(64);
DECLARE table_name VARCHAR(64);
DECLARE id bigint;

Welcome to the /r/arizona Discord!

This is a place for creating community and belonging, and that happens best when we treat people with respect.

Most importantly ...

  • Post in #introduction for full access - Tell us your age or age range (must be 18+), your interests, and what city you’re in. A moderator will set your roles as soon as possible.

The Rules

  • Do NOT send friend requests or DMs to other users unless you have their express permission.
  • There is no tolerance here for racism, sexism, homophobia, transphobia, etc.
eNq9Wltz2kYUfk5_hUbvMazuykA72MYOMyahxknap8wiLaB6paXSCof--p6VhFFcMEebtsmMw-U797NnvyNn8Mu3lBtblheJyIYmueibBssiESfZamh-erh5G5i__PzTYEbl-uPysky4-ubnn94MqtcGZ1vGQc40JM1XTH7ea7K_gqYNzeSaiWxK_xD5rYiH5geRMdNY0CxO5P5dxGlRfKApG5rzCIRNgxYRy-Krw-c1MKVJNhfRI5O3uSg3ldltwp6mIgbMZDr7eP_QMppkbaPg85vBjNMdy-eSSqOAH0NzBKHTFbumKfwEbZSXoMq68EPL3_-1zd5x4fmGsfhZiFxY_x9wlrPxcskimWzZVZ7IqzXNokMA_VNyXbHTkstkwxOWt7xyT0m8_4fy0DuFfRCS8uvZ_BlqX9guOWT9v5ET8nzcXxK5vuRQCA0rSnayyhLJNIVnIilE9gPxtUVPl1akiyTTinAvOtquuopOaUavRIEowV2yZDjkeI7D3cP5xiGVlzOWwwSSeGc7Cczl4TRZpz1mf7aBJ3HX7BtOWxt4EjfJJE5bG_iKb1shq5GOSeIzyuu_MiCjdwo7ySKc0k9ZzgqWb1tz1UMKNEU9TL7-q4L3bMWQkd4xFq1v4Tq7p5LhWvIZ5b6eHIVFJUcBjyTHRQp0SI4SfJGci_A1cMf0jDOWr3bzdcJ4jDh9KkttEVS22gLIQrdFuka0pUX72LjB69HUcFzZGVxtIBCzF1e1FfyLIrNc_KHYCe8oN8pTUebIItZgVNSz9a5IIrggK6J3z-Iyws2lZ5Y1FVuWQsNXFA0Y56HxT4lecuCqWLIFajnvJDGSkkaP1yJesU5GOkncJDlkq0ha19pbD4H-CLz6im4wTESdJ6yBAxpt4C5ZrWUGSwveygsRfCxrKooOwRzgaBM3Jecohjd_TL5HSrrg7J3R_0bi0PP88PRREU_gzFqtcwXiYLXQU3ogGCeXppucZX_t0Pq_g6MMjLO4zFV3o228lPinmUGvWnfVq0m6
eNq9Wltz2kYUfk5_hUbvMaxW1wy0g23sMGMSapykfcos0gFUL1oqrXDor--uJIzigjls2iYzDpfv3M-e_Y6c3i_fVtzaQF6kIuvb5KJrW5DFIkmzRd_-9HDzNrR_-fmn3oTJ5cf5ZZly_c3PP73pVa8tDhvgSs62JMsXID_vNNGvStOaZXIJIhuzP0R-K5K-_UFkYFszliWp3L2LOSuKD2wFfXsaK2HbYkUMWXK1_7wGrliaTUX8CPI2F-W6MrtJ4WksEoUZjScf7x9aRtOsbVT5_KY34WwL-VQyaRXqR98eqNDZAq7ZSv1U2hgvlSrnIoicYPeX2p3DwtM1QPIsRC6c_w84yWE4n0Ms0w1c5am8WrIs3gfQPSZ3LnZccpmueQp5yyvvmMT7fyiP_GPYByEZv55Mn6H0gnpkn_X_Rk7I03F_SeXykqtCGFjRsqNFlkowFJ6ItBDZD8TXFj1eWrGapZlRhDvRwWZxruiYZexKFIgS3KVzwCGHUxzuXp1vHFJ7OYFcTSCJd_YsgancnybnuMfwZxt4FHcN33Da2sCjuFEmcdrawFd82whZjXRMEp9RfveVARm_09hRFuOUfspyKCDftOaqjxRoirqffN1XBe9hAchI7wDi5a26zu6ZBFxLPqO815OjsajkaOCB5HhIgTOSowVfJOcieg18ZnqGGeSL7XSZAk8Qp09nqS2CylZbAFnotsi5EW1Y0T42Xvh6NDUcV3ZQV5sSSODFVe2E_6LIJBd_aHbCz5Qb5CtR5sgi1mBU1JPltkhjdUFWRO8ekjLGzaVnljUWG1iphq8ommKc-8Y_JnrJFVfFki2llvOzJAZSsvjxWiQLOMvIWRI3aa6yVaSta-2tj0B_VLz6iq0xTESfJ6yBPRpt4C5dLGWmlha8lRci-FiWTBRnBLOHo03clJyjGN70Mf0eKdmMwzur-40Ebtyl5PhREU_KmaVe5wrEwWqhx2xPMI4uTTc5ZH9t0fq_g6MMDLOkzHV3o228lPinmV6nWnf1q9Fq
#!/usr/bin/php
<?php
$missing = <<<MISSING
Config file not found (/etc/inno_backup.conf)
Create a new file with the following keys/values:
user = backups
pass = password1234
@gwinans
gwinans / mysqld.log
Created July 19, 2016 16:14
Broken forklift -- 5.5.50 > 5.6.31
160719 09:05:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql/data
2016-07-19 09:05:47 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2016-07-19 09:05:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-07-19 09:05:47 0 [Note] /usr/sbin/mysqld (mysqld 5.6.31) starting as process 63750 ...
2016-07-19 09:05:47 63750 [Note] Plugin 'FEDERATED' is disabled.
2016-07-19 09:05:47 7f70474f8720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2016-07-19 09:05:47 63750 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-07-19 09:05:47 63750 [Note] InnoDB: The InnoDB memory heap is disabled
@gwinans
gwinans / hash.php
Created April 28, 2016 18:59
MySQL Password Hash Generator
<html>
<head>
<title>MySQL Password Hash Generator</title>
</head>
<body>
<?php
if ( isset($_POST['pass1']) AND isset($_POST['pass2']) ):
$pass = ($_POST['pass1'] === $_POST['pass2']) ? $_POST['pass1'] : FALSE;
if ( $pass === FALSE ):