MySQL

I. Scenario: in many cases, the database administrator is often required to terminate the user process in SQL Server. This article describes how to create a simple stored procedure to terminate multiple sessions at the same time, end consecutive

When using MySQL, you must pay attention to security issues. The following are 23 notes for MySQL: 1. If the connection between the client and the server needs to span and pass through an untrusted network, you need to use an SSH tunnel to encrypt

MySQL stored procedure statements have three standard looping Methods: while loop, LOOP, and repeat loop. There is also a non-standard loop method: GOTO, but it is best to use this loop method, it is easy to cause program confusion, here is a good

As we all know, the stored procedure only appears after mysql 5. For these usage, we need to use if else while in SQL to use the stored procedure or function for instance. Mysql> DELIMITER //Mysql> create function myFunction (quantity INT (10)

Mysql> delimiter $Mysql> create procedure myProc ()-> DETERMINISTIC-> BEGIN-> DECLARE counter int default 0;->-> Simple_loop: LOOP-> SET counter = counter + 1;-> Select counter;-> IF counter = 10 THEN-> LEAVE simple_loop;-> End if;-> End loop simple_

Because log files are an important reference for restoring database data, maintenance of log files is also very important. When MySQL is used together with log files, you sometimes want to delete/back up old log files and tell MySQL to start

There are seven reasons why PHP is better than ASP: 1. speed, speed, and speed ASP is built on the COM architecture. When Using VBScript to write an ASP script, actually COM objects are used. When sending information to a user's browser, it uses the

We often encounter this problem. How can we use mysql Databases in non-web programs or asp programs? There are two solutions to this problem: 1. Use the api function library provided by mysql. Many well-known mysql client tools are implemented in

If you are running a Web application that uses MySQL, it can store passwords or other sensitive information in the application. Protecting this data from access by hackers or prophers is an important concern, because you cannot allow unauthorized

The mysqlcheck client can check and repair the MyISAM table. It can also be optimized and analyzed. The function of mysqlcheck is similar to that of myisamchk, but it works differently. The main difference is that mysqlcheck must be used when the

In Linux, after mysql is installed, the service cannot be started directly. You must initialize the database first. Initialization mainly includes: Initialize required files for logs, tablespaces, and other databases; Create and initialize the

MySQL is a cross-platform open-source relational database management system. It is the most cost-effective database we commonly use. It is small in size, fast in size, and low in total cost of ownership, in particular, the open source code feature

By searching for materials on the network and trying on your own, I think the following system parameters are critical:(1) back_log:The number of connections that MySQL can have. When the main MySQL thread receives a lot of connection requests in a

1. Make your data as small as possibleOne of the most basic optimizations is to make your data (and indexes) on the disk (and in Memory) occupy as little space as possible. This can give a huge improvement, because the disk reads quickly and usually

(1) back_log: The number of connections that MySQL can have. When the main MySQL thread receives a lot of connection requests in a very short period of time, this works, and then the main thread takes some time (although very short) to check the

First of all, I have not tried the following description only for other Windows systems. Mysql has modified the User Password format since 4.1.1, increasing from 16 bits to 41 BITs, A new verification method is adopted, but the client Protocol

From Mysql 5. after a version of x, the feature of MySQL to automatically close idle connections has been modified. For example, if a connection is idle to a timeout time (the default value is 28000 seconds and 8 hours ), re-initiated Reconnect

Take php as an Example The main cause of SQL Injection failure is WAF and manual protection code. WAF is used to intercept malicious code, but WAF bypasses the code well. The rules are dead and people are active. WAF is deployed on the server. It

First of all, I have not tried the following description only for other Windows systems. Mysql has modified the User Password format since 4.1.1, increasing from 16 bits to 41 BITs, A new verification method is adopted, but the client Protocol

To put it simply, SQL injection refers to the process of passing SQL code to the application, but it is not inserted as scheduled or expected by application developers, A considerable number of programmers did not judge the legitimacy of user input