温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

MySQL Stored Programs Summary

发布时间:2020-07-18 18:23:33 来源:网络 阅读:911 作者:coveringindex 栏目:MySQL数据库

Part 1. 分类

Stored Programs

  - Stored Routines

     - Procedure

     - Function


  - Event Scheduler  


  - Trigger


Part 2. 概要

MySQL Stored Programs Summary

MySQL Stored Programs Summary

MySQL Stored Programs Summary

MySQL Stored Programs Summary


另, 对于Event Scheduler和Trigger还各有一小点, 要了解到.


Event Scheduler在MHA环境下, 手动在线切换时, 会有如下信息提示, 要暂将Event Scheduler关闭.

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数据库上, 会有如下报错.

ERROR 1465 (HY000): Triggers can not be created on system tables


若感兴趣可关注订阅号”数据库最佳实践”(DBBestPractice).MySQL Stored Programs Summary

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI