When working previously because the Oracle8i database often appears the user too many errors, due to the large amount of data, often appear ora:12500 error, but the main reason is too much access caused, Later, Java wrote a simple JDBC connection to
1. Find out if you should use MySQL cluster first.
Reduce data Center node pressure and large amount of data processing, using the MySQL distribution, one or more application corresponding to a MySQL database. A few MySQL database common data to
The third milestone edition of MySQL 5.5 was released, and one of the biggest changes in this version was the addition of a metadata repository for performance, the database named Performance_schema, and the storage engine used was
Introduction Introduction
The MySQL 5.0 new features tutorial is written for old MySQL users who need to understand the new features of version 5.0. The simple introduction of "stored procedures, triggers, views, information architecture view,"
Finally let the server back up the MySQL database every morning and automatically pack, and delete 5 days ago backup files. Share as follows.
1. Environment: Windows Server 2003 + Apache 2.0 + PHP5 + MySQL 4.0.26.
2. Suppose the PHP installation
When interviewing MySQL DBA or those planning to do MySQL performance optimization, my favorite question is: MySQL server in accordance with the default settings after installation, what should be done to adjust it?
To my surprise, how many people
MySQL today to the new colleagues to do MySQL training, the use of an example:
Connect database test username root password ABC
In the inside there is a username table, describe username results are as follows
Mysql> describe username;
+----------+--
mysql| Pagination | Optimization Author: steeven
It seems that few people are talking about paging, are we all addicted to limit m,n?
In the case of indexing, limit m,n speed is sufficient, but when searching for complex conditions,
where somthing
Environment: MySQL Sever 5.1 + MySQL command line tool
Problem: Creating an Index
CREATE INDEX Syntax:
CREATE [unique| Fulltext| SPATIAL] INDEX index_name
[Index_type]
On Tbl_name (Index_col_name,...)
[Index_type]
Index_col_name:
col_name
MySQL supports command line import Export data file, format is *.sql
1) Import:
Mysql-u User name-p password database name
2) Export:
Mysqldump-u User name-p password Database name > file path \ filename
3) Real case
I am on the Windows 2003
Configure mysql+lvs+keeplived to achieve load balancing for MySQL read operations
Environment:
Test1192.168.46.131master
Test2192.168.46.130slave Backup Test Library
TEST3 Scheduler
1, installation and configuration keepalived
First installs
Perform master-slave configuration online
Steps
1. Lock table
FLUSH TABLES with READ LOCK;
2. Copy data file, or export
3. Record the log location of master
Master_log_file
Master_log_pos
4. Unlock the main library
UNLOCK TABLES;
5. Start
Four, the first script
If I tell you that the really sad one has passed, you will be very happy. The software installation process is always unpredictable, because the system can be said to be different from the system. But you're lucky, the
If you forget your MySQL root password, you can recover it through the following procedure.
1. Send Kill command to MYSQLD server to turn off MYSQLD server (not kill-9), and the file that holds the process ID is usually in the directory where the
MySQL servers (3.23 to the highest version of the series, all 4.0 versions, and later) support transactions using the InnoDB and BDB transaction storage engines. InnoDB provides comprehensive acid compatibility.
Other non-transactional storage
Steps to upgrade MySQL in Windows:
1. You should back up the current MySQL installation before you upgrade.
2. Download the latest Windows version of MySQL.
3. You must stop the server before you upgrade MySQL.
If the server is installed as a
For beginners of SQL, the concept of null values often creates confusion, and they often assume that null is the same thing as an empty string. This is not the case. For example, the following statements are completely different:
Mysql> INSERT into
The first thing to declare is that in most cases, MySQL needs to have root privileges in MySQL, so the general user cannot change the password unless the administrator is requested.
method to use phpMyAdmin, this is the simplest, modify the MySQL
Is the database will inevitably error, out of the wrong will certainly need to repair.
phpMyAdmin is a good MySQL management tool that has a repair function for a table in a database. But when this table is no longer able to open it does not see
A few days ago because of the MySQL database part of the data corruption reasons, I tried to recover the data, after the collation of the following documents for your reference, in case you colleagues have similar problems in the future, you can
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