CN105373623A - Method for quickly generating big data in custom table - Google Patents

Abstract

The invention relates to the technical field of databases, in particular to a method for quickly generating big data in a custom table. The method provided by the invention comprises the following steps: firstly, generating data in a memory table by a function and a memory process according to the characteristic of a high mysql memory table insertion speed; and then inserting the data into the custom table from the memory table, so as to quickly generate the big data in the custom table. According to the method, the problem of quickly generating the big data in the custom table is solved; and the method can be applied to data processing of tables.

Description

A kind of method generating large data fast in user-defined data table

Technical field

The present invention relates to database technical field, particularly a kind of method generating large data fast in user-defined data table.

Background technology

MySQL is a Relational DBMS, and memory table uses Hash hash index to store the data in internal memory, therefore has the speed be exceedingly fast; If the data processing of user-defined format form can be used for, will greatly promote the efficiency of data processing.

Summary of the invention

The technical matters that the present invention solves is to provide a kind of method generating large data fast in user-defined data table, solves the problem generating large data fast in user-defined data table.

The technical scheme that the present invention solves the problems of the technologies described above is:

The feature that described method is fast according to mysql memory table insertion speed, first utilizes function and storing process to generate data in memory table, and then data is inserted user-defined data table from memory table, thus in user-defined data table, generates large data fast.

Described method comprises following step:

Step one, establishment user-defined data table userInfo;

Step 2, create the memory table userInfo_memory identical with user-defined data table;

Step 3, realize in memory table, generate large data function rand_struserid and storing process add_userInfo_memory, and require that userid is 18, be made up of at random letter and number;

Step 4, adjustment System internal memory, arranging memory parameters max_heap_table_size is 5000M;

Step 5, Calling Stored Procedure add_userInfo_memory, the large data required for raw in memory table;

Step 6, employing SQL statement are inserted into data in user-defined data table from memory table.

Beneficial effect of the present invention: the feature fast according to mysql memory table insertion speed, first function and storing process is utilized to generate data in memory table, and then from memory table, data are inserted user-defined data table, thus reach the object generating large data fast in user-defined data table.

Accompanying drawing explanation

Below in conjunction with accompanying drawing, the present invention is further described:

Fig. 1 is method flow diagram of the present invention.

Embodiment

As shown in Figure 1, the present invention adopts following steps, the feature that the present invention is fast according to mysql memory table insertion speed, first function and storing process is utilized to generate data in memory table, and then from memory table, data are inserted user-defined data table, thus reach the object generating large data fast in user-defined data table.

Step one, establishment user-defined data table userInfo; As:

createtable`userinfo`(

`id`int(4)NOTNULLauto_increment，

`userid`varchar(20)NOTNULL，

`username`varchar(20)NOTNULL，

`createtime`datetimeNOTNULL，

PRIMARYKEY(`id`)

)ENGINE＝InnoDBDEFAULTCHARSET＝utf8；

Step 2, create the memory table identical with user-defined data table;

createtableuserInfo_memory(

`id`INT(11)NOTNULLAUTO_INCREMENT，

`userid`varchar(20)NOTNULL，

`username`varchar(20)NOTNULL，

`createtime`datetimeNOTNULL，

PRIMARYKEY(`id`)

)ENGINE＝MEMORYDEFAULTCHARSET＝utf8；

Step 3, realize in memory table, generate large data function and storing process, and require that userid is 18, be made up of at random letter and number.

Step 4, adjustment System internal memory, arrange memory parameters max_heap_table_size

The size of internal memory is used to be specified by the max_heap_table_size in My.cnf, setting max_heap_table_size=5000M,

Step 5, Calling Stored Procedure, the large data required for raw in memory table;

calladd_userInfo_memory(999999)

Step 6, employing SQL statement are inserted into data in user-defined data table from memory table.

insertintouserInfoselect*fromuserInfo_memory。

Claims (2)

1. one kind generates the method for large data fast in user-defined data table, it is characterized in that: the feature that described method is fast according to mysql memory table insertion speed, first function and storing process is utilized to generate data in memory table, and then data inserted user-defined data table from memory table, thus in user-defined data table, generate large data fast.

2. a kind of method generating large data fast in user-defined data table according to claim 1, is characterized in that: described method comprises following step:

Step one, establishment user-defined data table userInfo;

Step 2, create the memory table userInfo_memory identical with user-defined data table;

Step 3, realize in memory table, generate large data function rand_struserid and storing process add_userInfo_memory, and require that userid is 18, be made up of at random letter and number;

Step 4, adjustment System internal memory, arranging memory parameters max_heap_table_size is 5000M;

Step 5, Calling Stored Procedure add_userInfo_memory, the large data required for raw in memory table;

Step 6, employing SQL statement are inserted into data in user-defined data table from memory table.