Database Administrator

Keep these three things in mind and never put them in the database. I have already said in many speeches that the best way to improve your system is to avoid "stupid things" first ". I am not saying that you or the things you develop are "stupid",

An Application of MySQL to compress tables 1. Set server ParametersInnodb_file_per_table = ONInnodb_file_format = Barracuda 2. Create or modify table parametersAlter table sod_song_log_2014_10_12 row_format = compressed key_block_size = 8; The

A bug about database restart in Oracle The drop database operation is a fatal operation in Oracle. This operation has been experienced in the test environment and will completely delete data files. Therefore, this operation is very sensitive but not

Solve the Problem of MySQL Chinese garbled characters In the case of MySQL Chinese garbled characters, first use the status command to check the database configuration, as shown below: The information about the database configuration is

Oracle 11g result set cache restrictions There is a small table with a data volume larger than one million. This is similar to IP address range lookup. the number of queries to a table is large. the number is generated in real time, and sometimes

Details about Reference Partition in Oracle 11g Data Partition is a solution for Big Data Objects proposed by Oracle in the early days. After the evolution of several versions, Partition is still a popular and widely used technical strategy with a

ORA-600 [kcbz_check_objd_typ] Error Handling Basic ElementsChannel feedback, HIS software in the data storage, prompt ORA-600 error, the specific error information is as follows: [Microsoft] [ODBC driver forOracle] [Oracle] ORA-20999: ORA-00600:

Fault case: Insufficient disk space may cause mysql problems. Case: mysql During work, due to the customer's disk space alarm, insufficient space caused the following possible mysql problems. 1. mysql process cannot start 2. mysql cannot be

PreparedStatement and Statement, preparedstatement PreparedStatement is one of the APIs used to execute SQL query statements. Java provides Statement, PreparedStatement, and CallableStatement to execute query statements. Statement is used for

Oracle compiler warning: oracle Compiler Compiler Warnings Compiler warningOracle 10g allows you to enable compile-time warnings that are useful to identify potential run-time problems in your programs. these warnings are not serious enough to raise

Solution for oracle Database not opened, oracle DatabaseMicrosoft Windows [version 6.1.7601]Copyright (c) 2009 Microsoft Corporation. All rights reserved.C: \ Users \ Administrator>C: \ Users \ Administrator> sqlplus/as sysdba;SQL * Plus: Release 11.

How to Use plsql to connect remote or local oracle data when the 64-bit operating system locally installs the oracle database, oracleplsql How to Use plsql to connect remote or local oracle data when the 64-bit operating system locally installs the

MongoDB introduction, installation, and setup of a simple mongoDB server (1 ).Related Websites 1. http://www.mongodb.org/official website, you can download the installation program, and doc, and driver. 2. http://www.mongoing.com/domestic

How many bytes does VARCHAR2 occupy? NLS_LENGTH_SEMANTICS, nls_language, nlslengthsemanticsORACLE initialization parameter: NLS_LENGTH_SEMANTICS The initialization parameter NLS_LENGTH_SEMANTICS is used to specify the length definition method for

Simple SQL partially strengthens exercise questions, simple SQL strengthens exercise questions Simple query of some SQL exercises -- Select * from emp where deptno = 30 for all employees in department 30; -- list the names, numbers, and

Oracle Learning (13): Data Dictionary, oracle dictionaryThe data dictionary structure includes:-basic table: Description of database information, which can only be modified by the database server-User table: User-Defined tableData Dictionary naming

How to enable or disable the foreign key constraint in mysql.Method for starting and disabling foreign key constraints in mysql (FOREIGN_KEY_CHECKS) When a table or a piece of data is deleted in MySQL [Err] 1451-Cannot delete or update a parent

The difference between Mysql and Oracle group by is that mysqloracle This article is original freas_1990, reprint please indicate the source: http://blog.csdn.net/freas_1990/article/details/46310145 In Oracle, grouping and aggregation must appear

Mysql Database Error solution: mysql database ERROR 1046 (3D000): No database selected Error Description: no database is selected ---- Cause: the corresponding database is not opened (operations on creating tables and tables must be performed

MongoDB performs CRUD operations on images-combined with JAVA, mongodbcrud The previous blog briefly introduced how to install MongoDB, how to operate MongoDB in dos, and how to solve the errors in installing MongoDB. Of course, these are not enough.