MySQL initialization steps

The beginner in the MySQL initialization step must be familiar with the problem that PHP cannot connect to the database just now when using MySQL. Now, let's take a look at the work to be done, on the premise that you have added the mysql working

Mysql SQL statements to view table information

Mysql SQL statements, View table information, View table field information, Java code SELECT column_name AS 'column name', data_type AS 'data type', character_maximum_length AS 'character length ', numeric_precision AS 'numeric length',

Mysql Log command

The mysql log command has the following types of logs:-log-err query log:-log slow query log:-log-slow-queries Update log: -log-update BINARY log:-log-bin in the mysql installation directory, open my. ini, add the above parameters to the end, save

Data Recovery after Mysql becomes invalid

This article describes how to recover data after Mysql becomes invalid. In some special cases, the Mysql database becomes invalid and the data cannot be exported. 1. reinstall MySQL locally (Installation Directory D: \ Program Files \ MySQL Server 5.

Mysql event viewing and timer related operations

Mysql event viewing and timer related operations view event SHOW EVENTSselect * from mysql. event to check whether the show variables like 'event _ scheduler 'timer is enabled; enable the timer 0: off 1: onSET GLOBAL event_scheduler = 1 ;. delete

MySQL InnoDB manages and backs up binary logs

MySQL InnoDB manages and backs up binary logs (I) Importance of binary logs if there is data backup at a certain point in time and all binary logs since then can replay the binary logs since the last full backup and" roll back "all changes (ii)

Potential risks of modifying the default character set of a table in mysql

Potential risks arising from modifying the default character set of a mysql TABLE if you need to modify the default character set of the TABLE after creating the TABLE, you can use alter table to modify the default character set of the TABLE. alter

Mysqlslap stress testing tool

Mysqlslap stress testing tool mysqlslap is a mysql testing tool started with mysql 5.1.4. [Root @ aeolus1 ~] # Mysqlslap -- help mysqlslap Ver 1.0 Distrib 5.5.31, for Linux (x86_64) Copyright (c) 2005,201 3, Oracle and/or its affiliates. all rights

Mysql delete tens of millions of Data Operations

Mysql deletes tens of millions of data in mysql. When the delete operation drops tens of millions of data records, the table will be locked and even put a lot of pressure on the mysql server. This is an unavoidable problem in mysql. It can be said

Mysql supports transaction processing

Mysql supports transaction processing. In MYSQL, only INNODB and BDB data tables can support transaction processing. In general, the default engine of MYSQL database is MyISAM, which does not support transactions; if you want MYSQL to support

[MySQL] B + tree indexes

[MySQL] B + tree index B + tree is a classic data structure generated by the combination of the Balance Tree and the binary search tree, it is a balanced search tree designed for disks or other direct access devices. In the B + tree, all record

Mysql dual-host exceptions and Solutions

Mysql dual-host exception and solution today, Mysql dual-host encountered two problems. Sort out the solution from the Internet and record it: run the following command to view the exception information: SQL code mysql> show slave status \ G; for

MySQL obtains start_date/end_date of the current week, month, and quarter.

MySQL obtains start_date/end_date of the current week, month, and quarter on the first DAY: select date_sub (curdate (), interval weekday (curdate () + 1 DAY) the last DAY of the current week: select date_sub (curdate (), interval weekday (curdate ()

Enable mysql slow query logs and run the mysqldumpslow command to view the logs.

Enable mysql slow query log and run the mysqldumpslow command to check which SQL statement query is slow, that is, slow query slowlog. Now we will introduce how to enable this function. Add the following code under [mysqld]: long_query_time =

Mysql backup script

The mysql backup script writes a mysql backup file today, mainly using the mysqldump tool. The requirement is to back up some databases at three o'clock every day and keep the backups for two days. Simple requirement: The following script #!

Export records from mysql to hdfs

Export records from mysql to hdfs 01 ConnectURL = jdbc: mysql: // localhost: 3306/user_action0203UserName = root0405PassWord = 1234560607 OutputPath =/hdfs/recommend/user_action/login = watch_record1011Columns = id, uid, mid, handler = 'sqoop job

MySQL reserved keywords

MySQL reserved keywords today, when we use hibernate to associate ing to export tables, because a table named option is mapped to a MYSQL keyword, errors are always generated. At first, we thought it was a ing file and code problem, the reserved

MySQL authorization (allow slave server users to log on to the master server)

MySQL authorization (allowing slave server users to log on to the master server) 1. view the user authorization table select user,host,password from mysql.user;  2. Set a password for the user update mysql.user set password=PASSWORD('root') where

Clear and disable Binary logs of MySQL

The Binary logs of MySQL is cleared and disabled. Recently, MySQL has been flushed. Binary Log eats more than 800 MiB of hard disk space, which interferes with the normal operation of the system. There are many solutions, including directly deleting

Set up and use semi-synchronous mysql replication (semi_sync_replication)

Set up mysql semi-synchronous replication (semi_sync_replication) and use google to develop a patch for mysql based on semi-synchronous, application and mysql5.0. Mysql is installed with this patch and used in mysql 5.5. What is the concept of

Total Pages: 3233 1 .... 2834 2835 2836 2837 2838 .... 3233 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.