Upgrade PHP and MySQL in centos with yum
After umvps is used, many times you have to deal with the virtual host without doing anything on your own, such as upgrading PHP and MySQL. Because you don't need to do it yourself, you cannot do it.
During the design of MySQL database fields today, the prompt is always prompted during table creation.MySQL:Error 1071 (42000): specified key was too long; max key length is 767 bytes.At first, I didn't figure out why, because by default, MySQL
Reprinted: http://www.iteye.com/topic/910030
Erlang connects to the MySQL database
1. Driver download and Installation
1. Download Erlang-mysql-driver
As follows:
SVN checkout
Paip. navicat form MySQL 100% CPU usage when importing text files
Author attilax, email: 1466519819@qq.comSource: attilax ColumnAddress: http://blog.csdn.net/attilax
Navicat 10.1.7 imports a TXT file, which occupies 100% of the CPU. However, it is
1. In order to use SCP without entering a password, another SSH key pair is used for verification.
1. Use the ssh-keygen command to generate a key. In addition to the password, select the default value: Press enter. [Root @ xxx root] #
Trademanager is about to engage in operational activities in a short period of time. In the past two days, when designing the system, there is a need to update the data about 5 million times within half an hour. The data volume is small, up to 10
From: http://www.kitebird.com/mysql-cookbook/path.pdf
What to do if MySQL cannot be foundIf your shell or command interpreter can't find MySQL when you invoke it, you'll see some sort of error message.It may look like this under UNIX:% MySQLMySQL:
MySQL keyword usage:
Discard the input command: \ c
Exit the SQL program: \ q
View the MySQL server status: \ s
Domain Integrity: primary key; foreign key;
Create a database: Create Database database name;
Create Table and column name: Create Table
I found some information on the Internet and tried it again!
The general process is to read the image file with inputstream, convert it into a bytecode file, store the bytecode in the database, and store the image with the clob data type in the
For example, set the MySQL instance parameter wait_timeout to 10 seconds.
1) method 1 for setting global variables (not recommended): Modify the parameter file and restart mysqld.
# Vi/etc/My. CNF
[Mysqld]
Wait_timeout = 10
# Service mysqld
Mysql> select version (); view the mysql versionMysql> select current_date (); view the current MySQL dateMysql> select version (), current_date (); view the mysql version number and current dateMysql> show databases; displays the existing
Archive for future reference.
1. Download the MySQL free installation version zip package.
2. Decompress MySQL to the directory to be installed (you can decide where to put it ). After decompression, the default folder name is: mysql-6.0.9-alpha-win3
Recently, when learning Drupal, the environment required before installation is PHP + MySQL + Apache, but the corresponding installation of MySQL has encountered the apply security settings error during installation, after a long period of
Document directory
14.1.1. Create a stored procedure
14.1.2. Create a storage function
14.1.3. Use of Variables
14.1.4, defining conditions and handling procedures
14.1.5 use of the cursor
14.1.6. Use of Process Control
14.2.1 call a stored
MySQL query log
Unlike Oracle, MySQL does not add a large number of debugging entries to the source code. Recently, it suddenly needs to debug the SQL Execution Process of MySQL. So I checked it and found that there is only one mechanism called
(Assql is an open-source library used by Flex to connect to MySQL. It can be downloaded from http://code.google.com/p/assql/downloads/list .)
Problem:
When you use assql to query, update, and insert MySQL records, Chinese characters are garbled.
I haven't figured it out before:Since MySQL first performs data operations and then writes BINLOG, what should we do if it fails to write BINLOG and MySQL crash?
The answer is that data is determined by the storage engine.You can separate MySQL
Environment: RHEL 3, mysql-5.0.22 source code package (: http://download.mysql.cn/src/2006/0710/5544.html)
Use the root user to perform the following steps:
Groupadd MySQL
Useradd-G MySQL
CD/usr/local
Tar zxvf/root/mysql-5.0.22.tar.gz #
First, go to www.mysql.com download MYSQL5.0: mysql-standard-5.0.16-linux-i686.tar.gz version is more suitable for us these talented birds!Then, enter the following command in the terminal:[Code] shell> groupadd mysqlShell> useradd-g mysqlShell>
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