Database Administrator

SQL Server execution plan cache (1) Overview Understanding the execution plan is very important for database performance analysis. It involves statement Performance Analysis and storage. This is also the purpose of writing this article. Before

Optimization of MySQL in high memory and IO Utilization The following optimizations are based on some MySQL Optimizations in the CentOS system. We hope to continue to improve them if they are incomplete or controversial.I. mysql-level optimization 1.

Installation and configuration of EM in Oracle 10g and 11g I set up an Oracle environment locally. I first installed the database with EM. After the installation, I wanted to modify the listener port and replace the port 15521 with another one, as a

(18) partitions in mysql (after development), 18 mysql Overview Before getting started, I saw the partition, And I squeezed it. Yesterday, I finally learned what partitioning is, but that is also the case. Today, we can sum up that good memory is

ERROR 1010 (HY000): Error dropping database (can't rmdir '. \ test \', errno: 17), hy000errno Mysql5.5.40 has been deployed in the production system. Due to development requirements, dump the data in the production database and import it to the

Compiling bbed and 11.2.0.4bbed in Oracle db 11.2.0.4 in linux 6.3 From: http://blog.csdn.net/inthirties/article/details/5558030 Environment: Oracle db 11.2.0.4, rhel 6.3 x86-64bit The following files required for compiling bbed in 11.2.0.4

SQL Server clustered indexes are converted in functions and even fail (CASE ), During the latest phase I optimization, the first N most time-consuming statements in the database are queried! SELECT TOP 10 qp.query_plan,qt.text,total_worker_time

Solve the Problem of remote connection to the MySQL database.Problem description Out of interest, I have installed MySQL servers and clients on Windows and Ubuntu systems. There are some preparation information: Windows IP Address: 192.168.5.196

Catalyst Optimizer, catalystoptimizer For more information, see ChenZhongPu's Gitbook:Https://www.gitbook.com/book/chenzhongpu/bigdatanotes/details The Catalyst of Spark SQL is easy to expand. It also supports rule-based and cost-based optimization

ORA-02049: Timeout: Distributed Transaction Processing wait lock simulation, ora-02049 Transaction Processing I want to simulate this error and see what the problem is. Create a table on Database B:Create table TEST ( A number, B DATE ); Insert into

Xtrabackup stream backup and recovery, xtrabackup backup Xtrabackup is one of the most common tools for MySQL database backup. Provides full backup, Incremental backup, database-level, table-level backup, and so on. There is also a backup that is

Hibernate primary key generation policy and hibernate primary key policyThe sub-element in the ing file in hibernate is the name of a Java class, which is used to generate a unique identifier for the persistence class instance. If the generator

Database optimization tutorial (10) [excellent chapter] solve the four ways in which indexes are not used when like '% str', tuning % strIii. Index 7. Four methods to solve like '% str' without fuzzy query As mentioned above, the index will not be

V $ SESSION SQL _ID is blank. SQL _ID and sessionsql_id cannot be found Brother, have you ever encountered the embarrassment of querying V $ SESSION. SQL _ID but SQL _ID is null and cannot be found? Too many people have asked this question. I

SqlServer Bug: the extended stored procedure has been running and the waiting type PREEMPTIVE_ OS _GETPROCADDRESS appears, sqlserver Today, xp_readerrorlog is used to query a deadlock information on the new server for the first time, and the result

Xtrabackup automatic restore script and xtrabackup script Xtrabackup Automatic Restoration ************************************* **************************************** * ******************* application scenarios: ***********************************

Simple MySQL operations: Statement, PreparedStatement, (1) tool class for connecting to mysql: DBUtil. java Package com. xuliugen. util; import java. SQL. connection; import java. SQL. driverManager; import java. SQL. preparedStatement; import java.

Mysql encoding settings, mysql Encoding Mysql encoding settings MYSQL read 73 comments 1 font size: large, medium, smallMysql> show variables like 'character _ set _ % ';+ -------------------------- + ---------------------------- +| Variable_name |

[Translated from mos] restore a failed primary database to a physical standby database, Restore a failed primary database to the physical standby database Reference:Step by Step Guide on How To Reinstate Failed Primary Database into Physical Standby

Set the primary key. In general, int> Guid/string, guidstringSet the primary key. In general, int> Guid/string   Generally, setting int as the primary key is more