NAV: SLTechnology News&Howtos > Database >

• 

  [Oracle Database] EM Cloud Control 12c: monitorin

  [root@wallet01 ~] # vi / etc/hosts192.168.40.99 emcc.gscaifu.com [root@wallet01 ~] # vi / etc/sudoers# Di

  2022-06-01 16:49:11 Views: 274
• 

  Install the mongodb database on centos6.5

  Mongodb installation steps: 1 sudo mkdir / home/mongodb # create MongoDB program storage directory 2 sudo mkdir / data/mongodata-p # create data storage directory 3 s

  2022-06-01 16:49:08 Views: 274
• 

  Use MongoDB for quick paging

  Using MongoDB to page quickly English text: http://blog.mongodirector.com/fast-paging-with-mongodb/ paging through your data is one of the most common operations using MongoDB. Canon

  2022-06-01 16:49:08 Views: 227
• 

  Wsrep_on of PXC cluster parameters

  Change the wsrep_on parameter value to the off,drop table, open another session, and find that the table still exists. The main function of this parameter is to control whether the writes of the current node are copied to other nodes. It is very similar to MySQL's sql_log_bin. The test process is as follows:

  2022-06-01 16:49:07 Views: 257
• 

  Current events are conditional when indexed on the column

  There are conditions for indexing columns: 1. Columns that are often queried 2, columns used in the order by clause 3, columns that are foreign keys or primary keys 4, columns that are unique 5, two or more columns that often appear simultaneously in the where clause or join conditions, generally speaking, should be on these columns

  2022-06-01 16:49:07 Views: 270
• 

  Mysql 5.7install SQL audit

  1. To enable SQL audit function for database security, select the plug-in of MariaDB Audit Plugin (Oracle MySQL 5.7.24) mysql > show variables like 'versi

  2022-06-01 16:49:07 Views: 255
• 

  The concept and usage of MongoDB Index

  Index, which provides quick access to specific information in database tables. An index is a structure that sorts the values of one or more columns in a database table, such as the name (name) column of the employee table. If you want to find a specific employee by last name, compared to having to search all the rows in the table

  2022-06-01 16:49:07 Views: 292
• 

  Oracle EBS dba SQL scripts

  -View all responsibilities of EBS users: SELECT frt.responsibility_name, furg.END_DATEFROM fnd_user_resp_groups furg,fnd_respon

  2022-06-01 16:49:06 Views: 289
• 

  [MongoDB Learning Note 1] install MongoDB based on CentOS 6.5

  1. Add MongoDB installation source vim / etc/yum.repos.d/mongodb-enterprise.repo to write the following configuration items to the file [mongodb-enterprise] name=MongoDB

  2022-06-01 16:49:06 Views: 302
• 

  Modify the data directory after mysql rpm package installation

  Modify the data directory 1. 1 after mysql rpm package installation. Stop the mysql data service / etc/init.d/mysqld stop2. Specify permissions chmod-R 777 / home/mysql/databa for the created data directory

  2022-06-01 16:49:06 Views: 284
• 

  Chapter 13 Python Database programming

  This chapter explains how Python operates the database and completes simple additions, deletions, modifications and queries, taking MySQL database as an example. Python's MySQL database operation module is called MySQLdb and requires additional installation. Install through the pip tool: pip install

  2022-06-01 16:49:06 Views: 271
• 

  Oracle 11g R2 Control of things

  Control transaction bank transfer Li Si remit ACIDA to Zhang San: atomicity: all the steps in the whole transaction are inseparable, and the atomicity principle stipulates that all steps of a transaction must be completed, otherwise the whole transaction will not be completed. That is, to ensure that all operations in a transaction can be completed or cannot be completed.

  2022-06-01 16:48:58 Views: 214
• 

  Oracle error: ORA-03113: end-of-file on communication channel Process

  Database mounted.ORA-03113: end-of-file on communication channelProcess ID: 4907Session ID: 1 Serial

  2022-06-01 16:48:58 Views: 261
• 

  Automatic initialization of SQL Server 2017 AlwaysOn AG (6)

  Stop the automatic seeding of a secondary copy on an existing availability group to execute ALTER AVAILABILITY GROUP [] MODIFY REPLICA ON''WITH (SEEDING_MODE = MA) on the primary copy

  2022-06-01 16:48:58 Views: 257
• 

  Mybatis returns the primary key value after oracle inserts the object

  When a record is inserted by default in mybatis, the return value is the number of records inserted. Now if you want to get the primary key value of the record currently being inserted after the record is inserted, you need to add the following code to the insert method: select T_USER_INFO_SEQ.next

  2022-06-01 16:48:57 Views: 282
• 

  MongoDB gets time-related commands

  1. Display a list of all the data command show dbs2. Displays the current database object or collection command db3. Connect to a specified database command use local4. Get the creation time of the document command var newOjbect = ObjectId

  2022-06-01 16:48:54 Views: 217
• 

  Use php to create a database exercise, register

  On Saturday, December 31, 2016, open XAMPP and create a folder under htdocs for php to create a database. Second, prepare to create the necessary folders. Third, open folders with submit. View on the left. Fourth, create under the config folder.

  2022-06-01 16:48:36 Views: 204
• 

  Secure deletion of binlog for mysql

  1. To clear the binlog file manually, in theory, you should add the binlog expiration time configuration item to the configuration file / etc/my.cnf, expire_logs_days = 10. 0. But if this item is not added, as more and more binl are generated

  2022-06-01 16:48:34 Views: 208
• 

  C # Winform change profile connection database cannot take effect immediately

  During the run of the program, the configuration file is loaded only once, so it must be reread after dynamic changes to take effect. Here is the code section. 1. Dynamically modify the configuration file / / through Xml (need using System.xml;) XmlDocument do

  2022-06-01 16:48:33 Views: 275
• 

  Introduction and installation of SQL Server

  The necessity of using database: a large amount of data information can be stored structurally, which is convenient for users to retrieve and access effectively; it can effectively maintain the consistency and integrity of data information and reduce data redundancy; it can meet the sharing and security requirements of the application. Common databases are: SQL Se

  2022-06-01 16:48:03 Views: 268