NAV: SLTechnology News&Howtos > Database >

• 

  Oracle table and object base maintenance notes

  An oracle Table and object Foundation maintenance Note 1.1 Common Concepts 1.2 create Table 1.3 Table Common Fields 1.4 add or Delete Fields 1.5 Update Fields 1.6 rename Table 1.7 change Table Storage Tablespace and Storage parameters 1.8 Delete Table 1.9 Table Notes

  2022-06-01 19:16:12 Views: 207
• 

  Mysql session control limits the number of logins (connection_control plug-in)

  Database environment: Server version: 5.6.41 MySQL Community Server (GPL) 1. View user mysql > select Host,User from user whe

  2022-06-01 19:15:55 Views: 237
• 

  Mysql Authorization Guide

  Mysql authorization application scenario: separation of database and application after deployment of mysql server, it is sometimes inconvenient to connect to the database remotely. However, authorization is required to remotely configure mysql to allow remote connection to change the number of mysql after localhost login to mysql.

  2022-06-01 19:15:55 Views: 298
• 

  Optimization of SUM and GROUP BY statements

  1. Optimization of sum and GROUP BY statements: 1. The original statement is: SELECT IID.INVENTORY_ITEM_ID, SUM (IID.AVAILABLE_TO_PROMISE_DIFF), SUM (IID)

  2022-06-01 19:15:55 Views: 204
• 

  Mysql backup script

  Read several scripts on the Internet, slightly modified according to the Internet, a little more accurate, that is, the lack of logging function, have not yet decided how to write, and then add #! / bin/bash# to do a large number of backups Backup_Max_Files=20# database backup directory WO

  2022-06-01 19:15:34 Views: 270
• 

  Apache2.4:lamp+xcache

  Xiaosheng blog: http://xsboke.blog.51cto.com------- thank you for your reference, if in doubt, welcome to communicate 1. Lamp workflow 1. Client request web server, request page is php dynamic page

  2022-06-01 19:15:34 Views: 225
• 

  [MongoDB] check whether the collection is fragmented

  The reason is that MongoDB will save the sharded collection in the config.collection collection. If you need to view the sharding key, you need to find it according to this collection. Many other official sharding shortcut commands are also available in the config library in three ways to go to the config library.

  2022-06-01 19:15:34 Views: 213
• 

  Performance comparison of mongodb, mysql and redis

  Recently, because of the need of work, I have studied mongodb, but I don't know how its real performance is, so I have done some tests compared with mysql. Now I just insert the operation, and I haven't had time to update it. Post it and share it with you (I have made up the redis part). data

  2022-06-01 19:15:33 Views: 297
• 

  PostgreSQL standby checkpoint

  If the database is shut down abnormally, and there is no time or opportunity to do checkpoint when the database is closed, you need to recover from the beginning of the last consistency check. PostgreSQL standby checkpoint cannot generate checkpoint WAL, because if

  2022-06-01 19:15:33 Views: 284
• 

  MySQL failed to start-- cannot allocate the memory for the buffer pool

  2017-08-13 13:40:27 19011 [Note] InnoDB: Initializing buffer pool, size = 128.0MInnoDB: mmap (1373634

  2022-06-01 19:15:33 Views: 223
• 

  DB2 federated database and configuration method (and federal password modification)

  If you need to use all different databases, including select, insert, update, and delete, as if all tables are in a single database, you will be very productive. Database federation is to do this: to make all tables look as if they are in the same database, then the database is joined.

  2022-06-01 19:15:19 Views: 280
• 

  Modify the maximum number of Oracle,mysql connections

  1. Method a to modify the maximum number of connections in Oracle, log in to PL/SQL or Worksheetb as sysdba, query the current number of connections show parameter processes;c, and change the number of system connections alter s

  2022-06-01 19:15:18 Views: 212
• 

  @?! in sqlplus The function of the number

  Sqlplus @?: @-- indicates the execution of a file, such as SQL > @ / home/oracle/root.sql?-- represents the installation directory of oracle!-- indicates the execution of commands on the operating system, such as! Cp / home/a.sql

  2022-06-01 19:15:00 Views: 216
• 

  SAP ECC6.0 Migration upgrade to EHP6 on HANA proc

  #. / STARTUP confighostagent QAS**** HOST detected as SAPQAS**** The root directory to SUM is / usr/sa

  2022-06-01 19:15:00 Views: 217
• 

  Use the mysqladmin command to change the MySQL password and forget the password

  Change the password: 1. For example, if your root user does not have a password and you want to change the password to 123456, the command is: mysqladmin-u root password 1234562. If your root now has a password (12

  2022-06-01 19:15:00 Views: 241
• 

  Oracle ogg building

  1. Environment introduction Project Source side Target side ip192.168.12.23192.168.22.24oracle sidorclorclgoldengate user oracleoracleogg version 11.2.1.0.111

  2022-06-01 19:14:59 Views: 298
• 

  [MongoDB Learning Notes 13] Advanced update operation of MongoDB

  1. Batch updates only update one document that meets the criteria by default > db.post.find () {"_ id": ObjectId ("54a530c3ff0df3732bac1681"), "id": 2, "n"

  2022-06-01 19:14:59 Views: 258
• 

  Implementation and maintenance of MySQL Router read-write Separation Project _ MySQL High availability replication and distributed Cluster Architecture 07

  Implementation and maintenance of MySQL Router read-write Separation Project _ MySQL High availability replication and distributed Cluster Architecture 07 Video tutorial Learning address http://edu.51cto.com/course/14377.htmlOracle/MyS

  2022-06-01 19:14:56 Views: 222
• 

  Simple management operation of CDB and PDB of Oracle12cR2

  Oracle 12C introduces new features of CDB and PDB. In the multi-rent user environment (Multitenant Environment) introduced by ORACLE 12C database, one database container (CDB) is allowed to host multiple pluggable databases (

  2022-06-01 19:14:53 Views: 300
• 

  Oracle adds comments to tables and fields

  Comment on column TableName.ColumnName is' comment name'; comment on table TableName is' comment name'

  2022-06-01 19:14:52 Views: 246