Tag:The database

  • Pymysql opens debug mode

    Time:2019-10-24

    Today in the troubleshooting line a strange database connection problem, so open pymysql source code in reading, found pymysql in itsconnectionsOne is built into the moduleDEBUGVariable to control whether debugging mode is enabled, and if so, the operation of the current connection and the contents of the message are printed to the console. Method of […]

  • PD scheduling policy best practices

    Time:2019-10-24

    Author: huang menglong It is well known that PD is the core of the whole TiDB cluster, is responsible for the overall meta information storage and TiKV cluster load balancing scheduling, this paper will detail the principle of PD scheduling system, and through the analysis of several typical scenario and handling, share the scheduling strategy […]

  • MySQL creates and authorizes users

    Time:2019-10-24

    I. create users 1. Root user (administrator) logs in and enters mysql database mysql> use mysql Database changed 2. Create users 1. Create users: # specify Sroxi user login with IP: 192.168.43.144 create user ‘Srox’@’192.168.43.144’ identified by ‘123’; # specify IP: 192.162.43. Sroxi user at the beginning of login create user ‘Sroxi’@’192.118.1.%’ identified by ‘123’; […]

  • Learn SQL injection —1

    Time:2019-10-24

    Began to contact SQL injection, the first line of thinking according to the Internet did two injection, but for SQL injection how to achieve, how a process or do not understand. Later, on the Internet to find a lot of information, now a little bit to understand. 1, use sqlmap injection, not all pages can. […]

  • ORACLE ORION tests IO performance

    Time:2019-10-23

    https://www.oracle.com/technetwork/cn/topics/index-088165-zhs.html to download the address OrionisOracleProvides IO performance testing tools that do not require installation to runoracleDatabase software or create a database. It can simulateOracleDatabase IO load is also availablewithTo simulate ASM banding function Download after decompression can be used directly Write the device you want to test to a file in the same path, […]

  • The vbscript code that reads the Access database is packaged and downloaded

    Time:2019-10-23

    The effect is shown as follows:Core code: Copy the codeThe code is as follows: Option Explicit Dim arrTables( ), i, idxTables, intValidArgs Dim blnContent, blnFieldNames Dim objConn, objFSO, objRS, objSchema Dim strConnect, strHeader, strOutput Dim strFile, strResult, strSQL, strTable Const adSchemaTables = 20 ‘ Check command line arguments With WScript.Arguments If .Unnamed.Count = 1 Then […]

  • 12 gestures that enterprises use databases

    Time:2019-10-23

    Database, as the basic software of IT system, plays a very great role. So what are some of the ways in which an enterprise can choose to use a database? What are the characteristics of different ways? This paper will analyze twelve situations (the first six are local and the last six are cloud-based) from […]