网站建设资讯

NEWS

网站建设资讯

MySQLStoredProgramsSummary

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


网站栏目:MySQLStoredProgramsSummary
转载来源:http://njwzjz.com/article/pgccho.html