風和日麗 天氣晴

  # mysqlbinlog --base64-output=AUTO --verbose -R -h [CLOUD SQL IP] -u root -p mysql-bin.000199 > /tmp/binlog-dump-000199.sql MySQL 5.6 開始支援 GTID 需要搭配上面的參數才能將 binlog 解析出 SQL 參考來源： Show sql statements from mysql binlog (GTID)

Photo by  Kolleen Gladden 標準永久硬碟 Zonal standard PD 寫入 # hdparm -t --direct /dev/sdc Timing O_DIRECT disk reads: 378 MB in  3.01 seconds = 125.47 MB/sec Timing O_DIRECT disk reads: 380 MB in  3.00 seconds = 126.53 MB/sec Timing O_DIRECT disk reads: 380 MB in  3.00 seconds = 126.66 MB/sec 讀取 # hdparm -t /dev/sdc Timing buffered disk reads: 374 MB in  3.00 seconds = 124.54 MB/sec Timing buffered disk reads: 380 MB in  3.01 seconds = 126.09 MB/sec Timing buffered disk reads: 380 MB in  3.01 seconds = 126.14 MB/sec SSD永久硬碟 Zonal SSD PD 寫入 # hdparm -t --direct /dev/sda2 Timing O_DIRECT disk reads: 738 MB in  3.00 seconds = 245.72 MB/sec Timing O_DIRECT disk reads: 608 MB in  3.02 seconds = 201.53 MB/sec Timing O_DIRECT disk reads: 396 MB in  3.07 seconds = 128.95 MB/sec 讀取 # hdparm -t /dev/sda2 Timing buffered disk reads: 740 MB in  3.00 seconds = 246.42 MB/sec Timing buffered disk reads: 53...