Database Administrator

Install MySQL on Redhat Linux On Linux, Mysql usually has three installation methods:Rpm InstallationGeneral Binary Package InstallationSource code installation packageThis article first introduces the RPM installation method. Here we will mainly

Oracle manages disk space and resources1. Recoverable space allocation 1.1 learn about recoverable space allocation Generally, we initiate a large database operation, such as creating a large table index. If the tablespace is insufficient, the

MySQL tmpdir Parameter Modification Today, I suddenly received an alert message saying that/the disk space usage exceeds the threshold. It was found that there were many abnormal SQL statements that could not be executed, resulting in continuous

Create an Oracle 12c user Oracle 12c accounts can be divided into public accounts and local users. A common account is created under CDB and can be used by all PDB users. A local account can only be created in PDB. Create a public userAlter session

SQL statement for querying Oracle table data by PAGE The SQL syntax for querying Oracle data by page is widely used on the Internet. This article is also a typical syntax for the author to search on the Internet. It is not my original one and is

Solution to MongoDB connection failure exceeding 1000 on CentOS6 Problem description: When the production environment finds that the CPU is running at full capacity, the number of connections to MongoDB cannot exceed 1000. Solution: 1. Check mongodb

ASM management-how to rename diskgroup The new diskgroup rename function is added in ASM 11.2.0.1. You can use the renamedg command to rename the created diskgroup. Before renaming, you must first dismount diskgroup. If the renamed diskgroup is

Notes for installing Oracle 11g RAC This article is only used to record some issues that occur during the installation of Oracle RAC at ordinary times. If you encounter minor issues, we will also add them.1. HAIP hosts file dual-inline Nic

Oracle Shared Server Configuration 1. Exclusive server (dedicatedserver) Each session is assigned a serverprocess independently. Resources occupied by the process are released only when the user disconnects. In most cases, sessions are idle, so

Install MySQL Binary Package for RedHat Linux Enterprise 6.4 Download MySQL and upload it to the server 1. Download the mysql binary installation package from the Mysql official website. Https://edelivery.Oracle.com/osdc/faces/SearchSoftware? _

MySQL InnoDB table-Basic BTree Data Structure MySQL InnoDB table is an index organization table. This should be the first thing that anyone who learns MySQL will learn. This means that the data in this table is stored in the primary key order, that

Mysql table fragmentation cleaning, Mysql fragmentation cleaning Mysql has recently declined in the production environment, and some SQL statements are also slow. First, check whether the slow query log is enabled.Show variables like 'slow _

The Virtual Machine ubuntu14 configures NFS server host win7 to mount hosts in the LAN, and ubuntu14win7 Host win7 system, the system contains the Virtual Machine ubuntu14, other hosts in the LAN are also win7 system, all need to enable the NFS

SQLite database tutorial on Linux platform (1)-Terminal Use, linuxsqliteSQLite database tutorial on Linux platform (1)-terminal usage SQLiteIt is a lightweight database, designed to be embedded, and is currently used in many embedded products, it

Use bash to read and write csv file data to one of the scripts of MySQL database, Zookeeper Scenario:There is a csv file containing student details of multiple departments. You need to insert the file content into a data table to ensure that

Mondiran creates a connection and mondiran creates a connection.The url used to create a connection using jdbc is in the following format: jdbc: mysql: // hostname: port/database? Key1 = value1 & key2 = value2, which must start with "jabc: mysql" in

Forcibly obtain the next value of the sequence/current value (oracle function), oracle Function Http://blog.csdn.net/qq525099302/article/details/47146393-For more information about how to use a function to obtain the sequence value, see here. --

Solution for slow SQL query caused by custom functions, function SQL During the report process, one report queries the exchange rate of the corresponding currency, and the exchange rate is in another table, the condition for querying the exchange

Common listening errors in ALERT logs 2: troubleshooting of ORA-3136 errors, alertora-3136This problem has recently been encountered in multiple large systems. Generally, it can be ignored if the client does not reflect exceptions.If you encounter

Install and use phpMyAdmin. Set up phpMyAdmin on CentOS and centosphpmyadmin in CentOS Required components: apachephpmysqlphpmyadminapache0.yum install httpd1. confirm the version $ httpd-v2. start apache $ sudo service httpd start