Database Administrator

I. Environment OS: CentOS release 5.8 (64-bit) DB: MySQL5.5.17 Ii. Operations Run the rm-f command to delete the slow query log. Iii. Problems The slow query log is not automatically generated. (if there is a backup, it is difficult to copy it

Environment configuration of PDO: enable support for PDO in php. enable extension = php_pdo.dllextension = php_pdo_mysql.dll in the ini configuration file. classes involved in the PDO operation: PDO, PDOStatement (preprocessing object), PDOException

Create table mytest (name varchar (20), password varchar (30 ));Create or replace procedure sp_pro2 isBeginInsert into mytest values ('fc ', '123 ');End;View error informationShow errorHow to call this process:1. exec process name (parameter ,..)2.

Action Before doing so, I hope you can take a look at the above learning resources and learn about the basic operations. Initial account password for Data Connection Account: admin Password: admin  First, create a file: mongodb. php, set the account

The popularity of big data makes many people want to develop in this direction and do some work such as data mining and data analysis. But where should I start? How can we quickly learn useful knowledge and skills? I think there are three entry

1. An error is reported when ORACLE software is installed to 86%. The figure is missing. The log is as follows: /Oracle/u01/app/oracle/product/11.2.0/INFO: db_1/lib/sysliblist '-R/opt/SUNWcluster/lib-R/export/home/oracle/u01/app/oracle/product/11.2.0

There is no separate Boolean Storage Class in the sqlite database. The Booean value is stored as 0 (false) and 1 (true). After my short-term test, it is shown that there are three statuses of boolean, 0 (false) 1 (true) and null, as shown in, The

Transactions and locks in SQL Server   Transactions are all about atomicity. The concept of atomicity refers to the ability to treat things as a unit. From the database perspective, it refers to the minimum combination of one or more statements that

Top:Top-16:41:04 up 184 days, 2 users, load average: 19.97, 18.38, 18.36Task: 584 total, 1 running, 583 sleeping, 0 stopped, 0 zombieCpu (s): 0.0% us, 0.0% sy, 41.2% ni, 58.7% id, 0.0% wa, 0.0% hi, 0.0% si, 0.0% stMem: 65923008 k total, 34622724 k

Grouping sets, CUBE, and ROLLUP in SQL SERVERPrefaceIn the full text, we will use a CTE statement as the basic data: With testas (select N 'leewhoeeunisersity 'as name, n' database' as category, 30 as totalcount union all select N

I. Basics 1. Description: Create a database CREATE DATABASE database-name 2. Description: delete a database. DROP DATABASE database-name 3. Description: Back up the database USE master -- create deviceEXEC sp_addumpdevice 'disk', 'CC _ jz',

MySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limit. Here are 100 tips for adjusting and optimizing MySQL installation. Some tips are applicable to specific

First, we should clarify the differences between partition tables and table partitions: Table partitions are an idea, and partition represents a technical implementation. When the table size exceeds G, you can consider Table Partitioning to improve

I plan to write a series of articles about how to use the sesame database. This is the second article. For the first article, see here to explain how to build the sesame database. There are many methods for adding triple triples to the Sesame

Reprinted please indicate the source: http://blog.csdn.net/jmppok/article/details/18085181 Redis is a memory-type key-value database that provides extremely fast access and is easy to use and supports multiple languages. This article provides a

The database uses db2, which has two tables: Check table (STUDY_TBL) and filter table (SELECTION_TBL) ======================================== The description of STUDY_TBL is roughly as follows: STUDY_LID integer primary key, STUDY_DATE

First, let's talk about ms server. Because I am a newbie, I first chose to use the Enterprise Manager for task settings and then export the designed task script, in this way, you can directly execute scripts in other databases to create a task (you

Left Join/Right Join/inner joinA summary of left and right connections:The left join where only affects the right table, and the right join where only affects the left table.Left JoinSelect * from tbl1 Left Join tbl2 where tbl1.ID = tbl2.IDThe

The sequence starts from 0 every morning after the Oracle stored procedure is updated. Create a stored procedure for Oracle first; For example, clearing a table Create or replace procedure pro_job_delete As Begin -- Dbms_output.put_line ('System

Progressive rehash In the previous section, we learned about the dictionary rehash process. In particular, the rehash program is not activated. After that, execute the task immediately until it is completed. Instead, it is completed multiple times