NAV: SLTechnology News&Howtos > Database >

• 

  MySQL 5.7binary installation

  The installation methods of MySQL under Linux are yum, binary and source code installation. Yum installation is relatively simple, which is no longer introduced here. The binary version is not required and is suitable for testing. If it is an online environment, please use source code installation. This paper mainly introduces the binary security.

  2022-06-01 12:44:19 Views: 226
• 

  RMAN compressed backup

  CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE' DEFAULT' OPTIMIZE FOR LOAD TRUE; # default query

  2022-06-01 12:44:13 Views: 202
• 

  Mongodb aggregate mapReduce and group

  Aggregate in AggregateMongoDB is mainly used to process data (such as statistical average, summation, etc.) and return the calculated data results. The syntax of count (*) in similar sql statements is as follows: db.collection

  2022-06-01 12:44:13 Views: 262
• 

  Centos7 installation single node mysql (rpm package installation)

  1. Check whether the following software package is installed, and if it is uninstalled. # rpm-qa | grep postfix# rpm-qa | grep mariadb# rpm-qa | grep mysql2, create directory creation package

  2022-06-01 12:44:13 Views: 223
• 

  Ogg (goldengate), a scheme for migrating oracle to mysql sublibraries and tables.

  The previous article mainly introduced the migration of oracle to mysql, mainly the migration of the original table structure, but the actual operation and maintenance staff will find that the split operation of sub-library and sub-table is needed after mysql. At this time, using ogg to do it is also very powerful and easy to use. Mainly combined with two parameters of ogg

  2022-06-01 12:44:10 Views: 286
• 

  Comparison of Oracle regular backup and recovery full database mode, user mode and table mode

  The command statements of the three modes and the key differences (red font marks) are as follows: 1. Full library mode export / import: exp 'user/pwd@ip/ORACLE_SID'file='/data/backup/datafile1.dmp

  2022-06-01 12:44:10 Views: 209
• 

  Unable to activate database vice-newspaper error

  [screenshot of error report] [solution] after the execution of the above command, the view data is normal.

  2022-06-01 12:44:01 Views: 263
• 

  [data relocation] change the root password of mysql under windows

  When using MySQL for the first time, there are a lot of things that are not very clear and are still being explored. Because of a software, you have to change the password of root in MySQL. I originally wanted to reinstall MySQL, but you can't reinstall it every time you encounter it. Just find some information, how to change the password, online

  2022-06-01 12:43:58 Views: 299
• 

  Oracle 11G table compression

  Recently, the alarm of a set of production database table space has been more than 90%, but the disk hardware resources are insufficient, and the whole library has reached 26T. The database has stored nearly 4 years of data, communicate with the business that the historical data basically can not do the operation, but can not be archived, so I thought of compressing the table to save table space. With

  2022-06-01 12:43:57 Views: 225
• 

  The use of Mycat-02. Configuration

  The last time we introduced the concept of Mycat, speaking of sharding table, let's start with configuring a sharding table to briefly describe the configuration of Mycat. Schema.xml is the first configuration file encountered, which manages the logical library, tables, sharding rules, sharding nodes and node master of Mycat.

  2022-06-01 12:43:51 Views: 261
• 

  Mycat study 01-mycat I'll get you started.

  Please read the whole article patiently. The mistakes made in the process are summarized and solved at the end of the article. Server architecture installation MySQL create mysql user groupadd mysqluseradd-r-g mysql-s / bin/fal

  2022-06-01 12:43:51 Views: 274
• 

  MySQL daily command

  MySQL daily operation mysqladmin-u root-p password "abcabc" before setting the password to the MySQL root account, enter the original password if you have set the password, and enter if not. Log in to mysql-ur

  2022-06-01 12:43:40 Views: 222
• 

  Index optimization series of secondary tables

  -- an example of index back table reading (TABLE ACCESS BY INDEX ROWID) drop table t purge;create table t as select * from dba_object

  2022-06-01 12:43:40 Views: 238
• 

  SSMS shortcut key

  Query Editor window Ctrl+Shift+R Refresh IntelliSenseCtrl+K+K add / remove Bookmarks Ctrl+K+An enable all Bookmarks Ctrl+K+N move to the next Book

  2022-06-01 12:43:28 Views: 283
• 

  Use of Mysql connections

  The use of Mysql connections in the previous chapters, we have learned how to read data in one table, which is relatively simple, but in real applications we often need to read data from multiple data tables. In this chapter, we will show you how to use MySQL's JOIN in

  2022-06-01 12:43:28 Views: 262
• 

  The way to Advanced DBA-- "SQL Server Monitoring and diagnosis"

  Programmers who write major terminals often have the illusion that the SQL language is simple and DBA works easily, especially for Android programmers who are used to using SQLite and its extension frameworks OrmLite and GreenDAO, especially when an Android programmer sees

  2022-06-01 12:43:27 Views: 256
• 

  Common skills of awr

  Awr is retained for 10 days and collected hourly: begin DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS (14400); end; manually collects awr once: ex

  2022-06-01 12:43:27 Views: 213
• 

  ORACLE query

  Query existing tables: show all tables (table is abbreviated, only table name) select * from tab; displays all tables (table fields have) select * from user_tables; query the table under user xxk (user name should be uppercase, only

  2022-06-01 12:43:27 Views: 296
• 

  Mycat data Migration Test

  Mycat data migration test mycat data migration test uses mysqldump for data migration test data volume 20 million 1. The export-c parameter is required, otherwise you cannot import the sharding table mysqldump-udata_dev-p-

  2022-06-01 12:43:27 Views: 254
• 

  Oracle cdb, pdb referenc

  Introduction to the concept of CDB and PDB CDB and PDB are new features introduced by Oracle 12C. In the multi-rent user environment (Multitenant Environment) introduced by ORACLE 12C database, a database container (CDB) is allowed.

  2022-06-01 12:43:19 Views: 296