ISADBA | FH. CN

* Isadba | -- effortsofgenius -- * Django framework ORM Operation Details ISADBA | FH. CN is published in 2014-12-2903: 18: 22 directory 1.1.1 generate query 1.1.2 create object 1.1.3 save modified object 1.1.4 save ForeignKey and ManyToManyField 1.1.5 search object 1.1.6 search all objects 1.1

/* Is a dba | -- efforts of genius -- */Django framework ORM Operation Details ISADBA | FH. CN was published on 03:18:22 directory 1.1.1 generate query 1.1.2 create object 1.1.3 save modified object 1.1.4 save ForeignKey and ManyToManyField 1.1.5 search object 1.1.6 search all objects 1.1

/* Is a dba | -- efforts of genius --*/

Django framework ORM Operation Details

ISADBA | FH. CN published on 03:18:22

Directory 1.1.1 generate query 1.1.2 create object 1.1.3 save modified object 1.1.4 save ForeignKey and ManyToManyField 1.1.5 search object 1.1.6 search all objects 1.1.7 filter search specific object 1.1.8 link filter 1.1.9 filter result set is unique 1.2.1 The result set is delayed. 1.2.2 Other QuerySet Methods 1.2.3 restrict QuerySets 1... Read the full text

Install MySQL slow query log tool Anemometer

ISADBA | FH. CN published on 01:29:59

First install LNMP environment, require PHP-5.3 and above versions. Reference :? P = 82 or reference? P = 572 then download Anemometer git clonehttps: // github.com/box/Anemometer.git anemometer configure LNMP to deploy the downloaded anemometer to LAMP. You can open the page through the web... Read the full text

Pt-query-digest

ISADBA | FH. CN published on 01:07:31

MYSQL

1. pt-query-digest parameter introduction. [code snippet]-filter: filter the input slow query by matching the specified string before analysis-limit limits the percentage or quantity of output results. The default value is 20, it is about to output the slowest 20 statements. If it is 50%, the total response time is sorted from large to small, and the output reaches 50%. -Host mysql server address-user mysql user name... Read the full text

Analysis of python metaclass

ISADBA | FH. CN published on 07:48:06

1. What can you get from here? 1. You may have encountered metaclass while reading other people's code. You can refer to the introduction here. 2. maybe you need to design some underlying libraries. Maybe metaclass can help you simplify your design (and possibly complicate it. maybe you know more about the mechanisms of python classes after learning about metaclass. 4. more ...... What is the role of metaclass? (Perceptual knowledge )... Read the full text

Use sublime Text3 for python IDE in Windows 7 (1)

ISADBA | FH. CN published on 03:21:40

1. Download and install sublime text3. 2. Download the python-2.7 installation package (there is an option during installation. Check whether to write environment variables .). 3. After installing python, right-click your computer and choose Properties> advanced system Settings> environment variable> Path environment variable to check whether the python installation directory is included, if not, set it manually. 4. Test whether python environment variables are installed. ctrl + r call up the running window. enter python directly to see if py... Read the full text

Sorting MySQL thread pool data-Percona Server

ISADBA | FH. CN published on 05:45:58

About MySQL thread pool data sorting-Percona ServerMySQL executes statement to connect a thread. When the number of connections increases to a certain point, the performance will begin to decrease. the role of this feature is to ensure the best performance regardless of the number of connections. the thread pool principle is mainly to reduce threads, reduce context switching and lock resource competition, especially effective for OLTP environments. to enable thread po... Read the full text

Python-connect to the MySQL database

ISADBA | FH. CN published on 08:26:09

Python connects to the MySQL database to operate Python. There are two modules available for MySQL. MySQLdb module and mysql. connector module. MySQLdb module: # encoding: UTF-8 #! /Usr/bin/pythonimport MySQLdb # Step 1. Open the database connection db = MySQLdb. connect ("localhost", "testuser", "test123 &... Read the full text

Slave replication exception

ISADBA | FH. CN published on 07:54:48

MysqlMYSQL

The following are two types of slave replication exceptions. The reason is that the slave Data Center suddenly loses power due to cross-Data Center synchronization. Case 1: the major cause of this error is that the pos Number of Read_Master_Log_Pos: 1028687822 does not exist on the master database. solution: Obtain the previous pos Number Of This pos number and enable synchronization again. Note that if it is in row mode, there is no problem. if it is a mix or statement, you need to analyze the binlog to confirm the specific execution... Read the full text

How to execute system commands in python

ISADBA | FH. CN published on 02:24:04

PYTHONCODE

I. OS. system # only run system commands on a sub-terminal, but cannot obtain the returned information after the command is executed. system (command)-> exit_statusExecute the command (a string) in a subshell. # If you execute the command line, the result is printed directly [code snippets] II. OS. popen # This method not only executes commands, but also returns the information object after execution popen (command [,... Read the full text

Python Decorator usage

ISADBA | FH. CN published on 14:02:02

It took me some time to learn about the Python decorator over the past few days. In fact, I have read the relevant content in the book before, but I didn't understand it at the time. Today, I want to share my experience with you. There have been a wide spread on the Internet. There are two articles on python decorators, one on CSDN and the other on the garden. The link is as follows: http://www.cnblogs.com/h... Read the full text

Python-platform Module

ISADBA | FH. CN published on 07:20:26

Import platformplatform. platform () # obtain the operating system name and version number, 'windows-7-6.1.7601-SP1 'platform. version () # obtain the OS version number, '6. 1.7601 'platform. architecture () # obtain the number of digits of the operating system... Read the full text

Introduction to the Python-ConfigParser Module

ISADBA | FH. CN published on 07:05:07

1. ConfigParser Introduction: ConfigParser is a package used to read the configuration file. The configuration file format is as follows: section is included in the brackets. Section contains configuration content similar to key-value. 1: [db] 2: db_host = 127.0.0.13: db_port = 224: db_user = root5: db_pass = rootroot6: 7: [co... Read the full text