NAV: SLTechnology News&Howtos > Database >

• 

  MySQL Foundation-transaction isolation level

  Transaction is the execution unit of DBMS. It consists of a limited sequence of database operations. But not any sequence of database operations can become a transaction. Generally speaking, a transaction must meet four conditions (ACID) ①: atomicity (Autmic): the transaction is executing, to do "or not to do"

  2022-06-01 14:39:58 Views: 292
• 

  Hibernate loading process

  Configuration configuration = new Configuration (); create the object configuration.configure () that loads the configuration file; 1. Load configuration file hibe

  2022-06-01 14:39:57 Views: 220
• 

  SqlServer basic series-- row_number () rank () dense_rank () SqlServer series notes

  Create table A (Id int identity,Name char (10)) create table B (Id int, [SubJect] char (10), Score int)-1.

  2022-06-01 14:39:57 Views: 232
• 

  Pt-duplicate-key-checker and pt-diskstats and pt-deadlock-

  Find duplicate indexes and foreign keys and generate statements to delete duplicate indexes pt-duplicate-key-checker-- user=root-- password=energy@db-- port=3307 interactive check system I

  2022-06-01 14:39:57 Views: 303
• 

  Redis knowledge points

  1. About profile redis startup if you do not explicitly specify a configuration file, it does not use any configuration file by default, but uses its own default configuration. Therefore, if you modify the contents of the configuration file, but if you do not explicitly specify it at startup, the changes to it will have no effect. If

  2022-06-01 14:39:50 Views: 296
• 

  When Oracle accesses the Clob field through JDBC, an exception occurs when the length is 4193 and cannot be read normally

  When Oracle accesses the Clob field through JDBC, an exception occurs when the length is 4193. The reason why it cannot be read properly: not yet known

  2022-06-01 14:39:49 Views: 281
• 

  Using nmap to test unauthorized access to Mongodb Redis

  Mongodb download: http://nmap.org/svn/scripts/mongodb-info.nsenmap-p 27017-script mongodb-info Redis download: ht

  2022-06-01 14:39:46 Views: 300
• 

  NoSQL-redis backup / master-slave

  Redis persistence-two ways redis provides two ways of persistence, namely RDB (Redis DataBase) and AOF (Append Only File). Official advice: open both ways and back up at the same time. Endurance

  2022-06-01 14:39:46 Views: 217
• 

  Database connection pool

  Connection pooling is a mechanism for managing database connections that can control the number of connections, and by default you can create available connections in advance. There are four common connection pooling frameworks 1, Apache DBCP connection pooling (Tomcat has built-in DBCP) 2, C3P0 connection pooling 3, pro

  2022-06-01 14:39:46 Views: 273
• 

  Summary of common oracle database functions

  The basic syntax of wm_concat select proj_id,max (scale_valus) as scale_valusfrom (select a. Projprincipid.wmgift concat (a.scale _)

  2022-06-01 14:39:45 Views: 294
• 

  Userdel: user mysql is currently used by process 1489

  After the user is created, if the deletion occurs: userdel: user mysql is currently used by process 1489, then use ctrl + d.

  2022-06-01 14:39:45 Views: 208
• 

  [Oracle Database] Oracle DataGuard (single-single)

  Oracle Data Guard ensures high availability, data protection, and disaster recovery of enterprise data. Data Guard provides a comprehensive set of services for creating, maintaining, managing and monitoring one or more standby databases to enable production databases to respond to disasters and data

  2022-06-01 14:39:45 Views: 248
• 

  MongoDB adds one or more pieces of data to the collection

  1. View the collection show collections2. Inserts a document data db.runoob.insertOne ({'test':3}) 3. 0 into the specified collection. Inserts multiple document data db.runoob.inser into the specified collection

  2022-06-01 14:39:33 Views: 268
• 

  A solution to the failure of incremental update of CDH4,lily,hbase solr indexer

  The operation and maintenance staff monitored that the index could not be updated incrementally. After positioning, it was found that hbase solr indexer did not take effect. In the past, the test environment was usually caused by the failure of the hbase-solr-indexer process. But this time is different. Check the I of sep

  2022-06-01 14:39:32 Views: 266
• 

  Centos7 installs default mariadb5.5

  Install MariaDB1, install $yum-y install mariadb mariadb-server2, start MariaDB$ systemctl start mariadb3, set boot $

  2022-06-01 14:39:32 Views: 303
• 

  Solve the problem of setting utf8 encoding in win7-64bit in mysql5.6.X installation version

  According to many configurations in the network, copy a copy of the my-default.ini in the installation directory into my.ini, and then I modify the contents of the my.ini so that one of the problems that arise is that you need to modify the mysq in the my-default.ini.

  2022-06-01 14:39:14 Views: 282
• 

  Centos7 installs apache+mysql+php environment

  Environment: Centos 7.0Apache 2.2.27Mysql 5.1.72libiconv 1.14##Apache should be compiled and installed by yourself. The content is copied from my own word, which is good in wold and in some places.

  2022-06-01 14:39:11 Views: 301
• 

  One of the source code installation of mysql database installation

  MySQL is a relational database management system developed by the Swedish company MySQL AB and currently belongs to the products of Oracle. MySQL is the most popular relational database management system, and MySQL is one of the best applications in WEB applications.

  2022-06-01 14:39:11 Views: 266
• 

  Oracle to view the event of the new system

  For the new system you just took over, you want to see if some events are set as follows. * * APPLIES TO:**Oracle Database-Enterprise Edition-Version 7.1.2.0 to 1

  2022-06-01 14:39:10 Views: 272
• 

  Sql server database attach error / database cannot attach resolution process

  Fault description this case involves the storage of a brand R520 server with SqlServer database, which contains two sets of disk arrays, both of which are raid5 at raid level. Normally, the user's SqlServer database is stored in D disk.

  2022-06-01 14:39:10 Views: 283