您好,登錄后才能下訂單哦!
Part 1. 分類
Stored Programs
- Stored Routines
- Procedure
- Function
- Event Scheduler
- Trigger
Part 2. 概要
另, 對(duì)于Event Scheduler和Trigger還各有一小點(diǎn), 要了解到.
Event Scheduler在MHA環(huán)境下, 手動(dòng)在線切換時(shí), 會(huì)有如下信息提示, 要暫將Event Scheduler關(guān)閉.
Wed Sep 13 10:55:43 2017 - [error][/usr/local/share/perl5/MHA/MasterRotate.pm, ln161] We should not start online master switch when one of connections are running long updates on the current master(192.168.19.168(192.168.19.168:3306)). Currently 1 update thread(s) are running.
Details:
{'Time' => '147223','Command' => 'Daemon','db' => undef,'Id' => '117223','Info' => undef,'User' => 'event_scheduler','State' => 'Waiting on empty queue','Host' => 'localhost'}
Wed Sep 13 10:55:43 2017 - [error][/usr/local/share/perl5/MHA/ManagerUtil.pm, ln177] Got ERROR: at /usr/local/bin/masterha_master_switch line 53.
Trigger不能建立在mysql數(shù)據(jù)庫上, 會(huì)有如下報(bào)錯(cuò).
ERROR 1465 (HY000): Triggers can not be created on system tables
若感興趣可關(guān)注訂閱號(hào)”數(shù)據(jù)庫最佳實(shí)踐”(DBBestPractice).
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。