Database Administrator

It is unknown that the connection has expired. If a Client requests a connection, providing the Connection to the Client will cause the above exception. 8 hours in idle status.;Set global wait_timeout =; Mysql> show variables like '% timeout % ';+ -

[Mysqld]Port = 3306# Set the installation directory of mysqlBasedir = D: \ mysql-5.6.14-win32# Set the data storage directory of the mysql database, which must be dataDatadir = D: \ mysql-5.6.14-win32 \ data# Innodb_log_arch_dir default datadir#

In the database class, I started with SQL and talked about create table and constraints. I gave them a question on the tiger bar, it is a puzzle found from the famous SQL Puzzles and Answers. The Answers in the original book are actually

I. Introduction My discussions on Database indexes have never been removed. What is the database index? What is the difference between clustered index and non-clustered index? I hope this article will help you. I sincerely hope that you will give me

In the management of DB2, you may need to modify the Host Name of the DB2 database server. I will instruct you to modify the Host Name of the DB2 server. Product: DB2 UDB Platform: AIX, Solaris, HP-UX, Linux, Windows Version: V8 V9.1V9.5 To modify

Data import and export will be used when SQL Server programming or management is involved. There are many ways to import and export data, which can be summarized based on my experiences in Project Creation: 1. SQL Server Import and Export wizard.

MSSQL has launched the image function since 2005. The SQL Server image is unreadable. The entire database is in the norecovery mode. SQL Server images can only be 1-to-1 images, but images and logshipping can be used to achieve one-to-many and image

This is a summary of Oracle two years ago. It is nothing new. It is only a personal record and you are welcome to study and discuss it together. The restoration process of Oracle Database media is relatively complex. After all, as a large system,

This post provides two methods to avoid the exception or long blocking caused by the client-side program, and allow users to wait indefinitely, the connection pooling connections even exceed the capacity. A few days ago, the company's server-side

In the previous article "Connecting MySQL and other databases with C ++", the author introduced the first method of connecting C ++ to MySQL and other databases-connecting MySQL databases through ADO, this method connects to different databases by

Paging of database data on the UI is a common issue. It is easy to find various "General stored procedure" codes on the Internet, and some custom query conditions make it easy to use. I plan to use this article to briefly discuss the paging stored

Common methods for extracting DDL commands from objects such as database tables, indexes, constraints, and triggers include extracting metadata from these objects ), and store the data in the memory. Although many scripts can implement such

When upgrading ORACLE databases from 8i to 9i and above, it is generally considered that the original PLSQL program should be fully compatible, that is, the running process and the running result are completely consistent. Unfortunately, this is not

Data security refers to protecting data to prevent illegal use and avoid intentional or unintentional loss, leakage or destruction of data. Because the database system stores a large amount of data in a centralized manner and the data is shared by

Links to related articles:Manage business requirements in multiple database environments) 4. Impact of Business Management on IT The challenges facing IT-driven business development must be addressed in four basic contradictions. Contradictions in

Oracle, as a large database, is widely used in financial, post and telecommunications, power, civil aviation, and other important sectors with a large data throughput and a wide spread of computer networks. For system administrators, it is

As the market and business models continue to refine and the system functions are increasingly enhanced, application operations will generate more production data than ever before, and enterprises will also need to analyze historical data, this will

We tested the performance of Mongodb's hundreds of millions of data records and tested the following items:  All inserts are performed in a single thread, and all reads are performed in multiple threads) 1) normal insertion performance: Each

Reading: deduplicationThe emergence of technology has a certain source, so we should start from the beginning. Although the current price of storage media has plummeted, the Unit storage cost is already very low. But it still cannot keep up with the

BKJIA Summary: in the previous article, we saw the performance optimization of the DB2 utility. This time we will focus on the performance considerations for the DB2 concurrent connection. In general, when the number of connections is small, the