Blog column>Database column>MySQL management and development from the shallower to the deeper
  • MySQL management and development from the shallower to the deeper
  • I 2008 to enter the field of database, 2010 officially become MySQL DBA, and incident management Mongodb, engaged in telecommunications business community and Internet business and the gaming industry, has accumulated a lot of experience, data is very important, and technology is endless, welcome everybody exchanges together into step.
  • Subscribe

Updated articles

[database] [MySQL production environment data recovery fatal error: OR no'datadir']innobackupex: option in group'mysqld' in MySQL options expert

1 perform recovery command [xxx@xxx-c001db1 tmp]$time /usr/bin/innobackupex --rsync --user= "user" --password= "#xxx$" /mysqldata/shared/backup [--rsync] can record Master points for replication settings. Backup Utility v1.5.1-xtraba InnoDB...

[database] [MySQL] recorded an online fault treatment process of has more than'max_user_connections'active connections -- > expert

Nested exception is org.apache.ibatis.exceptions.PersistenceException: org.mybatis.spring.MyBatisSystemException: Error querying database. Cause: org.springframework.transaction.CannotCreateTran ###...

[database] Last_Errno: 1062, Error'Duplicate entry for '...' key'PRIMARY''on query. Last_Error: detailed analysis process expert

The online environment I have never encountered problems of 1062, test environment development environment constantly appear similar problems, previous to in a hurry is skip or directly to do, this will have time. Good to check the problem. 1 error information from the library: Show slave status\G mysql> *************************** 1 row ***************************...

[database] Root MySQL password reset error: connect to server at'localhost'failed mysqladmin: solution! expert

- ==================================================================== Mysqladmin: connect to server at -'localhost'failed solution! - =============================================================...

[database] ERROR 1227 (42000): denied you; need at (least one of the) PROCESS privilege for (s) this oper Access expert

In the past 1 MySQL landing landing mode [mysql@eanintmydbc002db1 mysqllog]$MySQL Enter password: Welcome to the MySQL monitor. Commands end with or \g.; MySQL connection ID is Your 3157186 Version: 5.5.25 Server...

[database] Introduction to basic knowledge and basic parameters of Cluster MySQL expert

PS: These data are previously sorted, and some are likely to be on the Internet copy others, but a long time, can not remember the source, sorry! In MySQL Cluster Environment Configuration config.ini file, each node has two (or more) of the corresponding configuration item, each node configuration items are mainly consists of two parts composition, the part is similar for all nodes in the same configuration item in the MGM [NDB_MGM DEFAULT], [NDBD DEFAULT] and [MySQLD DEFAUL...

[database] Cluster MySQL online management node configuration file - data node 96G memory expert

Online friends to provide, for reference only. DEFAULT] [NDBD NoOfReplicas: 2 # /data/mysql/log DataDir: /add/path/here #FileSystemPath: # Data Memory, Index Memory, and String Memory # 61440M DataMemory: IndexMemory...

[database] Cluster MySQL configuration file -SQL node 4G memory expert

Example MySQL config file for large # systems. # Is for a large # This system with memory where the system runs mainly = 512M # MySQL. # Programs look for option # MySQL files in a set of # loca...

[database] MemSQL study notes - similar to the MySQL database expert

Http://gigaom.com/cloud/ex-facebookers-launch-memsql-to-make-your-database-fly/ - Multi - Master - from Http://www.mysqlops.com/2012/02/14/diy_multi_master_replication.html Http://www.cnblogs.com/liuhao/archiv...

[database] Cluster MySQL management node configuration file - data node 4G memory expert

DEFAULT] [NDBD #TotalSendBufferMemory = 256M NoOfReplicas=2 DataMemory=2500M IndexMemory=256M DataDir=/var/lib/mysql-cluster #FileSystemPath=/data/dbdata Log #Redo FragmentLogFileSize=32M...

[database] MySQL latest version of the 5.6.13 source installation process expert

2 months before the company to the test server DBA was close to the back, has been to develop a set of DB, some need to test the function and need to continue to restart dB, in order not to affect the development of colleagues, own and apply the a virtual machine, ready to install the MySQL Community Edition of the new 5.6.13 version of the. 1 the tar.gz Download Http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.13.tar.gz/f wget...

[database] A process of online MySQL Chinese garbled problem expert

1 penguins on the friend asked me out of the MySQL query data is garbled in the tool inside out, as shown in figure: 2 let him go to check the character set of the MySQL server, you can see all the normal utf8, as shown in figure: 3 I guess the data entry must be the time of the problem, a friend said is recorded by source, and then I go to the Linux server to check the import data files: More /opt/soft/20130821ajtdrz_1.sql: is shown in figure...

[database] MySQL about 1042 t 'get hostname for your address Can analysis of the problem solving process expert

1] [Comment Before Penguin colleagues above said he installed MySQL 5.5, connections to the MySQL client, reported 1042-Can 't get hostname for your address error, but the permissions grant the and grant success. This error means "your address cannot obtain the host name, I think of skip-name-resolve parameters. Official documents: --skip-name-re...

[database] Analysis and discussion about the table -- > 700W data, 10W select data into a new table on the same day, the original table is locked expert

Sun shine 16:15:55 Handsome I have a cell phone table about 700 hundred data, about 50000 new every day, and also update about 10 million then I every night the day data select import a new table when the table is locked, have what good solution? Huang Shan (17:32:18) The way you import? Just busy What about the way you import it or how it might be? Sun shine 17:43:39...

[database] MySQL online 600W record of the MyISAM table, the storage engine to be changed to innoDB, a alter table on the issue of immediately locked expert

Industry inside a friend Penguin asked: Sun Shine: Line I have a database about 600 million data I want to change the storage engine to innoDB, is average per minute has 50 insertion, alter table immediately locked, and what better way?   Huang Shan 11:27:31 It's bound to be locked. You all day business low peak period is in which a short time ah? Alter table TBNAME engine=innodb; lock table is full   Shin Sun...

[database] MySQL partition table partition modify on-line field partition, further study partition (2) -- > sub partitions and the input null values processing. expert

- MySQL partition, sub partition and processing of input Null value. Read the official document notes. - Partitioning KEY By key Partitioning is similar to partitioning by hash except that where hash partitioning employs a user-defined expression the has...

[database] MySQL partition table partition online modification of the partition field, follow the further study of partition (1) expert

Company online in the use of partition, there is a table of the partition field is wrong, need to be rebuilt, the results found no way to modify the primary key field or modify the index field as a direct SQL to get. But need to build a temporary table, there are time down, so go carefully read the document, the details of the study under the partition. When their company to take the time, 1 am business low peak period, the implementation of: Create a temporary table TABLE tbname_TMP CREATE ( SHARD_ID INT NOT...

[database] MySQL implementation of a complex column with a digital auxiliary table expert

One day, QQ on a circle of friends sent a help message: PropID name Amount 3 gold 2 2 Le beans 3 Can use a SQL output, that is, to copy the corresponding Amount of the number of: Name PropID 3 ingot 3 ingot 2 Le Dou 2 Le Dou 2 Le Dou   Under the study, with the ordinary by group...

[database] SSD disk, CPU high, high concurrency in the case, is not the MySQL parser consumes high CPU resources? expert

You see I do the experiment, the user table is more than 300 W records. Ordinary disk, the most time consuming is copy to TMP table 0.81 seconds, of course, in the SSD, the can be reduced a lot, the second is sending data in 0.009 seconds, the third is part of optimizing the parser optimization, only 0.0003 seconds is less than 1 / 30 of the sending data. So I can understand from this MySQL parser does not consume too much CPU resources.   Personal point...

  • Columnist:Mchdba
  • Creation time: 2013-08-12
  • Article number: 33
  • Browse volume: 120929 times

Hot articles

Latest comments