MySQL

From yesterday, I started monitoring MySQL and found that It is strange that in the MySQL configuration file, the configuration prohibits domain name resolution -- skip-name-resolve. For details, see how MySQL uses DNS, this is a MySQL bug, but

In the original company, most of the requirements and designs wereProgramI am a "Obedient" person in charge of online research. The leaders let us do what we do. Now the company is quite good and has a dedicated planning team, all requirements are

Let's startTmp_table_size: It specifies the maximum value of the temporary internal memory table, and each thread must be allocated. (The actual limitation is the minimum values of tmp_table_size and max_heap_table_size .) If the temporary memory

Query_cache_limitQuery_cache_limit specifies the buffer size that can be used by a single query. The default value is 1 MB. Query_cache_size Optimization MySQL provides a query buffer mechanism starting from 4.0.1. Using the Query Buffer, MySQL

This article focuses on the combination of two MySQL commands. It will create a new data table with the same structure and data based on the original data table.   This helps you quickly copy tables as test data during development without having to

If you do not want repeated records in the data table, you can add a unique index for the table. For example, the user table has two fields: user_id and user_name. If you do not want two identical user_id and user_name, you can add the Union unique

The methods for determining whether a field exists are summarized as follows: 1. Search for system tables Select table_schema, table_name, column_name from information_schema.columns where column_name = 'uu '; 2. Use describe Describe cdb_posts

MySQL has been optimized recently. Many of them have added thread_concurrency to the configuration file. Most people provide the following description: "SettingsThread_concurrencyThe correct value has a great impact on MySQL performance. When

Some applications need to store some temporary data. At this time, the temporary table seems to be a good choice, but the memory table is not so good in the master-slave database. The reason is simple. Both statement-based and row-based replication

Copy a MySQL file, that is, copy ***. FRM (table structure file ),***. MYD (data file ),***. myi (index file) (you can recreate an index file without copying it ). For example, I have a foo table in the test database. The data structure is as

Create a program based on the talent table: #!/usr/bin/python2.6# -*- coding: utf-8 -*- import datetime#import MySQLdb tbname="alter table tip"ddl="""add index idx_timestamp(timestamp,appid,appcallcount);"""

Some time ago, I got a special business. Its scenario is as follows:-About 0.3 billion of data is written into the database every day-write more and read less, write 10 million data every 5 minutes-by the talent table, data on the same day of

Some netizens asked questions about the combination of "flex-Tomcat-mysql". I have introduced some in my previous blog. See Http://www.cnblogs.com/dannyr/articles/19503.aspx Here, I will paste the previous figure: Flex only processes display

    Knot:    In order to use MySQL in the C ++ project created under codeblocks, I worked so hard for half an afternoon that I finally breathed a sigh of relief and completed the compilation. Many of them succeeded in repeated failures

Document directory Storage Engine MyISAM InnoDB Comparison Demo-matrix 2008.06.14   Most people who use MySQL know that MyISAM and InnoDB areThe two most-common database engines available with the popularOpen-source database provider. I

The front-end time is related to a DB project. alanc reports a query. Using indexes is much slower than not using indexes. So I followed up and used explain to look at two different query results. The results of queries without indexes are as

My. ini (My. CnF in Linux). When the MySQL server starts, it reads this file and sets relevant runtime environment parameters. My. INI is divided into client section and server section.The client section is used to configure MYSQL client

MySQL full-text retrieval notes 1. mySQL 4. full-text search is supported in Version X and later versions, but the storage engine type of the table must be MyISAM. The following table creation SQL statements are used. Note that the storage engine

Author: gnuhpcSource: http://www.cnblogs.com/gnuhpc/ Add the jar of MySQL-connector to build path. Package Org. BUPT. JDBC;/*** @ author gnuhpc * Email: warmbupt@gmail.com * blog: http://blog.csdn.net/gnuhpc * @ date 2010-1-6 */import Java. SQL.

Author: gnuhpcSource: http://www.cnblogs.com/gnuhpc/ The command line after I log on to MySQL looks like this: Warmbupt @ pchuang:/Windows/mycode/SS $ mysql-u root-ppassw0rdWelcome to the MySQL monitor. commands end with; or/g.Your MySQL connection