NAV: SLTechnology News&Howtos > Database >

• 

  1064 error reported in the process of creating table by Mysql

  In the mysql service I built by myself, I made 1064 mistakes in creating tables with create table, tried to find various solutions online, and finally tried to solve them by myself. Some of the solutions are muddled. After all, I don't have a clear understanding of the database knowledge.

  2022-06-01 16:25:12 Views: 257
• 

  NoSQL extension of MySQL-HandlerSocket plug-in

  MySQL's NoSQL extension-HandlerSocket plug-in

  2022-06-01 16:25:12 Views: 288
• 

  Db2 deadlock and lock timeout

  Database parameter preparation db2 create db mydb using codeset utf-8 territory CNdb2 update db cfg using cur_commit DISABLE

  2022-06-01 16:25:12 Views: 248
• 

  Generate functions containing uppercase and lowercase characters and numbers in oracle

  Function createString (n_num in number) return varchar2 isi integer default 0 * * vested token varchar2 (50) de

  2022-06-01 16:25:11 Views: 297
• 

  Start oracle 11g OEM on Linux

  [root@fmw ~] # su-oracle [oracle@fmw ~] $emctl start dbconsole

  2022-06-01 16:25:11 Views: 215
• 

  Mariadb multi-source replication

  Recently, it is a headache to do slow sql optimization. When we see that the slow sql is full of aggregate statistical sql such as select count (*) or sum, because my database is the traditional master-slave, or one master and multiple slaves, such slow sql is counted directly on the database.

  2022-06-01 16:25:06 Views: 261
• 

  Differences between Oracle database name, instance name, and service name

  DB_NAME: ① is the name of the database and cannot be more than 8 characters long. It is recorded in datafile, redolog, and control file. ② has the same DB_NAME in DataGuard environment, but DB_UNIQUE_NAME has different ③.

  2022-06-01 16:25:05 Views: 259
• 

  Oem starts the error report OC4J Configuration issue. Notfound

  The newly installed oracle 11g rac failed to start, as follows: $emctl start dbconsoleOC4J Configuration issue. / u01/app/oracle/product/1

  2022-06-01 16:25:05 Views: 292
• 

  About the use of exists

  1. The literal meaning of exists exists. The result set of the subquery in EXISTS is not empty, and the value of the EXISTS () clause is true. The subquery result set in EXISTS is empty, and the value of the EXISTS () clause is false. SELECT * FR

  2022-06-01 16:25:05 Views: 272
• 

  Some functions in Oracle

  First, compare the sign function syntax: sign (n) function description: take the symbol of the number n, greater than 0 returns 1; less than 0 returns-1; equal to 0 returns 0 example: 1, select sign (2), sign (- 2), sign (0)

  2022-06-01 16:25:05 Views: 301
• 

  Reasonably optimize database table structure to improve project execution efficiency [database design]

  Database table design optimization: sometimes in order to improve database efficiency, we can properly consider the inverse three paradigms, add redundant fields appropriately, and reduce multi-table disassociation queries. Using indexes: 2.1 Database tables should be designed to reasonably use general indexes, primary key indexes, unique indexes, full-text indexes, and composite (combination).

  2022-06-01 16:25:04 Views: 258
• 

  Redis Sentinel deployment (sentinel) (lab)

  First of all, thank you for the guidance of "Barry Highway", which opened my understanding of Sentinel. Thank you again. Redis's sentinel Sentinel is suitable for non-clustered redis environments, such as redis master-slave environments. With regard to the Sentinel cluster, I will not do an experiment here.

  2022-06-01 16:25:04 Views: 284
• 

  Advanced Redis data persistence RDB and AOF

  As we all know, the reason why Redis has good performance and fast read and write is that Redis is an in-memory database, and its operations are almost based on memory. But the memory database has a big disadvantage, that is, when the database process crashes or the system restarts, if the in-memory data is not saved,

  2022-06-01 16:24:46 Views: 284
• 

  All _ show parameters

  SYS AS SYSDBA@ORCL > SHOW PARAMETER;NAME TYPE VALUE

  2022-06-01 16:24:46 Views: 218
• 

  MongoDB Export scenario query Optimization # 1

  Original link: https://github.com/aCoder2013/blog/issues/1 reprint please indicate the source introduction some time ago encountered a similar export data scene, observation found that the speed will be slower and slower, the export of 1 million data needs to consume

  2022-06-01 16:24:42 Views: 248
• 

  Oracle Primary simple Logic backup and restore

  Oracle Primary simple Logic backup restore Note: 1, all commands are run at the cmd command prompt (type EXP HELP=Y or IMP HELP=Y for help). 2, the path folder must exist (in this case, the folder oraclebac

  2022-06-01 16:24:42 Views: 290
• 

  Semi-synchronous replication installation configuration

  Asynchronous replication (Asynchronous Replication) mysql default replication is asynchronous, the main library will immediately return the result to the client after executing the things submitted by the client, and does not judge whether the slave library has been accepted and processed, so there will be a problem

  2022-06-01 16:24:42 Views: 241
• 

  Oralce is always in the process of performing a query operation.

  Background A sudden query on a table in the morning could not be queried by the troubleshooting process to check whether the table was locked or the transaction being committed select from vested lockedtransactions from v$lock select from v$lock k, v$session SMagall.

  2022-06-01 16:24:40 Views: 202
• 

  Database Management tool Navicat Premium tutorial: from a single application

  Navicat Premium is a set of database management tools for Windows,macOS and Linux operating systems, and supports MySQL,MariaDB,MongoDB,SQL Server,Oracle,Post

  2022-06-01 16:24:31 Views: 291
• 

  The principle and function of MySQL Master-Slave replication

  This article will explain in detail the principle and function of MySQL master-slave replication, the content of the article is of high quality, so share it for your reference. I hope you can get something after reading this article. First of all, the database has a "bin-log" binary file that records all SQL

  2022-06-01 16:24:30 Views: 280