Project Address Https://git.oschina.net/rushmore/zbusLast time we talked about the core API of Zbus network communication :Dispatcher -- responsible for -nio Network event Selector engine management, load Balancing for Selector engine Ioadaptor-
Today just in preparation for the company's interview, so the MySQL knowledge points to review, to find a good blog, but also to their own MySQL to do an accumulation.Please refer to the original text: http://www.cnblogs.com/zhangzhu/archive/2013/07/
about PHP read MySQL database when garbled method of resolutionWhen PHP reads MySQL, there are several places involved in character sets.1. Specify the character set of the database table when the database table is created. For example
In MySQL sometimes the Mysql.sock location error occurs, which causes the database to be disconnected.Mac by the time error:The first change of MY.CNFPosition/etc/my.cnf Next, if not, then. Change with/usr/locate/mysql/my.cnf and copy to/etc.Change
1. PrincipleMySQL replication technology has some of the following features:(1) Data distribution (distribution)(2) Load balancing (load Balancing)(3) Backup (Backups)(4) High-availability and fault-tolerant lines of availability and failoverAs a
Write in frontNot long ago, a friend to help him to get a unit of enterprise network management site, has been busy, recently pulled out a little time, also want to ponder Mvc,ef,mysql, this is a side pondering, side practice it.Series
Mysql Benchmark TestBenchmark testing is a stress test designed for the system.First, the main work of the benchmark test:1. Verify that some assumptions are based on the system and confirm that these assumptions are true (we do the main thing in
1. First PB needs UTF8 format, so it is converted from ANSI to UTF8 format to transfer2. On the receiving side, you need to convert UTF8 to ANSI to use3. You need to convert SQL from ANSI to UTF8 format before inserting a database4. The database
This example is the basic method for Java to operate MySQL.Before this example, install MySQL, configure the account password, create a logininfo database, and create a userinfo data table in the database. and add sample data to the table.First,
1. Start the MySQL serverIn fact, the previous article has talked about how to start MySQL. Two methods:One is to use Winmysqladmin, if the machine started automatically run, you can go directly to the next step.Second, running in DOS
/*The first step is to create the following two log tables*/ CREATE TABLE' slow_log ' (' start_time ' )timestamp not NULL DEFAULT Current_timestamp on UPDATE Current_timestamp, ' user_host ' Mediumtext not NULL, '
Simply say the benefits of using foreign keys1. Integrity constraintsLike what:User table with field user number (ID), name (username)Device table with field device number (ID), device name (devicename) device belongs to user number (USER_ID)
MyISAM storage engine in MySQL does not support transactions, InnoDB and BDB support transactionsA transaction is a contiguous set of database operations, which is indivisible, meaning that the set of operations is either fully successful or fails
EXPLAIN is the main way to see how the MySQL optimizer decides to execute a query, a feature that has limitations, that it will always tell the truth, but that it can get the best information. Learn to explain EXPLAIN, and you'll understand how the
MySQL adds fields to the method is not complicated, the following will give you a detailed description of the MySQL add fields and modify the fields and other operations to implement the method, I hope you learn to add fields in MySQL will be
Time function:Now: Current Time band formatMysql> Select Now (); +---------------------+| Now () |+---------------------+| 2015-09-06 10:47:33 |+---------------------+1 row in Set (0.00 sec)To_days: Given a date , returns a number of
1. View MySQL version information:1, Mount mysql>status;2, Mount Mysql>select version ();3, Mount mysql> select @ @version;4, not login [[email protected] ~]# mysql-v5, not login [[email protected] ~]# MySQL--help | grep distrib;2.MySQL Service
When insert fails, you may want to record its error information in the log file, such as the cause of the error, the time of the error, and so on. The following code creates a primary key table and a foreign key table. Then the value thrown into the
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