MySQL

PremiseReference:Http://www.cnblogs.com/xiaoxiaoguixia/p/4032355.htmlDesign diagram:Divided into three parts:Zabbix-server zabbix*.tar.gz Source Package supportZabbix-web Lamp Environment SupportMySQL Zabbix MySQL database stores Zabbix's various

By default, MySQL will keep the mysql-bin file, so that at some point, the disk may be full, whether it is possible to delete these files, whether it can be safely deleted, is a problem.First of all, these files are MySQL log files, if not the

/* Index *//* Index design principles 1. Try to choose a uniqueness index of 2. Order by,group by,distinct for frequent needs, The field of the Union is set at index 3. Sets the index for a field that is commonly used as a query condition 4. Limit

MyISAM and InnoDB explain:InnoDB and MyISAM are the two most common table types used by many people when using MySQL, both of which have pros and cons, depending on the application. The basic difference is that the MyISAM type does not support

=========================1. Creating databases and Tables=========================A total of 6 tables, Student information table, class information table, Teacher information table, curriculum, selection of curriculum, teachers schedule#班级信息表class,

How to compare the parameters of two MySQL instances, the production often have such a requirement, recently wrote a Python script, can basically achieve this requirement.Script#!/usr/bin/pythonImportMysqldb,sysdefFetch_variables

The steps are as follows:1, the master-slave server for the following actions :1.1. Consistent version1.2. Initialize the table and start MySQL in the background1.3, change the root password2. Modify Master server Master:#vim/etc/my.cnf [mysqld]

Change the sales status of April 20 to the current time period to unsold (1), the sales time to null (0) UPDATE hy_car_detail hcd SET hcd.sales_date = ", Hcd.sales_status = ' 1 ' where HCD . car_id in (Select hc.car_id from Hy_car HC WHERE

MySQL sub-table method:Method One, do the database cluster! Master-Slave database bidirectional hot backup (or one-to-many database real-time backup strategy), which can allocate database queries to several servers (can be combined with server load

One: OverviewCompared with other databases, MySQL's locking mechanism is relatively simple, and its most notable feature is that different storage engines support different locking mechanisms. For example, the MyISAM and memory storage engines use

problem: Installing the MySQL server on Linux, using the Client connection times error message is: Error 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using password: YES)    Workaround 1:        1. Login mysql: mysql -uroot -proot 

Workaround: View/usr/lib/php/modules/(64-bit look at/usr/lib64/php/modules/) there is no mysql.so.Installation:php-mysql-5.1.6-20.el5.i386.rpmphp-pdo-5.1.6-20.el5.i386.rpmTo view the corresponding path: found the corresponding so fileAdd to

1. View Kernel limits# ulimit-n655352. Modify the MY.CNF limit# Vi/etc/my.cnf[mysqld]open_files_limit = 655353. Restart Mysqld#/etc/init.d/mysql Restart4. View ResultsMysql>show Global variables like '%open% ';| Open_files_limit | 65535

First, the basic conceptThe mysql5.1 version begins with the introduction of the event concept. Event is not only a "time trigger", unlike the events triggered by the triggers, the event is similar to a Linux crontab scheduled task for time

1. The transaction has acid four characteristics.1. atomicity (automicity): All statements in a transaction should be done: either wholly or not;2. Consistency (consisitency): Let the data remain logically "reasonable", such as: When a commodity out

Apache InstallationFirst step: Install GCC and gcc-c++ because it will be used when compiling.# yum Install Gcc-y# yum Install gcc-c++-yStep two: Upload and unzip# Tar XF httpd-2.2.19.tar.bz2Step three: Check the configuration./configure

First, the database installation (installed in the/usr/local directory)1. Compress package Copy to/users/lengyufang/tools2. Groupadd MySQL3. Useradd-r-G mysql-s/bin/false MySQL4. cd/usr/local5. Tar zxvf/users/lengyufang/tools/mysql-5.5.48-linux2.6-x8

用java开发总是会遇到这样或者那样的问题，不过出乎我意料的是第一个大问题来的这么快。从昨天下午1点到晚上9.30一直在测试，查资料结果还是不行！今天下午试了一下可以了？！！如释重负。java开发，一直在路上，，，， 用myclipse开发java，由于要用到数据库，于是添加jdbc，由于我也是刚从c/c++转到java开发，不是很熟悉。所以我只说一下我遇到的问题和我怎么解决的！ 一，环境 1，编程语言：java（jre1.6） 2，开发环境：myclispe（10.0）

To establish a JDBC Link: Create a jdbc Connection Configuration. Add--Configure components--JDBC Connection configuration: Configure the JDBC Connection configuration: Description1) Variable Name: The name of the database

First, about MySQLMySQL is the most popular open source SQL database management system, developed, distributed, and supported by MySQL AB. MySQL AB is a commercial company created by MySQL developers, a second-generation open source company that