Database Administrator

I was entrusted by my friends these two days and asked me to help him write a User Authentication System Using the MySQL database. Of course, I had to spend one night off and write a very simple PHP program. It may be too simple and prone to errors

Introduction to IntroductionThe new MySQL 5.0 feature tutorial is intended for old MySQL users who need to know the new features of MySQL 5.0. Simply put, I introduced the "Stored Procedure, trigger, view, and Information Architecture View". I would

Basic Requirements1. master the basic concepts of computer systems and software, basic knowledge of computer networks and application knowledge, and basic concepts of information security.2. master the basic knowledge of data structures and

It took me a lot of effort to run mysql in these two systemsTo sum upAfter running mysqld_safe, check the logs in/var/log/mysql. log.If there is no specific error information in the logYou can modify the log records in the my. cnf file and add the #

Recently I encountered a very troublesome problem. I used the company software to view the backup data.The Oracle version is 9204, and the corresponding backup version is available now. Use the company's products to open the backup data. because the

(1) data filesEach Oracle database has one or more physical data files ). A database data file contains all the database data. Data in logical database structures (such as tables and indexes) is physically stored in database data files. Data Files

Using MYSQL for database backup has a very regular database backup method, which has the same concept as other database servers, but have you ever thought about it, mySQL will have a simpler backup method using the file directory, and it will be

I. CREATE TABLE Method Full table replication # create table new table select * from old table;Structure replication # create table new table select * from old table where 1 <> 1; Ii. insert into Method Get the table creation statement # show

Since Oracle10g, Oracle has greatly enhanced the OEM tools and provided a full display of EM tools on the server side. In Oracle10g, the client can call powerful EM tools without installing any Oracle client tools. On the Server side, run the

I. Basic installation $ Tar zxvf mysql-3.23.58.tar.gz $ Mysql-3.23.58 cd $./Configure -- prefix =/usr/local/mysql -- sysconfdir =/etc -- localstatedir =/var/lib/mysql $ Make $ Make install # Prefix =/usr/local/mysql target directory for mysql

There are three ways to access the Oracle database: the first is to directly access the shared memory of the database instance by the application process, and the second is to access the database on the local machine through the beq protocol, the

In Linux/Unix, apart from calling SQL, calling PL/SQL is also a common situation for DBA. The following mainly uses some examples to show how to call pl/SQL under shell. Other related references: Linux/Unix shell scripts call SQL and RMAN

MySQL Import and Export Database Files Method 1: To use a graphical auxiliary tool, you first need to install MySQL GUI Tools v5.0. It is a visual interface of the MySQL database management console and provides four very useful graphical

Note: MySQL supports unidirectional and asynchronous replication. One server acts as the master server during the replication process, and one or more other servers act as slave servers. The master server writes updates to the binary log file and

In Oracle 11g, full table scan may use direct path read to bypass the buffer cache. Such full table scan is physical read. In 10 Gbit/s, it is read through gc buffer, so there is no direct path read problem. High direct path read may be caused: 1. A

Customer server environment: rhel-server-5.4-x86_64 + Oracle10g Remote Backup server Environment: windows server 2008 Network Environment: the server is deployed on the Internet, and the remote backup server is deployed on the Intranet (the server

Generate execution plan After a valid statement is executed, at least one execution plan is generated in the memory, which can be queried from the view v $ SQL _plan. Each execution plan has a cursor. The CHILD_NUMBER (that is, the CHILD_NUMBER in v

1. Configure the environment;MGM: 192.168.0.31NDBD1: 192.168.0.32NDBD2: 192168.0.33SQL1: 192.168.0.34SQL2: 192.168.0.30  2. Software Installation(1) Management node MGMFirst, create a configuration file for the management node at an appropriate

Redis persistence introduction: Redis is a memory database that supports persistence. That is to say, redis often needs to synchronize data in the memory to the disk to ensure persistence. Redis supports two persistence Methods: Snapshotting

Oracle does not have the primary key auto increment function. You need to whitelist the sequences and triggers to automatically increase the primary key. Example: Create a Table menu: Create table menu (menuId number (10) not null primary key,Name