Database Administrator

Configure user and user permissions in the MySQL database Problem: when using a remote tool written by a great god to manage the MySQL database, all the data can be properly displayed, but cannot be deleted or modified. Idea: You can remotely read

MySQL Thread Pool The MySQL thread pool is only available in Percona, MariaDB, and Oracle MySQL Enterprise Edition. Oracle MySQL Community edition is not available. In the traditional mode, there are two thread Scheduling Methods for MySQL: one

Oracle skip index scan test In Oracle, we know that we can use the Index Skip Scan. However, there are some limitations when we can use the Skip Index Scan.Create table test as select rownum a, ROWNUM-1 B, ROWNUM-2 c, ROWNUM-3 d, ROWNUM-4 e FROM all_

Oracle user status query Oracle user status query # Switch to an Oracle user Su-oracle # Log on to sqlplus Sqlplus/as sysdba # Set the display format Set pagesize 300; Set linesize 300; # Querying the user list and user status Select

Oracle 11g Username Password 180 days overdue Processing The Oracle 11g user name and password have expired. The solution is as follows: 1: log on to the console for verification. The JDBC test provided by weblogic can verify the database

MySQL backup script for database/table sharding 1. Database shard backup: #! /Bin/sh MYUSER = root MYPASS = 123456 SOCKET =/data/3306/mysql. sock MYLOGIN = "mysql-u $ MYUSER-p $ MYPASS-S $ SOCKET" MYDUMP = "mysqldump-u $ MYUSER-p $ MYPASS-S $ SOCKET-

Installation and deployment MySQL-5.7.13 in CentOS6.7 64-bit environment System Environment:[Root @ localhost ~] # Cat/etc/RedHat-releaseCentOS release 6.7 (Final)[Root @ localhost tools] # uname-Linux localhost 2.6.32-573.22.1.el6.x86 _ 64 #1 SMP

Troubleshooting of ORA-06502 errors reported by sqlplus Logon I recently encountered a sqlplus login error. I was wrong at the beginning of troubleshooting. I had to ask Master dbsnake for such a small problem, it solves the problem like "Mr. Luo

UNDO log systems The log system is the basic mechanism to ensure that the database management system correctly executes transactions. Based on different functions, the log system can be divided into UNDO and REDO. This article describes the

Resolving MySQL time conversion exceptions To connect to the MySQL database, an exception is thrown by default when the timestamp type with an operation value of 0 cannot be correctly handled:Java. SQL. SQLException: Cannot convert value '2017-00-00

MySQL Performance Test-Sysbench practiceSysbench Industry-renowned performance testing tools Allows you to test disks, CPUs, and databases. Supports multiple databases: Oracle, DB2, and MYSQL Download, compile, and install the SDK by yourself.

Typical paging code in Oracle Since there is no top keyword in Oracle, the paging code in SQL Server does not apply to Oracle. How can paging be implemented in Oracle? -- Query all data STUNO STUNAME STUAGE STUID STUSEAAT-----------------------------

Use SQL to split and combine data in the database Using SQL to split and combine data in a database provides the following solutions: Method 1: With cte (Select a. Id, A. [Uid], UserName FROM (Select a. [id], REPLACE (Split. a. value ('.', 'nvarchar

Oracle computing continuous login/working days Now there is a report that calculates the number of working days of a user. It is found that the row_number analysis function can perfectly calculate this problem. This SQL statement can solve problems

ORA-00600 error troubleshooting caused by an SQL statement Recently, a colleague asked me a question, saying that he ran an SQL statement and throw a ORA-00600 error. I want to help me analyze this problem. I am really interested in it, after

MHA high-availability failover Tool MHA IntroductionMHA is a MySQL failover solution written by MySQL daiu in Japan using Perl to ensure high availability of the database system. It completes failover within the downtime (usually 10-30 seconds,

MySQL 5.6 locking users MySQL 5.7 has the same account lock function as Oracle, but MySQL 5.6 does not seem to have it, but it can be used in the following way to set password expiration. The mysql. usertable now has a password_expiredcolumn. Its

The user smsdb in Oracle cannot log on to LOCKED (TIMED) A user created by smsdb to view the status LOCKED (TIMED) After unlocking, conn smsdb/password still reports an error and is locked again. It is found that the number of wrong logins reaches

Install and start MySQL in LinuxI. Comparison of various MySQL installation methods In Linux, MySQL has three major installation methods: RPM installation, binary installation, and source code installation. The advantages and disadvantages of the

Spring integrated MyBatis full instance (SHARE), springmybatis To sort out the content in Spring integration MyBatis (Maven + MySQL) 1 and Spring integration MyBatis (Maven + MySQL) 2, prepare a complete example to complete a simple library