Innotop MySQL Monitoring Tool Innotop is a monitoring tool that displays MySQL and InnoDB Storage engines in text mode. Innotop is developed in the perl language. It can be used more flexibly on various operating platforms. It can monitor the
Oracle stored procedure returns (N) working days based on the specified date I have never written any Oracle stored procedures. Today I have a sudden demand: Calculate the first N working days of the specified date or the next N working days
Oracleclient + PLSQL Developer remote login to Oracle Database Oracle databases have powerful functions and excellent performance. When these advantages are created, Oracle accounts for more memory than memory. To address this problem, how can we
Install MySQL 5.6.15 in Linux This article briefly explains how to install MySQL 5.6.15 in Linux. 1. Download MySQL 5.6Download Page: http://dev.mysql.com/downloads/mysql/Select "Red Hat Enterprise Linux 6/Oracle Linux 6 (x86, 32-bit), RPM Bundle"
Oracle SQL statement tracking 1. SQL statement tracking The execution of SQL statements must be performed on the Oracle server. The Oracle server detects and records all SQL statements executed by the access process. The commands used below are all
ORA-12545: the connection failed because the target host or object does not exist 1. Problem Description In the Windows XP system, the AX1 application and the upgraded version of AX2 are installed at the same time to connect to the same connection
Compile and install Redis and master-slave replication configuration in Linux The installation and configuration of Redis is very simple, and Redis has been installed a long time ago. But I forgot some details when I installed it again these days.
Install Redis in RedHat Linux My Linux system is: RedHat [Root @ infa ~] # Wget http://download.redis.io/releases/redis-2.8.12.tar.gz Tar xzf redis-2.8.12.tar.gz [Root @ infa ~] # Tar xzf redis-2.8.12.tar.gz [Root @ infa ~] # Cd redis-2.8.12 [Root @
Explanation of the Redis configuration file Parameters of the Redis configuration file: 1. Redis does not run as a daemon by default. You can modify this configuration item and use yes to enable the daemon. Daemonize no 2. When Redis runs as a
MySQL study note _ 4_MySQL create a data table (below) and study note _ 4_mysqlCreating multiple MySQL Data Tables (below) V. Data Table types and storage locations 1. Unlike most databases, MySQL has a storage engine concept. MySQL can select
Data Center reconstruction-why do we need to separate the card table from the student table and reconstruct it --- During the reconstruction of the fee-based database in the IDC room, the previous Studetn_Info was divided into Card_Info and
One of the oracle learning starter series, database development and history, one of the oracle Series Oracle learning starter Series Database development and history This oracle learning getting started series is based on some of my work notes,
I implemented the JDBC driver for the memory database and the jdbc driver for the memory database. I made a memory database last year and thought it was very powerful. The memory database is a program that runs independently. The client accesses the
MongDB start WARNING: soft rlimits too low, mongdbrlimits # MongoMongoDB shell version: 3.0.2Connecting to: testServer has startup warnings:T12: 34: 19.688-0700 I CONTROL [initandlisten]T12: 34: 19.688-0700 I CONTROL [initandlisten] ** WARNING: soft
Expdp export encountered ORA-39064: unable to write log file, expdpora-39064 Expdp export encountered ORA-39064: unable to write Log File .. Exported "USER_XXXX". "TAB_YYYY" 0 KB 0-line ORA-39064: unable to write Log File ORA-29285: file write error
Mongod. conf, mongodbmongodb. conf Mongod-f 'config path' MongoDB introduces a configuration file in YAML-based format. Versions earlier than 2.4 are still compatible. My mongodb configuration file: systemLog: destination: file path:
DS-based linked list for reverse local configuration The reverse setting of data elements in a linked list is a very common example. An additional inverse function is required for the blog to reverse the input data in an ordered table, to implement
Insert a new column after specifying a column in MySQL, and insert a column in mysql.ALTER [ONLINE | OFFLINE] [IGNORE] TABLE tbl_nameAlter_specification [, alter_specification]...Alter_specification:Table_options| ADD [COLUMN] col_name
Prerequisites for changing a Windows database server to a Linux Database Server The prerequisite is: Please contact the application software developer and O & M personnel for confirmation: First, whether the Window database server has an
Use dbcp to configure the data source and dbcp Data Source1. Configure the dbcp data source requires two jar packages, commons-dbcp-x.x.x.jar and commons-pool.x.x.x.jar, the version difference is not very big, of course also need database driver2.