# Cd/home/tmp (enter the directory of the compressed package)# Groupadd MySQL (create a MySQL Group)# Useradd-G MySQL (create a MySQL user in the MySQL Group)# Tar-zxvf mysql-5.0.37.tar.gz (extract MySQL source code, bz2 compressed package, please
As the name suggests, slow query logs record queries with a long execution time.
You can set a threshold to record all SQL statements whose running time exceeds this threshold to the slow query log file.
The threshold value can be set using the long_
(1) udev Basics
Udev can manage files stored in the/dev directory. Files are generated only after the device is connected, and are automatically deleted after the device is pulled out.
It also allows you to add rules to modify the default name and
Documentation for mysqldump: http://dev.mysql.com/doc/refman/5.1/zh/client-side-scripts.html#mysqldump
MysqldumpIt is most commonly used to back up an entire database:
shell> mysqldump db_name >backup-file.sql
You can read the dump file back to the
Today, another Mysql Data Query problem occurs in the project. Simply put, when you want to process a query (multiple records may be returned), you can use
Limit to solve some problems.
Eg:
Select a. *, (select B. ID from table_ B B where...) as T1
Java database connection process:
Step 1: Install the driver and set the path
Step 1: To mysqlofficial website download mysql-connector-java-5.0.8.zip driver, decompress the copy inside the mysql-connector-java-5.0.8.jar to JDK installation
Three connection features
Left join)
The on Clause connection condition is used to connect equivalent records in two tables, but does not affect the number of record sets. If a record in the left_table table cannot be found in the right_table table,
MySQL replication (Basic Principles of master and slave)
1. Replication ProcessMySQL replication is an asynchronous replication, from one MySQL instace (called Master) to another MySQL instance (called slave ). The entire replication operation is
1. commands for starting MySql in Linux:Mysqladmin start/ECT/init. d/MySQL start (the installation path of MySQL is earlier)
2. Command for restarting MySql in Linux:Mysqladmin restart/ECT/init. d/MySQL restart (the installation path of MySQL is
FirstI would like to express my gratitude to the original author for the fact that most of my experiences come from here..
Http://blog.csdn.net/xiaoxiao54562/article/details/8285659
In addition, the things after this are all things that I think
OS environment-fedora12
Configuration File Location-/etc/My. CNF
Stop MySQL Service
# Service mysqld stop
Modify content
Add in the [client] configuration section: (if this configuration section is not available by default, add one)
The network chat room set up a few days ago uses the Apache + MySQL + PhP environment to record the building process.
1. Download SoftwareApacheHttpd-2.2.22-win32-x86-no_ssl.msi http://httpd.apache.org/download.cgiIn Windows, there are two binary
1. Use SSL Secure Connection
To use SSL connections between the MySQL server and client programs, your system must support either OpenSSL or yaSSL and your version of MySQL must be built with SSL support.
To make it easier to use secure connections,
MySQL database optimization allows for fast paging Analysis of tens of millions of data records.
The data table collect (ID, title, info, vtype) has these four fields. The title uses a fixed length, and the info uses text and ID.Gradually, vtype is
How does MySQL merge a single field of multiple records to one record? I found it online today using the following method:
Test Table Structure:
----------------------------------------------------------
---- Table structure 'tet'--
Create Table
Create a database on the mysql client:
Create Database bbs2007;Use bbs2007;
Create a new table:Create Table article(Id int primary key auto_increment,PID int,Rootid int,Title varchar (255 ),Cont text,Pdate datetime,Isleaf int #1-not leaf
Some time ago, I used MySQL 5.0 to develop things, used InnoDB as the storage engine, and used MySQL configured by DBA to adjust the memory parameters.
As MySQL 5.0 uses InnoDB to support transactions, transactions are used in the program, instead
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