Database Administrator

Select an appropriate backup method for MySQL Backing up a MySQL database is extremely important. If there is no backup, the system will go crazy in the following situations:UPDATE or DELETE whitout where... Table was DROPPed accidentally... INNODB

Modify the size of Oracle redo log files Modify the size of Oracle redo log files 1. Create 3 new log groups SQL> ALTER DATABASE ADD LOGFILE GROUP 4 ('/u01/app/oracle/oradata/orcl/redo06.log') SIZE 500 M; SQL> ALTER DATABASE ADD LOGFILE GROUP 5 ('/u0

ORA-08102 troubleshooting Two ORA-08102 errors today When deleting table data When the following statement is executed: Delete from tb_ware w where w. issue like '% 100 '; The following error occurs; ORA-08102: index key not found, obj #57848, file 6

Oracle simple column-to-row Oracle simple column-to-row The requirement is to count the total salaries of different jobs in each department. SQL> select deptno, ename, job, sal from emp;DEPTNO ENAME JOB SAL---------------------------------------20

SQL data types in Oracle Data types are the basis of data storage for each programming language. They are also a benchmark for the implementation of programming languages. Some programming languages may have a wide range of data types, such as java,

Install and test Redis in CentOS 6.5 Install and test apsaradb for Redis-CentOS 6.5 using NoSQL 1. Download redis You can install or download redis online. ① Check whether the rpm package does not exist before online installation. If you check

Installing Oracle software using NFS Yesterday, I used openfiler to create a nas storage system and install the Oracle software. Everything went well before that. A ora error was reported when I created a database. When I used nfs to install the

MySQL disable generating Log File mysql-bin.000001 In a MySQL database, mysql-bin.000001, mysql-bin.20.02 files are database operation logs, such as UPDATE a table, or DELETE some data, even if the statement does not match the data, this command

Whether the maximum number of connections is set in Oracle or an error is returned There are 1100 data records to be updated, and an error is reported during connection. ORA-12518, TNS: listener cocould not hand off client connection According to

[Practice] sphinx starts to close the management script and sphinx script #! /Bin/sh #/usr/local/sphinx/bin/# ocpyang@126.comsphinx _ pidfile =/usr/local/sphfile/var/log/searchd. pidif [-e "$ {sphinx_pidfile}"]; thensphinx_active = 1 # runing # echo

Optimization of SQL statements in hybrid MySQL, effectivemysqlWe recommend that you optimize SQL statements in objective MySQL.This article mainly explains how to analyze SQL Performance, indexing principles, how to create appropriate indexes, and

Solution for ORA-01417 under Oracle 11g, 11gora-01417 Today there is a brother feedback, there is a SQL on 12C no problem, on 11G on the error, the error content is ORA-01417: The table can be externally connected to at most one other table. This

Be careful when using with in Oracle -- predicate cannot be promoted, oracle Predicate Today, we can see that a SQL statement uses with in large quantities. For logic clarity, developers cache some result sets first with, and there are many places

Oracle not exists equivalent statement, oracleexists Not exists can be changed to left join + is null. It can be seen that the execution plan is the same before and after rewriting, and the resource consumption is the same, which means it is

GRANT authorization, grant authorization Log On As the sys (Administrator) and create the username zsta_new Create user zsta_newIdentified by passwordDefault tablespace ZSTA_DATA_TBSTemporary tablespace TEMPProfile DEFAULT; Authorize zsta_new users

Oracle data migration (from Oracle11G to Oracle10G) and oracle11goracle10g1. Database statusThe production environment is 11 GB, the linux system, and the testing environment is 10 Gb. For windows systems, you need to export all the data of a user

Hibernate cannot obtain MySQL database updates in real time. hibernatemysql Hibernate has been used in recent projects, but after each database record is updated, the updated data cannot be found with hibernate. I found many tutorials on the

Simulate ORA-26040: Data block was loaded using the NOLOGGING option, ora-26040nologging We know that setting the nologging option can speed up the execution of some oracle operations, which is very useful when executing some maintenance tasks, but

Innobackupex full backup database, innobackupex For MySQL Database Hot backup, xtrabackup is the best choice except MySQL enterprise backup. This tool provides Hot Backup Based on the innodb Storage engine, supports full, Incremental backup, partial

[MongoDB] mongodb sharded cluster (6) on windows platform, mongodb Cluster In this blog, we mainly discuss blog management. Since we have already written detailed examples in the previous five articles, we will not illustrate them here. I.