Database Administrator

What should I do if I forget the MySQL password root? What if you forget the root password of the online MySQL database one day? You will often think of the skip-grant-tables parameter. The specific steps are as follows: 1. Shut down the MySQL

ORA-00984: columns do not allow SQL parse error location here ORA-00984: The column is not allowed hereSQL parse error location When Oracle inserts data, it always prompts that the column is not allowed here. Online Search answers that many types

MySQL slow query methods For troubleshooting and identifying performance bottlenecks, the most common problems are slow queries in MySQL and queries that do not have to use indexes. ========================================================== =========

MySQL5.5.32 compilation and Installation MySQL IntroductionMySQL is a relational database management system developed by MySQL AB in Sweden. It is currently a subsidiary of Oracle. MySQL is the most popular Relational Database Management System. In

Oracle string operation functions Character function -- returns the character value All these functions receive parameters of the character family type (except for CHR) and return character values. except for some special descriptions, most of these

Navicat Premium common functions Navicat Premium common functions 1. Shortcut Keys1.1. F8 quickly returns to the current Object List 1.2. Press Ctrl + q to open the query interface 1.3. Ctrl + d quickly modify the current table structure 1.4. Ctrl +

MySQL 5.7 JSON support Recently, a business needs to store Json and perform some simple business logic processing. I have found that it is difficult to use mysql 5.6 for json data analysis. It is very difficult to simply store data. I have no way to

Install the stress testing tool swingbench in Linux Many people may have a irrational idea about graphic tools. They feel that as long as a graphic interface is used, the technical content is lost, and the graphics can be a little bit of something,

Install, configure and use phpRedis Install Redis before installing phpRedis. 1. Download and install On a Linux server, run the following command on the command line (the General source code of cd./usr local/src is put here (the installation of

Redis installation Configuration This section describes how to install and configure redis and start redis as a service.1. download the latest version of the redis-3.0.7 to the unzip-zxvf redis-3.0.7.tar.gz above the redis-3.0.7 is the directory of

Zabbix failed to monitor MySQL backup Environment: A: 172.16.16.1 (MySQL machine)B: 172.16.16.2 (backup machine)C: 172.16.16.3 (zabbix server) IntroductionAs A result of the company's development needs, we need to back up the Intranet Test Database

Install MySQL5.5.48 in RPM Mode Under CentOS 7.0 The environment is CentOS7.0, the yum source is updated, and MySQL5.7 is installed first, but the initial password problem is not solved after one afternoon. The project progress is very tight, so you

Oracle idle wait events and non-idle wait events Oracle wait events are an important basis and indicator for measuring the operating status of Oracle. The concept of wait events is introduced in Oracle7.0.1.2, with approximately 100 wait events. In

Clears MySQL Database Data Based on Field Conditions BackgroundAn online database has 1000 database shards and disk alerts. The size of each database is not very large, but the total size is very large. It is unrealistic to manually clean up data

Use the char type in Oracle 11g In Oracle data tables and program types, character types may be the most commonly used. Historically, Oracle first introduced a fixed-length char field, and then launched varchar2. Currently, mainstream Oracle

After MySQL 5.7 is installed in rpm mode in CentOS 7, root login cannot be used. Recently, the latest mysql-server 5.7 (mysql57-community-release-el7-7.noarch.rpm) version was installed in CentOS 7 using rpm, and root login was not available after

Use of DRA (Data Recovery Advisor) The official description of DRA: The simplest way to diagnose and repair database problems is to use the Data Recovery Advisor. This Oracle Database tool provides an infrastructure for diagnosing persistent data

Compile and install MySQL under the same account Compile and install MySQL under the same account Check whether the old version exists: Rpm-qa | grep mysql Uninstall the old version: Rpm-e mysql # normal deletion Mode Rpm-e -- nodeps mysql # Strong

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-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