Percona MySQL View Tables Not Accessed

It's really hard to find out if a table in an instance has access.( A common method is to open a tcpdump or tshark persistent packet to filter suspected table names.( However, if we were using MySQL from the Percona branch, this would be much easier. Under Percona MySQL, we can open the userstat parameter and query the system statistics tabl ...

Posted on Sun, 28 Jun 2020 12:51:50 -0400 by Sno

Data mining -- common data preprocessing

0. Read and write data (1) Read txt file #Read txt and splice data import pandas as pd data=pd.read_table('1.txt', delimiter=',',dtype={'id':'int32','index':'int8'}) all=data.merge(data2,on='id',how='left').merge(data3,on=['id','index'],how='left') (2) Read and save list file Note: if the list i ...

Posted on Fri, 12 Jun 2020 02:41:25 -0400 by catalinus

[Linux command] Chapter 15 planning task (crontab) of "brother bird Linux foundation"

Chapter 15 planning tasks (crontab) 15.2 what is a planned task Remind regularly or when the conditions are met. 15.1.1 types of Linux planned tasks: at, cron Routine: matters to be done at regular intervals; Unexpected: not after this time Types of planned tasks: At: can handle commands that ...

Posted on Fri, 12 Jun 2020 01:27:11 -0400 by antwown

Linux command (35) du command

du command Function Description: display the size of file or directory The du command displays the size of the disk space occupied by the specified directory or file, without any options. The default unit is 1KB. Usage: Du [option] [file] option option explain -a Recursively display the disk space occupied by each file and subdirecto ...

Posted on Wed, 03 Jun 2020 10:37:51 -0400 by nirali35

Django framework 7: configuring caching

1, Django cache Description: In the dynamic website, the data of the website visited by users changes in real time according to the content of the database. In this way, there will be a problem: frequent refresh of the client will affect the performance of the server's database. Using the cache, you can put some data that does not need to be r ...

Posted on Tue, 02 Jun 2020 11:06:04 -0400 by blizzard

You robbed so many red envelopes. Do you know how it works?

With the popularity of electronic payment, red envelopes are very popular in social software such as wechat nails. Generally, the amount of red envelopes does not need to be very large, which can achieve the way to improve everyone's enthusiasm. In fact, robbing red envelopes is more of a pastime. It's a joy that can't be imagined. As our tra ...

Posted on Mon, 25 May 2020 23:16:21 -0400 by wee_eric

Python:sip Compilation and Use

1. Compile sip source code Unzip the sip source and run PythonConfigure.py-p win32-g++ (win32-g++ means using the mingw32 compiler). Modify generatedSipconfig.pyFile.When Python is installed in the C:\Program Files (x86) directory, place _Pkg_Program Files (x86) in config was replaced with Progra~2, as follows: _pkg_config = { 'arch': ...

Posted on Mon, 25 May 2020 12:21:04 -0400 by endersix

Build / dev/kmem to enumerate all Linux kernel modules (including hidden ones)

Can Linux system have lsmod to enumerate all kernel modules? Isn't procfs fragrant? Why bother enumerating from / dev/kmem? In fact, Linux is a later thing. In the initial UNIX era, enumeration processes such as ps were scanned from / dev/kmem, which is all files Later, the Linux kernel expanded procfs inappropriately, and put all kinds of mes ...

Posted on Sat, 16 May 2020 23:53:43 -0400 by sanderphp

Play redis delay message queue

In the previous article, the redis based list implemented a simple message queue: Play redis simple message queue Source address Using demo Product manager often said that we should not only have X function, but also Y function, so that customers can be more satisfied. Similarly, it is not enough to have a simple message queue, and a del ...

Posted on Wed, 06 May 2020 01:05:18 -0400 by tomz0r

Unix Domain Socket

add by zhj: Unix Domain Socket is the optimization of network socket, which is applicable to the situation that the server and the client are on the same machine. Compared with network socket, it can improve communication efficiency Original text: https://www.jianshu.com/p/dc78b7ca006a Author: Meopas 0 μ 0 Source: Jianshu Recently, when ...

Posted on Tue, 05 May 2020 09:12:19 -0400 by rockroka