Database Administrator

There are two ways to add a new function for MySQL:You can use the UDF to add functions. The custom FUNCTION is compiled as the target file, and then dynamically added to and removed from the server using the create function and drop function

I really want to write down my Oracle Installation Process as an accumulation of learning oracle + linux. Environment: VMmachine Version: Linux + oracle, Linux: Red Hat linux release 9 (Shrike), kernel 2.420-8 on an i686 Oracle: 9.2.0.4 1. Install

When using exp to export data in Linux: Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProductionWith the Partitioning, OLAP and Data Mining optionsThe ZHS16CGB231280 Character Set and AL16UTF16 NCHAR character set have been

The little things found during program tuning today. In Windows, if the key value is default null and ''is inserted, an error occurs. If mysql is running in Linux, the value of 0 in the same table is as follows: The table creation statement is the

It is easy to install openser 1.3.1 in Ubuntu Linux, but the configuration is complicated: 1. Connection to the mysql database, instead of using/usr/local/sbin/openser_mysql.sh create (1.2.2) Instead, use/usr/sbin/openserdbctl create, and

First, install the ODBC driver unixODBC on Linux. Www.unixodbc.org After the download, you can also select the graphical interface for installation. Relevant documents are also available on this website. UnixODBC can connect to SQL 2000. mssql and

This article describes all the enhancements to the resource manager in Oracle 11g R1, including: (1) I/O Calibration (2) per session I/O restrictions (3) Resource Manager statistics in AWR (4) built-in resource plans I/O Calibration The

Although MySQL 5.1 has released GA after 5.1.30, it is clear that the development of MySQL 5.0 series has not been stopped officially, A new community stable version 5.0.75 has been released on the MySQL ftp server this morning. This is a bug fix

Today, MySQL cannot be started under normal users. I found that I had a problem installing MySQL in Linux. Now I have to reinstall mysql again, The following are the specific steps and descriptions. In this record, we will try again later for

Environment: OEL + Oracle 11.2.0.1 Since there is already a database instance in the current environment, this does not affect the creation of a new instance sun Current System instance [Oracle @ DBA2 dbs] $ env | grep ORACLEORACLE_SID = orcl1ORACLE_

I recently started to study MySQL and MongoDB and found that there is not much information in this area. In particular, there are too few articles on ideas. Some articles on comparative testing are basically blind tests. The testing methods are

Today I tested how to recycle a large number of deleted space in MySQL (version 5.5.27 ).1. myisam table Optimize table tablename ;# Ii. innodb table (independent tablespace) -- innodb-file-per-table A. Method 1: optimize table m; Mysql> delete from

1. Create the path to save the backup file/mysqldata # Mkdir/bak/mysqlbak 2. Create the/usr/sbin/bakmysql file. # Vi/usr/sbin/bakmysql. sh 3. Write the following script: NOTE: If your mysql password contains special characters, such! @ #, You need

Oracle 11G Virtual Column Oracle 11G introduces virtual columns in the table. A virtual column is an expression that is calculated during runtime. It is not stored in the database and cannot be used to update the values of virtual columns. Syntax

1. First fill in the database connection string in Webconfig 2. Step 2: Create a page and add the following code Public partial class WebForm1: System. Web. UI. Page{ /// // Connect to the database /////////////////////// ////////String oraclestr =

In mysql, when the delete operation drops tens of millions of data records, the table may be locked, and the mysql server may be under great pressure. This is an unavoidable problem in mysql. It can be said that it is insufficient in dealing with

I:‍‍Ora-01555 error is a common error in the big data environment of the telecom industry. This error causes the application to fail. For example, this error may stop a batch processing task that runs late at night and then cause other tasks

The previous article introduced how to install the Oracle database on Ubuntu (see). The entire installation process was still smooth, but some steps were not successfully executed, or you just chose to ignore them, this may cause the installation to

To ensure security, Mysql allows users to log on only locally by default. However, in this case, you still need to use the user for remote connection. Therefore, you need to perform the following operations remotely: 1. Allow the root user to log on

Oracle special symbol & processing, today encountered a problem, the colleague uses the insert statement generated by dynamic SQL, which contains the & symbol, during insert, this & symbol is used as a variable prompt. How can this problem be solved?