mysqlboy

Schema Change

Review:

Dimensions of table to be altered:

+------------------+----------+----------+--------------+
| tbl              | Size_MB  | rows_mil | data_free_MB |
+------------------+----------+----------+--------------+
| cheateo.bot_logs | 56741.95 |  25.4484 |      1255.00 |

mysqlboy

-- top 10
SELECT
	CONCAT(table_schema,'.',table_name) AS `tbl`,
	round(((data_length + index_length) / POW(1024,2)), 2) `Size_MB`
FROM
	information_schema.TABLES
ORDER BY
	(data_length + index_length)
	DESC limit 10;

mysqlboy

# Start netcat on port 9999 on joiner
nc -l -p 9999 | xbstream -x -C .

# Start the backup from donor
innobackupex \
--compress \
--compress-threads=4 \
--parallel=4 \
--stream=xbstream . \
| nc  9999

mysqlboy

Mon Jun 11 11:47:30 UTC 2018

mysqlboy

Keybase proof

I hereby claim:

• I am mysqlboy on github.
• I am eroomydna (https://keybase.io/eroomydna) on keybase.
• I have a public key ASBjJVvfnvo6eKSfSAeBILQKgXT1aDQNiIl7GUECJbvHWwo

To claim this, I am signing this object:

mysqlboy

<AUDIT_RECORD>
  <NAME>Query</NAME>
  <RECORD>742037377_2014-05-09T14:25:53</RECORD>
  <TIMESTAMP>2014-05-09T14:27:41 UTC</TIMESTAMP>
  <COMMAND_CLASS>show_variables</COMMAND_CLASS>
  <CONNECTION_ID>3</CONNECTION_ID>
  <STATUS>0</STATUS>
  <SQLTEXT>show global variables like 'audit%'</SQLTEXT>
  <USER>root[root] @ localhost []</USER>
  <HOST>localhost</HOST>