MySQL

Copy codeThe Code is as follows:Create database MyDbOn(Name = mainDb,Filename = 'C: \ MyDb \ mainDb. mdf ',Size = 10,Maxsize = 100,Filegrowth = 4),(Name = secondDb,Filename = 'C: \ MyDb \ secondDb. ndf ',Size = 15,Maxsize = 28,Filegrowth = 2)Log

System: Ubuntu 10.10Mysql source file: mysql-5.5.8.tar.gzInstall required tools: cmake, GNU make, gcc, Perl, libncurses5-dev, bison (optional), chkconfigNote:1. There are several bugs in the official source code from, which were manually modified by

In addition to the index of different table names, the table structure is the same. If the 'id' field of each table still adopts the 'Auto _ INCREMENT 'method, ID cannot identify only one record.In this case, an External table shard mechanism is

I can see the post on "http/rest client" on the blog of Zhang banquet. I will skip all the installation steps. Next I will go directly to the test stage: virtual machine.Copy codeThe Code is as follows:[Root @ localhost ~] # Uname-Linux sunss 2.6.18-

MySQL writes data through common insert statements, suchCopy codeThe Code is as follows:Insert into person values (Zhang San, 20), (Li Si, 21), (Wang Wu, 70 )...; However, sometimes to insert a large volume of data or exchange data more quickly, you

The output result of the processlist command shows which threads are running. This command can be used to identify problematic query statements.1. Enter mysqladmin processlist In the mysql/bin directory;2. Start mysql and enter show processlist;If

Solution:1. Change the table. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to mysql on the computer of localhost, and change the "host" entry in the "user" table in the

You can test the database test, table bintest, and data field data type by using LONGBLOB in the middle line of the DBMS.// Test file c: \ test. iso. You can find any file and change it to an exe program and test. iso.// The maximum size of Files

1. character_set_server and collation_server These two variables are the server's character set. When the system is started, you can use -- character-set-server and -- collation-server to set them. If not, the system sets the two variables to the

First of all, we should note that the daily access volume is not as large as of the daily access volume. In principle, a doubling of the access volume should also be sufficient for such servers. But why does our Server Always restart frequently?

There are several possible causes for serious performance problems:1. The index is not created;2. SQL statements are too complex;3. Configuration Error;4. The machine cannot be loaded;1. Index not createdIf you see that mysql consumes a lot of cpu,

1. Connect to the mysql database 1. Open cmd to enter the dos window.2. Switch to the directory: D: \ MySql5.0 \ mysql-5.0.51b-win32 \ bin (that is, the bin directory under the mysql installation directory, which contains a lot of exe execution

Mysql my. ini configuration file details# BEGIN CONFIG INFO# DESCR: 4 gb ram, only InnoDB, ACID, a small number of connections, large queue Load# TYPE: SYSTEM# END CONFIG INFO## This mysql configuration file example is for 4 GB memory# Mainly use

1. select the most suitable field attribute MySQL can support access to large data volumes, but generally, the smaller the table in the database, the faster the query will be executed on it. Therefore, when creating a table, we can set the field

MySQL performs a full table scan under the following conditions:1> the data table is too small, and a full table scan is much faster than the search for the index key. This is usually done when the total number of records in a table is less than 10

1. Call method of myisamchkMyisamchk [options] tbl_name...Options specifies what you want myisamchk to do.It allows you to specify all tables in a directory by using the "*. MYI" mode.Shell> myisamchk *. MYIWe recommend that you quickly check all

If TMPDIR is not set, MySQL uses the default value of the system, usually/tmp,/var/tmp, or/usr/tmp. If the file system that contains the temporary file directory is too small, you can use the "-tmpdir" option for mysqld to specify a directory in the

If you want to run multiple servers, the easiest way is to recompile the server with different TCP/IP ports and socket files, so they do not listen on the same TCP/IP Port or socket.Assume that an existing server is configured as the default port

PrincipleQueryCache (QC) is cache based on SQL statements. If an SQL query starts with select, the MySQL server will try to use QC for it. Each Cache is saved using SQL text as the key. SQL text is not processed before QC is applied. That is to say,

Why is there no cgi in the system category?I haven't published any original articles for a long time. I 've been writing CGI programs on the architecture server.It started with perl for a few days, and later found that some of the regular