MySQL

I. Use of security issues in UDF For example, execute an SQL statement to view the contents of the/etc/passwd file: The main use of the Load_file () function, of course, is that the function can be disabled. The above can easily see the/

After MySQL forgets the root password, it can be modified using the following method.1. Log on to the server where MySQL is located, manually kill the MySQL processKill ' Cat $mysql _data_dir/hostname.pid '$mysql _data_dir /hostname.pid as the MySQL

Prepare the article:CentOS 6.6 System Installation Configuration Illustration tutorialHttp://www.osyunwei.com/archives/8398.html1, configure the firewall, open 80 ports, 3306 portsVi/etc/sysconfig/iptables-A input-m state--state new-m tcp-p

Prepare can solve the large-volume Web site to the database server load and cost, this article through an example to introduce the pre-query prepare and the performance of ordinary query comparison, the need for friends can refer to.The instance

A view is a table that is exported from one or more tables. is a virtual existence of a table. A view is like a window through which you can see the data that is specifically provided by the system. This allows the user to not see the data in the

Download the MySQL installation package, if it is the first installation, we recommend downloading the DMG installation package Open the DMG installation package and double-click the pkg file in the installation package Click "Continue", and

The first step, download the database version you need from the official website, here I use the latest version of the 5.7.15; Unzip the file you downloaded, I'll name it MySQL Server 5.7, I put it under D:\Program files\ You will find

Concurrent Replication ( Parallel Replication ) Series II: Enhanced multi-threaded slavesMa Pengfei Technology MySQL database engineerFirst, we comb the basic principle of traditional mysql/mariadb replication:Master-slave replication is done

problem 1 : as shown 650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/89/2C/wKiom1gJ0cmzs3t0AAA-lkYqVdQ504.png-wh_500x0-wm_3 -wmp_4-s_721336662.png "title=" 1.png "style=" Float:none; alt=

Today due to the replacement of the server, re-local backup of the database, trial run program error, as follows:MySQL Error: The user specified as a definer ([email protected]) does not existThis means that the definition of a database object (i.e.

I am using the mysql5.6 versionOneSET GLOBAL max_allowed_packet = 500*1024*1024; Maximum size of the buffer between client/server communication;Set global net_buffer_length=100000; TCP/IP and socket communication buffer size, creating a line of

concat function in MySQLHow to use:CONCAT (STR1,STR2,...)Returns the string that results from the connection parameter. If any one of the arguments is NULL, the return value is null.Attention:If all parameters are non-binary strings, the result is a

Today, database operations are increasingly becoming a performance bottleneck for the entire application, which is especially noticeable for web applications. It's not just about the performance of the database that DBAs need to worry about, it's

The People's Congress a sophomore has been using Windows system, was spoiled by the Microsoft Dad, a see cmd command line to scare urine. Now with Ubuntu, every operation is a statement, but also get exercise (a JB).Ubuntu installs MySQL and Python

In a variety of test mix scenarios, the combination of 10 (combination 10:SSD * 2, RAID 0, Xfs,wb,nobarrier,noop) has the highest overall performance, so it is the benchmark, and the comparison of other schemes, the following table is the comparison

TPCH is a toolkit provided by TPC (Transaction Processing Performance Council) organization. Used for OLAP testing to assess the performance of decision support systems (DSS) in Business Analytics. It includes a complete set of business-oriented

1. Crawl Page http://www.quanshu.net/book/9/9055/2, use the module urllib (Web download), re regular match get title and titleurl,urlparse (stitching full URL), mysqldb (import MySQL) database3. For loop traversal list Get tomb Grave Note chapter

Detailed Description: MySQL uses Event Scheduler to create a scheduled task, mysqlscheduler Preface The event scheduler is equivalent to scheduled tasks in the operating system (for example, scheduled tasks in cron and Window in Linux), but the

Rare BUG in MySQL database -- Can't get hostname for your address, mysqlhostname When connecting to mysql jdbc Com. mysql. jdbc. exceptions. jdbc4.MySQLNonTransientConnectionException: Communication link failure, message from server: "Can't get

How to Use pt-online-schema-change to change the primary key of a MySQL table, ptonlinechangeschema When the service runs for a period of time and finds that the original primary key settings are not reasonable, you want to change the primary key.