Database Administrator

Oracle online redefinition of DBMS_REDEFINITION normal table-> Partition Table Lab environment: RHEL 6.4 + Oracle 11.2.0.3Experiment: Online redefinition of a common table as a partition table, including the indexes corresponding to the primary key

MySQL database security permission control management philosophy Web account authorization case studiesA. Account authorization for the master database user in the production environment:Grant select, INSERT, UPDATE, delete on blog. * TO 'blog '@ 10.

Use HAProxy as MongoDB sharded cluster mongos Load Balancing MongoDB shard cluster entry mongos does not have a failover mechanism. The official recommendation is to deploy mongos and the application server together. It is inconvenient to deploy

Deep Learning about Memcached and memcached Because Memcached distributed cache is used in a project in the lab, I have also learned about the distributed cache in depth during this time. This article will summarize my achievements and let's talk

Common SQL statement optimization skills (1) and SQL statement optimization skillsTo improve the efficiency of SQL statement execution, the most common method is to create an index and avoid full table scan. We will organize some common SQL

[Introduction to algorithms] Lesson 10 balanced search tree and introduction to Algorithms If the tree structure cannot be balanced, the search performance will be greatly compromised. This section introduces several classic balancing trees, such as

Hibernate primary key generation policy and hibernate primary key policyThe sub-element in the ing file in hibernate is the name of a Java class, which is used to generate a unique identifier for the persistence class instance. If the generator

Database optimization tutorial (8) under what circumstances should indexes be used and indexes be optimized?Iii. Index 5. Under what circumstances should indexes be used? Since the index has a cost, you should not use it without using the

Database optimization tutorial (10) [excellent chapter] solve the four ways in which indexes are not used when like '% str', tuning % strIii. Index 7. Four methods to solve like '% str' without fuzzy query As mentioned above, the index will not be

Mysql encoding settings, mysql Encoding Mysql encoding settings MYSQL read 73 comments 1 font size: large, medium, smallMysql> show variables like 'character _ set _ % ';+ -------------------------- + ---------------------------- +| Variable_name |

How to diagnose the error time returned by sysdate in rac, racsysdateRecently, some rac environments have been used to access sysdate and return the error time. This problem often occurs when the database link is created through Listener, and, in

To modify the port number of an oracle 10g rac listener to 1523, rac1523To modify the port number of an oracle 10g rac listener to 1523I,Modify listener. ora and change 1521 to 1523. Back up the file in advance for quick recoveryII,Modify tnsnames.

Use military rules for mysql_db organized by the Department and sort out military rules for mysql_dbMysql_db military rules: 1. Developers and testers are prohibited from manually deleting and modifying data in the IDC environment.   2. Submit all

[Mysql] Create a database and develop the encoding, mysql Encoding Currently, many orm tables are used, and many mysql tables do not need to be created by themselves. However, the database must be created by itself, and the SQL statements

Improves the performance of JDBC batch operations and jdbc PerformanceJDBC When you use the insert into... VALUES () statement to INSERT data in batches, you should use the JDBC PreparedStatement batch operation method instead of using one

Summary of operations on the ACCESS database and summary of the access Database I CDaoRecordset is DAO and CRecordset is ODBC,VC ++ 6.0 provides some programming interfaces. There are five main types: 1. odbc api; 2. mfc odbc class; 3. mfc dao

Oracle rac does not support rhel5.x, rhel6.x, and rhel5.xrhel6. x. Oracle rac does not support rhel5.x and rhel6.x Because rhel5.x and rhel 6.x appear in oracle as "different operating system versions" The answer from oracle's sr engineers is as

What is a cursor? For the table structure in this instance, see the document "Create a table, insert an id column, and automatically generate an id ". Use yuyongTest; Declare @ tot int; Set @ tot = 0; Declare @ name nvarchar (50 ); Set @ name = '';

Redis source code parsing (1): Introduction, redis source code parsing IntroductionZookeeper The author of Redis, Salvatore Sanfilippo, is from Sicily, Italy and now lives in Catania. He currently works at Pivotal. The network name used is

Miscellaneous-excerpt from various IT tips and excerpt from it tips A. How to Set environment variables? /* Add the mysql running path (C: \ wamp \ bin \ mysql \ mysql5.5.20 \ bin) as an example */ Method 1: [temporary, only effective in the