Create a stored procedure instance in MySQL

Create a stored procedure instance in MySQL The MySQL stored procedure is a new feature added since MySQL 5.0. The advantages of stored procedures are as follows. However, the most important thing is the execution efficiency and SQL code

Install MongoDB and PHP MongoDB Driver in Ubuntu 14.04

Install MongoDB and PHP MongoDB Driver in Ubuntu 14.04 Description MongoDB is a very famous NOSQL database. The following is the installation of MongoDB in Ubuntu 14.04, as well as the configuration for PHP (driver Installation, etc.). This method

Install MySQL + Security optimization with apt-get on Ubuntu

Install MySQL + Security optimization with apt-get on Ubuntu 0. Description The advantage of using apt-get for installation is that you don't have to solve the dependency problem between software by yourself. Basically, after apt is executed, the

Oracle uses SQL to transmit tablespaces

Oracle uses SQL to transmit tablespaces Source environment: RHEL 6.4 + Oracle 11.2.0.4Target environment: RHEL 6.4 + Oracle 11.2.0.4 dual-node DGRequirement: use SQL to transmit the tablespace DBS_D_JINGYU from the source environment to the target

MySQL & #183; Performance Optimization & #183; 5.7.6 InnoDB page flush Optimization

MySQL · performance optimization · 5.7.6 InnoDB page flush Optimization In this article, we have introduced in detail the latest Optimization of InnoDB page flush by Oracle MySQL and Community branches. Further improvements have been made in the

Application change deployment in production mode of Weblogic

Application change deployment in production mode of Weblogic Scenario overview The next AdminSever in production mode allows WebLogic to manage multiple managedsevers. When deploying an application for the first time, you can select multiple

Oracle 11g solves the problem of User Password Expiration

Oracle 11g solves the problem of User Password Expiration After using Oracle 11g, often encounter the use of sqlplus login oracle Database prompts "ORA-28002: 7 days after the password will expire" and so on. Search for relevant information. It is

Introduction to deadlocks in SQL Server

Introduction to deadlocks in SQL Server Introduction What is a deadlock? In my opinion, the deadlock is because two objects apply for another resource when they have one resource, and the other resource is exactly what the two objects are holding,

Red Hat Enterprise Linux AS4, C ++ OCCI connect Oracle 9i

Red Hat Enterprise Linux AS4, C ++ OCCI connect Oracle 9i Red Hat Enterprise Linux AS4, C ++ OCCI connect Oracle 9i, provided that Oracle 9i has been installed. 1. Download the corresponding ORACLE client

MySQL execution Status Analysis

MySQL execution Status Analysis When you feel that MySQL performance is faulty, you will usually first check the current MySQL execution status and use show processlist to view it. For example: The state column information is very important. First,

Oracle bidirectional Stream configuration practices

Oracle bidirectional Stream configuration practices Abstract: This article describes how to use the Oracle Stream replication function for Bidirectional Stream replication. It is mainly used for real-time database synchronization and backup. Oracle

Migration of data files in the slave uard slave Database

Migration of data files in the slave uard slave Database A few days ago, I also spent some time testing the migration of data files in the standby database. This part of work seems to be more common, of course, there are many methods. However, in

Configure HugePage for Oracle 11gR2 in Linux

Configure HugePage for Oracle 11gR2 in Linux HugePage is a performance optimization tool for Oracle in Linux. For database systems in the shared memory area (SGA), we recommend that you configure HugePage at the operating system level to provide

MySQL & #183; Engine Features & #183; InnoDB undo log roaming

MySQL Engine Features-InnoDB undo log roaming This article describes the entire Undo lifecycle process. The code analysis is based on the latest version of MySQL5.7. This article can also serve as a guide to the Code for understanding the entire

MySQL & #183; Q & A & #183; mysqldump tips

MySQL Q & A · mysqldump tipsBackground When using mysqldump to export data to the cloud, you may encounter two "weird" problems.TIP 1 -- port is invalid? For instances with ports 3306 and 3307, run the following command: mysqldump --host=localhost --

Installing PostgreSQL using RPM packages in Linux

Installing PostgreSQL using RPM packages in Linux Postgresql and MySQL are currently popular and active open source relational database systems. Compared with high-end Oracle commercial products, Postgresql and MyQL have much room for improvement in

MySQL database Optimization

MySQL database Optimization How should we optimize the MySQL database? Next I will explain this problem from MySQL's hardware selection, MySQL installation, my. cnf optimization, MySQL architecture design, and data splitting. Optimization of server

Oracle manages disk space and resources

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

Oracle configuration database diagnostics

Oracle configuration database diagnostics Environment: RHEL 6.4 + Oracle 11.2.0.4 1. Set ADR2. Use Support Workbench3. Restore Block Media1. Set ADR1.1 to view v $ diag_info Viewv$diag_infoDiagnostic database information: col value for a70col name

MySQL & #183; Performance Optimization & #183; about InnoDB buffer pool flush policies

MySQL-Performance Optimization-about InnoDB buffer pool flush policies Background We know that InnoDB uses the buffer pool to cache data pages read from the disk to the memory. The buffer pool is usually composed of several memory blocks plus a

Total Pages: 1013 1 .... 70 71 72 73 74 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.