Fault analysis | effectively solve the timeout problem of MySQL row lock waiting [recommended collection]

By xuty Source: original contribution *Aikesheng is produced by the open source community. The original content cannot be used without authorization. Please contact the editor for reprint and indicate the source. 1, Background #### 20191219 10:10:10,234 | com.alibaba.druid.filter.logging.Log4jFilter.statementLogError(Log4jFilter.java:152) ...

Posted on Tue, 21 Apr 2020 02:02:36 -0700 by oyse

freecplus framework MySQL database operation

1, Source code description Freecplus is a C/C + + open source framework under Linux system. Please go to the C language technology network (www.freecplus.net) to download the source code. This paper introduces the use of connection and sqlstatement classes to operate MySQL database in freecplus framework. The declaration file of the class is f ...

Posted on Mon, 20 Apr 2020 09:34:46 -0700 by dkoolgeek

Using SpringBoot+Vue to realize message board

Starting at Enaium's personal blog Complete source code 1, New Vue project and SpringBoot project New Vue project New folder springboot Vue messageboard Create a Vue project using the vue ui command (requires vue 3.0 Select the directory just now After the name is Vue created, V or lowercase can be changed to uppercase Cancel git initiali ...

Posted on Mon, 20 Apr 2020 07:59:09 -0700 by idotcom

Learning notes of c-orm: T4 introduction and database entity generation

What is T4? 1.1 T4 introduction T4, the four letter combination with t beginning: Text Template Transformation Toolkit, is the code generation engine officially used by Microsoft in Visual Studio 2008. T4 is a mixed template composed of some text blocks and control logic. In short, T4 can generate the files you want according to the template, s ...

Posted on Mon, 20 Apr 2020 02:22:18 -0700 by youscript

Pycharmimplementation (Django's model, forms, management tools, introduction of static files)

1, Django model (PyCharm Implementation) Django provides good support for various databases, including PostgreSQL, MySQL, SQLite and Oracle. Django provides a unified calling API for these databases. We can choose different databases according to our business needs. Mysql is the most commonly used database in Web applications. In this chapter, ...

Posted on Sat, 18 Apr 2020 10:05:03 -0700 by sanam

Application and summary of sequence in MySql

The sequence in Mysql is mainly used for the primary key, which is an incremental field and cannot be repeated. Mysql is different from Oracle in that it does not support the original sequence, and it needs to use the combination of tables and functions to achieve similar sequence functions. 1. First create the main table of the sequence /* N ...

Posted on Sat, 18 Apr 2020 07:58:14 -0700 by dominicd

014.Docker Harbor+Keepalived+LVS+Shared Storage High Availability Architecture

More than one introduction to Harbor High Availability Shared back-end storage is a standard solution for sharing multiple Harbor instances with the same back-end storage, and any instance that persists to a stored image can be read by other instances.Pre-LB components, such as Keepalived, can be shunted to different instances for processin ...

Posted on Fri, 17 Apr 2020 11:51:37 -0700 by jbingman

JDBC mysql large data streaming read

Summarize some problems and solutions in the use of mysql driver to help customers to generate reports next week. Because the logic of report generation needs to read a lot of data from the database and process it in memory, then generate a lot of summary data and write it to the database. The basic process is read - > process - > write.A ...

Posted on Fri, 17 Apr 2020 10:19:16 -0700 by sebthib55

When using limit paging query, do delete operation, which will result in data loss

Catalog When using limit paging query, do delete operation, which will result in data loss 1, Prepare data 1.1 mysql data script 1.2 code Two, validation 1. All data before verification 2. Data on the first page 3. Delete records 4. Add record 5. Data on the second page 6. Data after verification 7. log Three. Conclusion Four, suggesti ...

Posted on Wed, 15 Apr 2020 09:18:15 -0700 by roadkillguy

Issue 02: Art of MySQL data type - large object field

I've shared one before MySQL big object example , let's talk about the advantages and disadvantages of large objects and the use scenarios in detail today. We divided MySQL's large object types into TEXT / BLOB and JSON to illustrate. 1, TEXT / BLOB type The difference between TEXT and BLOB is very simple. TEXT is stored in plaintext, with cor ...

Posted on Wed, 15 Apr 2020 01:52:58 -0700 by Daen