MySQL

1, sub-database sub-tableObviously, a main table (that is, very important tables, such as user tables) unlimited growth is bound to seriously affect performance, sub-library and sub-table is a very good solution, that is, the performance

Linux Environment modification catalina.shAdd the following line to the "echo" Using catalina_base: $CATALINA _base "":java_opts= "$JAVA _opts-server-xms800m-xmx800m-xx:maxnewsize=256m"Set Server.xmlmaxthreads= "minsparethreads=" "maxsparethreads="

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to

1. Download the MySQL decompression version to the official website, then unzip the MySQL to any path, this example is put in: D:\Program files\mysql-advanced-5.6.14-win322. Set the environment variable to add in the system variable path:;D:

To hack the local MySQL database password:1. Log into the system with the system administrator.2. Stop the MySQL service.Windows: Run net stop MySQL shut down database3. Go to the Command window and enter the MySQL installation directory, for

Install Python1. Download the latest version of Python from http://www.python.org/download/(I'm using python2.72, the most stable at the time)2. Next, install to the directory you want3. Then change path, click Advanced environment variable, Control

For some systems with large data volume, the problem of database is not only inefficient, but also the data storage time is long. Especially like a reporting system, it can take up to several hours to spend on data import every day. Therefore, it

PrefaceWork to do it, its prerequisite. PHP integration Environment is also very many, such as AppServer, XAMPP, WAMP ... As long as a key installation of the PHP environment to set up, this way is not my favorite fool style, later want to learn PHP,

View case SensitivityMysql> Show variables like "%case%";+------------------------+-------+| variable_name | Value |+------------------------+-------+| Lower_case_file_system | OFF || Lower_case_table_names | 0 |+------------------------+-------+2

The principle of MySQL master-slave replication:The binary log file of the main library is read from the library at a certain frequency, and the same operation is performed from the library according to the binary records of the main library, in

The hand is cheap, upgrade Max OS X to Yosemite, the system is installed by default nginx,php, boot will start automatically!The boot script defaults to the following location:/library/launchdaemons/ com.root.nginx-start.plistHas the following line:/

MySQL data typeFirst, numeric typeMySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available for each of these categories, and each

Install MySQL in Linux and configure it in a simple configuration. Start the MySQL serviceService mysqld Start　　 　　 Log in with an administrator user, usually by default without entering a password Gain access to a specific user, where root

In MySQL, we often use variable-length text data types such as varchar, text, and blobs. However, when we use these data types, we have to do some extra work--mysql data table defragmentation.So why do we need to defragment MySQL regularly after

Last night, referring to another article in the blog Park, I built a apache+php+mysql server on my Ubuntu, which I would like to keep in mind for a rainy day.First, install Apache sudo apt-get install apache2After installation, restart the Apache

In this there is not much to say entityframework compared to the various advantages and disadvantages of ADO. Please forgive me for not writing well.Recently used entityframework6.0 connection MySQL, encountered a variety of problems, Baidu Google

After installing MySQL with ports, after a period of time found that the/var space is insufficient, check, you will find that mysql-bin.000001, mysql-bin.000002 and other documents occupy space, then what are these files? This is the operation log

View DatabaseIt is often useful to get a list of databases on a server. Execute show databases; the command will be done. mysql> show databases; Create a database mysql> CREATE DATABASE Db_test; Query OK, 1 row Affected (0.00 sec)

"Unable to locate the update row" is reported when MYSQL is updated using ADO. Some values may have been changed after the last read ." This strange error occurred when I used ADO to connect MYSQL to update data through ODBC in DELPHI today: the row

MySql processes databases and tables View Database It is usually useful to obtain the Database List on the server. Run the show databases command. Mysql> show databases; Create a database Mysql> create database db_test;Query OK, 1 row affected (