NAV: SLTechnology News&Howtos > Database >

• 

  The solution to the problem that the BLOCK_ID of a partitioned table or partitioned index is so large that DATAFILE cannot be RESIZE

  The preface recently found that the performance machine with 3T disk space has insufficient disk space, and the machine mainly deploys ORACLE database, so the guess is likely to be caused by the change of tablespace data file. Next, you need to troubleshoot the problem step by step, and finally confirm that it is ORACLE.

  2022-06-01 17:43:34 Views: 288
• 

  Drbd+Heartbeat+Mysql Master / Slave High availability

  First, the preparation work system: Centos6.5 two hosts need to resolve each other's domain name primary node (Primary Node) secondary node (Secondary Node) host name ser5.hyzc.comser6.hyzc.comIP address 1

  2022-06-01 17:43:34 Views: 265
• 

  Analysis of JNDI / DataSource / ConnectionPool

  Recently, there is a web application with a large number of 5W-10W users, which frequently causes weblogic to crash, which makes the operation and maintenance team very uncomfortable. By tracking the system log and the operation of weblogic for several days, it is found that there are many postures that report errors, among which the error reports are more critical to the location problem.

  2022-06-01 17:43:25 Views: 258
• 

  Mongodb implements the SUM of the sum of a column

  Mongodb data are as follows: db.cpc_0103.find () {"a": 8, "b": "108177 / 200701010000", "c": 108177, "d": 180, "e":

  2022-06-01 17:43:24 Views: 210
• 

  Ora-600 [kcblasm_1] bug treatment (2)

  6. Compile the database. Cd $ORACLE_HOME/rdbms/adminsqlplus / nologSQL > CONNECT / AS SYSDBASQL > STARTUPSQL > @ catbundle

  2022-06-01 17:43:24 Views: 217
• 

  Redis common commands-key value related commands

  Keys returns all key that satisfies a given pattern, such as: keys * exists confirms whether a key exists, such as: exists namedel deletes a keyexpire, sets the expiration time of a key (in seconds) such as: exp

  2022-06-01 17:43:24 Views: 301
• 

  Automatic initialization of SQL Server 2017 AlwaysOn AG (7)

  Enable automatic seeding of a secondary copy on an existing availability group to execute ALTER AVAILABILITY GROUP [] MODIFY REPLICA ON''WITH (SEEDING_M) on the primary replica

  2022-06-01 17:43:24 Views: 237
• 

  Help for using commands in Linux

  First, get help at multiple levels Whatis this command query depends on the background database, the database stores a simple description of the executed command, this database is generated under specific circumstances, there may be a newly installed system this database does not exist, the system will automatically install for a period of time

  2022-06-01 17:42:54 Views: 205
• 

  How MySQL queries data by instantiating object parameters

  The following mainly brings you MySQL how to query data by instantiating object parameters. I hope these contents can bring you practical use. This is also the main purpose of this article that I edit MySQL how to query data by instantiating object parameters. All right, no more nonsense, let's just take a look at it.

  2022-06-01 17:42:53 Views: 212
• 

  What are the uses of MVCC in MySQL

  This article mainly gives you a brief account of the usage of MVCC in MySQL. You can look up the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope this article on the use of MVCC in MySQL can bring you

  2022-06-01 17:42:53 Views: 216
• 

  The cause of mysql has gone away error reported by mysql in PHP Program and its solution

  This article mainly introduces the causes and solutions of the mysql has gone away error in the PHP program mysql. The content of the article is carefully selected and edited by the author, which is of certain pertinence and is of great significance to everyone's reference. Let's learn together with the author.

  2022-06-01 17:42:53 Views: 301
• 

  PXC-- state parameters and variable parameters

  "galera parameter parsing:" 1. Status parameter:-- wsrep_last_committed: indicates the latest transaction number of the current node, which is also the second half of the latest galera GTID. The first half is the parameter wsrep_local.

  2022-06-01 17:42:52 Views: 272
• 

  A simple understanding of mysql log management

  This article is mainly about the log management of mysql, if you are interested, let's take a look at this article. I believe it is of some reference value to everyone after reading the log management of mysql. / etc/my.cnferror log error log troubleshooting

  2022-06-01 17:42:52 Views: 296
• 

  The solution of restarting error report after mysql8 modifies my.ini configuration

  The following is about the solution to restart the error report after mysql8 modifies the my.ini configuration. The secret of the text lies in being close to the topic. So, let's not talk about gossip. let's just read the following. I believe that after reading this article on how to restart the error report after mysql8 modifies the my.ini configuration.

  2022-06-01 17:42:52 Views: 241
• 

  Introduction to mysql trigger Writing template

  The following brings you about mysql trigger writing template, if you are interested, let's take a look at this article, I believe that reading mysql trigger writing template will be of some help to you. The trigger of mysql is the response of a table to insert,delete,upd

  2022-06-01 17:42:52 Views: 214
• 

  Prevent malicious code from being injected into XSS (cross site scripting)

  Login.PHP page login page username password LoginController.PHP page login authentication

  2022-06-01 17:42:51 Views: 239
• 

  Installation and use of mysql third-party tools percona-toolkit

  The percona-toolkit toolkit, like percona-xtrabackup, is written in Perl. The percona-toolkit toolkit is a set of advanced toolkits for managing mysql that can be used to perform various manual operations.

  2022-06-01 17:42:51 Views: 216
• 

  How to modify deeply nested objects with mongodb and spring boot

  How do I modify deeply nested objects with mongodb and spring boot? This article uses the example code to show, the code is very detailed, which can be used for reference by interested friends. I hope it will be helpful to you. 1. Development environment: mongodb+spring b

  2022-06-01 17:42:51 Views: 258
• 

  A brief introduction to case sensitivity of MySQL

  Let's learn about MySQL case-sensitive, I believe you will benefit a lot after reading, the text is not much, hope that MySQL case-sensitive this short content is what you want. [Linux] lower_case_table_names=0

  2022-06-01 17:42:50 Views: 211
• 

  Introduction to setting up the mysql character set

  The following mainly brings you the playbook of setting the mysql character set. I hope these contents can bring you practical use, which is also the main purpose of this article that I edit the mysql character set. All right, don't talk too much nonsense, let's just read the following. Configuration file path: / full

  2022-06-01 17:42:50 Views: 205