MySQL Processlist -- View the SQL status of session execution

For MySQL version 5.7, you can use the sys.session view to view the last SQL executed by the session: SELECT * FROM sys.session WHERE CONN_ID = 20036 \G The sys.session view is associated with sys.processlist, and sys.processlist uses `performance_schema'. `events_statements_current'. If you want to query the SQL situation that a ses ...

Added by titeroy on Wed, 31 Jul 2019 03:35:29 +0300

Detailed Explanation of Set Lambda Expressions

# Set Lambda expression Language: Suitable for server development: JAVA.net PHT c++, c ASP golang python... Front end: ios android H5 jsp... Database: MySQL Oracle BD2 Hbase MonggoDB redis, SQL sever... Big data: hadoop flume spark hive yarn zonokeeprer kafka sqoop,HDFS mr,scala... Lambda expression ...

Added by 938660 on Tue, 30 Jul 2019 16:55:13 +0300

myBatis: sql execution process

Reprinted from the excellent articles of Nanke Meng Brothers: https://www.cnblogs.com/dongying/p/4142476.html 1. SqlSession Factory and SqlSession. Through the introduction and use of mybatis in the previous chapters, we can all appreciate the importance of SqlSession. Yes, on the surface, we all u ...

Added by Otoom on Tue, 30 Jul 2019 12:54:38 +0300

My docker essays 15: MySQL automatically creates databases at startup

Background and Analysis When the MySQL container starts up, it automatically creates some necessary databases, such as MySQL, which is the official default. However, in practice, we also need to let MySQL create our own custom database automatically. This paper explores the application occasion. The ...

Added by rekha on Mon, 29 Jul 2019 17:14:18 +0300

Mybatis Source Code Analysis

In this article, we will read the source code of Mybatis in depth, hoping that we can not be so afraid of the underlying framework in the future, and learn the good ideas of framework design; Architectural principles Architecture diagram Architectural flow chart The two pictures above are from the internet, but they are very good. They basi ...

Added by mjlively on Sun, 28 Jul 2019 16:17:06 +0300

MySQL for Goang Fragmentation

MySQL is a commonly used relational database. This paper introduces how to operate MySQL database in go language. Go Manipulates MySQL Connect The database/sql package in Go language provides a wide range of interfaces to guarantee SQL or quasi-SQL databases, and does not provide specific database drivers. A database driver must be injected wh ...

Added by yhchan on Sat, 27 Jul 2019 12:09:48 +0300

python object-oriented advanced programming using metaclasses

Using metaclasses type() The biggest difference between dynamic and static languages is the definition of functions and classes, which is not defined at compile time, but created dynamically at run time. For example, if we want to define a Hello class, we write a hello.py module: class Hello(object): ...

Added by trube on Thu, 25 Jul 2019 13:20:30 +0300

Django Model Layer Multi-table Operation

Django model layer (2) multi-table operation Create a model Relationships between tables and tables One-to-one, many-to-one, many-to-many # The information commonly used in the author's table is placed in this table. class Author(models.Model): name=models.CharField(max_length=32) age=models.IntegerField() authorDetail=models.OneToO ...

Added by SunsetKnight on Thu, 25 Jul 2019 09:47:51 +0300

Introduction to SCOM ManagementPack [Eighth of the Chinese Series of SCOM]

Original Link: http://www.cnblogs.com/OpsMgr/archive/2011/04/15/2017037.html ManagementPack can be seen as an extension package that extends SCOM functionality, importing the appropriate MP can monitor things that need to be monitored, ...

Added by jonabomer on Thu, 25 Jul 2019 01:51:37 +0300

LINQ Path: LINQ Extension

Original Link: http://www.cnblogs.com/jellochen/p/the-extension-of-linq.html This article describes LINQ extensions in three ways: extended query operators, custom query operators, and simple simulation of LINQ to SQL. 1. Extended Query ...

Added by iamthebugman on Tue, 23 Jul 2019 19:28:42 +0300