![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Database
文章平均质量分 93
xang
这个作者很懒,什么都没留下…
展开
-
MySQL - Show status
The SHOW STATUS command allows you to view a snapshot of the many (over 120) internal status counters that MySQL maintains. These counters track particular events in MySQL. A.1.1 Thread and C...原创 2008-08-18 00:26:59 · 221 阅读 · 0 评论 -
Install Mysql
shell> groupadd mysqlshell> useradd -g mysql mysqlshell> tar zxf mysql-VERSION.tar.gzshell> cd mysql-VERSIONshell> ./configure --prefix=/usr/local/mysqlshell> makeshell>...2008-10-19 14:42:30 · 60 阅读 · 0 评论 -
Installation - MySQL (with embedded server)
Downloads install package: mysql-5.1.24-rc.tar.tar# Add user/group for MySQL> groupadd mysql> useradd -g mysql mysql> tar zxf mysql-5.1.24-rc.tar.tar> cd mysql-5.1.24-rc# check, com...2008-05-05 14:46:58 · 108 阅读 · 0 评论 -
Concurrent Access and Locking
1. A proper locking mechanism is necessary to ensure data consistency when there is a possibility of multiple clients accessing and possibly modifying the same data at the same time.2. table-level loc...2008-05-12 08:00:50 · 100 阅读 · 0 评论 -
High-level view of MySQL modules
High-level view of MySQL modules 执行mysql命令后,MySQL 的初始化模块就从系统配置文件中读取系统参数和命令行参数,并按照参数来初始化整个系统,如申请并分配buffer,初始化全局变量,以及各种结构等。同时各个存储引擎也被启动,并进行各自的初始化工作。当整个系统初始化结束后,由连接管理模块接手。连接管理模块会启动处理客户端连接请求的监听程序,包括...2008-05-12 08:51:48 · 145 阅读 · 0 评论 -
Parser and Optimizer
The MySQL server receives queries in the SQL format. Once a query is received, it first needs to be parsed, which involves translating it from what is essentially a textual format into a combination o...2008-05-12 13:00:58 · 144 阅读 · 0 评论 -
MySQL Log Setting
MySQL Log SettingMySQL has the following logs:Log TypeDescriptionError LogProblems encountered starting, running, or stopping mysqldGeneral Query LogEstablished client connections a...2009-01-06 11:15:23 · 133 阅读 · 0 评论 -
Oracle - DBA
Enabling Remote HTTP Connection to the Database Database Home Page > Administration > Manage Http Access SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE); Starting Up the Database ...原创 2010-10-20 16:36:00 · 205 阅读 · 0 评论