MySQL

The database uses locks to support better concurrency, providing data integrity and consistency. InnoDB is a storage engine that supports row locks with the following types: Shared Lock (S), exclusive lock (X), Intent Share (IS), intent Exclusive

Modify Table: Add field: alter table yyh_yp_managerrob add catid smallint (5), Add typeid smallint (5), Add areaid smallint (5), Add Title char (150), Add style char (5), Add thumb char (100), Add keywords char (40), Add description char (255),

Today, we need to migrate a database of about 26 MB to my desktop. So I used heidisql on other machines to export the database into a large SQL file, which contains the database structure and data. Probably because the data volume imported at a

We always hope to avoid full table scanning by the database engine when doing some queries, because the full table scan takes a long time, and most of the scans do not make sense to the client. Which of the following methods can be used in MySQL to

I compiled mysql-proxy 0.6.0 in centos 5.0. MySQL 5.1.22 RC has been installed before. To compile mysql-proxy 0.6.0, Lua 5.1 and glib 2.6.0 or later versions are required. Centos 5 does not have a Lua package. Download The Lua 5.1.2 source code,

Summary of small tips commonly used in six MySQL statements 1) For example, to calculate the current size of a person, assume that the variable of the person's birthdate is @ dateofbirth,ThenSelect date_format (from_days (to_days (now ()-to_days

I will continue to solve the index problem of MySQL this time. There are still many principles that can be summarized as follows: 1. For composite indexes, if one of the leftmost query conditions is used,For example, if an index (a, B) exists,

Recently, when I was tuning MySQL, I felt that the query cache of MySQL was not as big as possible, Because the cache actually fails when the data table changes as follows: Including insert, update, delete, truncate, alter table, drop table,

I. IntroductionA Perl application database uses the DBM package configured by itself to create and operate a database, therefore, the DBM package and other similar packages can be considered as a database extension. The other is to use the DBI

Write a test program when using C in Linux to operate MySQL database Int main (void) { MySQL m_mysql; mysql_init (& m_mysql ); const char plocalhost [] = "localhost"; const char puser [] = "root "; const char ppass [] = "123456"; const char

1. Full table Scan If you want to find a highly selective record, you can use an index. However, if you find a large amount of data, such as more than 20%, The optimizer does not use indexes, but scans the entire table. 2. Sequential read: it

Let's take a look at the concept of MySQL asynchronous replication: Asynchronous replication: MySQL supports one-way and asynchronous replication. Asynchronous replication means that there is a latency when copying data from one machine to

We can see the concurrent_insert parameter today and explain it as follows: The MyISAM storage engine has a system variable concurrent_insert, which is used to control its Concurrent Insertion behavior. The values can be 0, 1, or 2,

At the same time, the online access volume continues to increase. For servers with 1 GB of memory, the server even crashes every day or gets stuck from time to time. This problem has plagued me for using MySQL for more than half a month. scalable

Overview of log file types:1.The error log records the problems that occur when you start, run, or stop mysqld.My. ini configuration information:# Enter a name for the error log file. Otherwise a default name will be used.# Log-error =

The following describes how to use Bae to connect to MySQL. The basic call is the same as the related MySQL functions of PHP: Mysql_query-send a MySQL Query Mysql_fetch_array-get a row from the result set as an associated array, or number array, or

Import java. SQL .*; Public class testjdbc { Public static void main (string [] ARGs ){ Resultset rs = NULL; Statement stmt = NULL; Connection conn = NULL; Try { String url = "JDBC: mysql: // 127.0.0.1: 3306/Multi "; String user = "root "; String

#!/bin/sh##install mysql database#echo -e "/n/n"while echo -en "/nAre you sure install mysql database now (yes/no)?";read qrdo if [ "$qr" = "yes" ]; then break elif [ "$qr" = "no" ]; then exit 1 fidonewhile echo -en "/nPlease input install

1. applications (such as PHP) execute MySQL statements in batches for a long time. The most common is collection or conversion of New and Old data. Solution: Add or modify the following two variables in the my. CNF file: Wait_timeout =

First, go to the Linux system. The database is MySQL, which contains database: bugs. Create a directory in/root: mkdir dbbak, and then create a directory in dbbak: mkdir bugsbak VI mysql_bugs.sh/* Create a mysql_bugs.sh file */ Enter two rows of