Database Administrator

We all know that the database files of the advanced version cannot be restored or appended to the lower version, because the format of the files of the higher version and the lower version is different. If you try to append or restore a database of

Reference: http://www.360doc.com/content/12/0403/01/9623234_200390473.shtml You can use the RMANDUPLICATE command to create a DuplicateDatabase Based on the backup of the target database (TargetDatabase) while retaining the target database ). This

Mysqlslap is a benchmark testing tool that comes with benchmark after MySQL5.1. This tool can simulate multiple clients simultaneously and concurrently send query updates to the server, the performance test data is provided and the Performance

MySQL 5.6 brings us the memcached fof innodb api. The main advantage is that we can read and write the MEMCACHED plug-in through the most familiar SQL statements.I will not introduce installation and configuration. If necessary, visit the official

New project accepted, master-slave database replication synchronization Error, Error Code 1292 invalid datatype) Error SQL: update wave set IS_WAVED = 0, LEVEL = 1, SOURCE_TB_NAME = null, SOURCE_ID = null, UPDATE_TIME = '2017-03-10 02:13:36. 0

650) this. width = 650; "border =" 0 "alt =" "src =" http://www.bkjia.com/uploads/allimg/131228/225U043W-0.jpg "/> Below 650) this. width = 650; "border =" 0 "alt =" "src =" http://www.bkjia.com/uploads/allimg/131228/225U05603-1.jpg "/> The method

With the GA of MySQL 5.6, MySQL becomes more and more beautiful in some details. Today, we are going to experience two security verification improvements. 1. mysql_config_edit tool. It can be used to encrypt users' passwords and enhance database

A basic principle for massive data performance optimization is "Partitioning"Also called "sharding). Partitioning is actually the principle of drawer in daily work and life: we put our items into multiple small drawers according to some logic, which

First, popularize the basic knowledge here: In earlier versions, online table modification, for example, adding a field, works as follows: 1. create table tmp like t1 to create a temporary table) 2. insert into tmp select * from t1 copy the original

Obtain the number of rows in each subpartition of a specified partition table in batches! Otherwise, manual query is too troublesome! --- View the number of rows in each sub-partition of the specified partition table Create or replace procedure

1) system table: stores all SQL system information. Stores metadata related to database services. The so-called Metadata refers to user databases on the data server, logon accounts on the database server, and tables in the database, which fields are

I mainly tried several REPLICATION tools. For other information, see the manual. Let's talk about my environment: MASTER: 192.168.1.131 SLAVE: 192.168.1.132, 192.168.1.133 ALL three databases have ALL external users. The configuration files are as

I.Database Lifecycle The database lifecycle can be roughly divided into several stages based on the software lifecycle and project development. 650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131228/22462324P-0.png "title ="

Recently, the test platform that took over a new project adopts the spring transaction mechanism. During User Authentication logon, the system always prompts authentication timeout. When the user checks the logs of the corresponding application

I. Scenario Description Database Version: 11.2.0.1 64bit active partition uard Operating system version: centos 5.8 64bit In the morning, the database routinely checks and finds that the undo tablespace data file is too large. After querying the

1. Permission related: 1. ModifySQL security SQL code Alter procedure www SQL SECURITY INVOKER; Alter procedure www SQL SECURITY DEFINER; 1) the MySQL Stored Procedure specifies the actual user who executes the stored procedure by specifying the SQL

I used to think that key range locking only exists at the serialization isolation level, but the Read-Committed isolation level also exists in a forum post: 59: 50. spid24s process id = process6463b88 taskpriority = 0 logused = 480 waitresource =

When I completed the student management system, I found that to use this software, the database data source must be configured. So I want to get a version that is out of the data source. Constructor: 650) this. width = 650; "src ="

One afternoon, the development report said that when the DML operation was executed, the database reported an error where the transaction log was full. The details are as follows: $ Db2 delete from tzsdb01DB21034E this command is processed as an SQL

1. The web server suddenly keeps RESTART. When querying LOGS, an error is reported when the web server calls an API; 2. Check the API. DWON is finished. Restart the API to restore it; 3. Check the api logs and find MYSQL exceptions; 4. top, found