show variables

Author: skateTime: 2012/12/4   Error: Unable to connect to foreign Data source: can't create TCP/IP socket (24)   Environment Description:192.168.213.133:192.168.213.120: B   On BMysql> show Create Table B \ G;* *************************** 1. row ***

1. Prepared hostNode1: 172.16.133.11Node2: 172.16.133.12MySQL has been installed.MySQL installation see: http://5142926.blog.51cto.com/5132926/9356522. mysql master-slave ReplicationNode1: master serverNode2: slave server(1) node1:Enable binary log (

I. mysql Encoding Mysql> show variables like 'collation _ % ';+ ---------------------- + ------------------- +| Variable_name | Value |+ ---------------------- + ------------------- +| Collation_connection | latin1_swedish_ci || Collation_database |

MySQL 5.5 upgrades the character set from utf8 to utf8mb4Reason for upgrade MySQL supports only three-byte UTF-8 characters by default, and does not support Emoji emoticons (four bytes). If there are four-byte characters, an error is returned. MySQL

DigitalOcean-CentOS7-enable MariaDB service, centos7mariadbGossip: My job has not been smooth recently. I have been in the ACM Team (back in seconds), engaged in php development, O & M, and scientific research (visualization). Now I am mainly

MySQL functions cannot be created. MySQL functions cannot be created, which is a very troublesome problem. The following provides you with a solution to this problem. If you have encountered similar problems, take a

Mysql learning notes Data Engine and mysql learning notes Engine View the engines supported by the current database show engines+--------------------+---------+----------------------------------------------------------------+--------------+------+---

MySQL slow query: enabling slow query and mysql Query 1. What is the use of slow queries? It records all SQL statements that have been executed longer than long_query_time, and helps you find slow SQL statements to optimize these SQL statements. Ii.

Atlas of mysql proxy Atlas is a MySQL-based data intermediate layer project developed and maintained by Qihoo 360 and the Infrastructure Team of the Web Platform department. On the basis of the official MySQL-Proxy0.8.2 version of MySQL, it modified

MySQL slow Query Slow query (slow log)It can help us locate specific SQL statements for SQL statement optimization. For example, slow query logs record the SQL statements whose execution time exceeds the given value, so as to locate the

Actually: First, use Windows as the environment: Logs in Windows Overview of log file types:1.The error log records the problems that occur when you start, run, or stop mysqld.My. ini configuration information:# Enter a name for the error log file.

1. MySQL is a single-process multi-thread Architecture 2. view the engines supported by the current database Show engines \ G; 3 InnoDB has 7 Background threads, 4 Io threads, 1 master thread, 1 lock, and 1 error monitoring thread.Show engine

The image function of csdn is too painful. You need to manually upload images. When Can Windows Live writer be opened? You are welcome to visit my personal website: www.deanlinux.com to write only some technical articles. MySQL Master/Slave

Document directory List the solutions that can be found again: 1. When connecting to the database 2. Set the MySQL Character Set Show variables like 'character _ SET _ % '; Set all the displayed character_set _ ** to utf8, that is, set

Gossip:Recent job search has been not smooth, the university into the ACM team (seconds back), has done PHP development, operations, Research (visual direction), now mainly write Java, learn most of the things and the web.Looking for a job, the

In the process of writing shell scripts, we often customize some functions and execute the corresponding process according to the function's return value, so how do we get the return value of the function?There are two ways to call a function in the

See if SSL is supported First, execute the following command on MySQL to query whether MySQL supports SSL: Mysql> show VARIABLES like ' Have_ssl '; +---------------+-------+ | variable_name | Value | +---------------+-------+ | Have_ssl |

Recently, the project team used in the MySQL database, the insertion of data appears garbled, on this issue to do a summary, we start from the most basic place, to the root causes of errors and solutions. Basic concepts:• character (Character)

Windows1, MySQL is some environment variables can be set, Can enter: show variables; you can view the current environment variable settings; 2, some of these variables are related to the setting of the character, Can enter: Show variables

Objective MySQL is a commonly used open source database products, is usually the first choice for a free database. Checked the NPM list and found that Nodejs has 13 libraries to visit Mysql,felixge/node-mysql seems to be the most watched item, I