Database Administrator

C processing ing Large Memory Optimization This appendix provides information for Processing memory optimization with large page tables on the Linux operating system, using Hugepages. It contains the following topics: Overview of HugePages

This article introduces six useful MySQL SQL statements. Many may use PHP to implement these functions. 1. Calculate the number of years You figured out how old this person is on your birthday.

I 've been so busy recently that I haven't written a blog for three months. This requirement was met in the use of Mongo, but I think it is easier to put this requirement into traditional RDBMS. The requirement is as follows: assume that your

1. Export data First, describe your environment: Mac OS X 10.8.3, MySQL Community Server 5.6.10, and MySQL Workbench 5.2.47. I want to migrate the data in the local database to another machine, so I used the import/export function in Workbench to

Advantages of using Threadpool The thread proxy model can be used to create a thread in advance and maintain it using the threadpool technology of the operating system when the number of connections is known to be controllable. This reduces a lot of

Vulnerability version: MySQL AB MySQL Vulnerability description: Bugtraq id: 58511 CVE (CAN) ID: CVE-2013-1861 Oracle MySQL Server is a small relational database management system. MariaDB is a MySQL branch version using the Maria storage

Database movement is also a common phenomenon. After all, there are various reasons to force us to move. So how can we move faster? See the following. When using an Oracle database, data in the database is often moved from one database to another.

In some special circumstances, if you cannot connect to the X server due to the network or X configuration, or the host does not have X, you can install the database in silent mode, similarly, if large-scale deployment is required, Silent

Infobright claims that the data compression ratio is 10:1 to 40: 1. We have mentioned earlier that the compression of Infobright is based on the data type in the DP. The system automatically selects the compression algorithm and automatically

1. Current mainstream backup technologies Data backup: That is, the data is backed up, the data to be stored is copied directly, or the data is converted to an image and saved on the computer. Such as Ghost and other backup software, CD burning and

When you open the door, this article mainly answers three questions: Is there a more efficient paging Method for Access? Efficiency Test of existing Access with a large data volume of 0.1 million data records by PAGE What is the data Carrying

In order to establish a database with low redundancy and reasonable structure, certain rules must be followed when designing the database. In relational databases, such a rule is called a paradigm. The paradigm is a summary that meets a certain

Today, I encountered an uncertain problem. After the website is upgraded, a page cannot be accessed, and the message "Object Name" xxx "is invalid. The xxx table is not created on the server, so you can open "SQL query analyzer ": Export the SQL

Many technical friends are confused about the dual-master replication mode of the mysql database architecture. How can I accurately determine whether the mysqld service can provide services normally and whether the service can be automatically

In the current system, massive data has become a major problem for software engineers. Many people focus on programming and database structure optimization, and then build some indexes and views. But when programming and table structure reach the

Optimize specific applications with high resource consumption What is the first thing to do when a performance problem occurs? I have asked many colleagues about this question. Some people say that they should optimize problematic SQL statements

The first concern of people who use database replication is the performance consumption of the master server and backup server. I am also very worried about this. After checking for half a day, I basically did not find similar test instructions, I

Connect to MySQL: window --> show view --> other --> MyEclipse Database --> DB Browser in MyEclipse, for example:   Click DB Browser, and the View Interface will change. In the blank area of the DB Browser tab, right-click and choose New ..., That

One of the most common insert operations can be used to track the Innodb record format, because at the time of insertion, the system obtains a public mysql record format, and now it does not involve any storage engine, the record format is the same

For example, I have some news information, including these fields: News ID, news Name, news ShortIntro, news Detail, news PublishTime. Now I want to store it in the database, and then retrieve it from the database and put it in the GridView for