MySQL C API
There is nothing to do during the internship. I used Delphi for development. I really don't get used to Pascal. I'm bored with studying MySQL's C interface. Today I summarize it as a note, generally, I am used to making summary items
View the MySQL database size
1. Enter the specified schema database (storing information about other databases)
Use information_schema
2. query the size of all data
select Concat (round (sum (data_length/1024/1024 ), 2), 'mb '
1. Maintenance of the root user password:
After MySQL is installed, MySQL automatically provides a root user without a password. To ensure security, set the password for the root user:
# Mysqladmin-u Root Password 123(123 is the password, which
To use ASP. NET to connect to the MySQL database,
You must have a driver to access MySQL.ProgramOf course, you can use ODBC to access MySQL,
However, like accessing other databases, using ODBC will be less efficient to some extent,
Therefore,
Openfire is a very good IM server, and it is implemented in pure Java and has multiple platform versions. Its data storage can use a variety of databases, such as MySQL and Oracle.
In actual use, the most common problem encountered is the garbled
01. MySQL connection error: cannot get hostname for your address
Zheng Yi 2010 is affiliated with section 05. Data warehouse receiving
The database of a Web application is deployed on MySQL 5.5.5 instance (new machine) of 100. Zzz. yyy. xxx,
# Include # Include # Include # Include # Include # Include
# Define otl_odbc_mysql // compile OTL 4/myodbc// # Define otl_odbc_unix // uncomment this line if unixodbc is used# Define otl_stl // turn on STL features# Ifndef otl_ansi_cpp# Define
Tutorial
Http://zetcode.com/tutorials/mysqlcapitutorial/
Install mysql-connector-c-6.0.2.tar.gzThat is, the MySQL C ClientYum groupinstall "development tools"Cmake.MakeMake install
LDD is used to view dependencies.LD. So. conf is used to load
Kill syntax
Kill [Connection | Query]Thread_id
Each AndMysqldAre running in an independent thread. You can useShow processlistStatement to check which threads are running and useKillThread_idStatement to terminate a thread.
Explain syntax
ExplainSelect...... Variant:1. Explain extendedSelect...... Decompile the execution plan into a SELECT statement and run show warnings to obtain the query statement optimized by the MySQL optimizer.2. Explain partitionsSelect......
Installation steps:
1. MySQL
Download the MySQL for Linux RPM package on the following page
Http://www.mysql.com/downloads/down...3.52-1.i386.rpm;
Http://www.mysql.com/downloads/down...3.52-1.i386.rpm;
Save to the/home/tmp directory
MySQL is a real multi-user, multi-thread SQL database server. SQL (Structured Query Language) is the world's most popular and standardized database language. MySQL
Is implemented by a Client/Server structure, which is guarded by a server
Program
Http://www.javaeye.com/topic/251307 Author: touya
The project was released yesterday, and data migration was required. The functions to be implemented were abnormal and the time was very short. Basically, the work could be completed quickly and
Multiple times of MySQL Installation
Including binary, including automatic installation.
First, there is no password after installation, so you can refer to my other
Article
Question 1:
Error: 'Access denied for user' root' @ 'localhost' (using
Add new user account in MySQL
You can create one in two ways.MySQLAccount:
1. UseGrantStatement
2. Direct operationMySQLAuthorization Table
The best way is to useGrantStatement, because it is more accurate and has fewer errors.
Create a
In the past communication with many people, we found that when talking about the hardware-based database performance bottleneck analysis, it is often misunderstood that the use of more powerful hosts or storage to replace existing devices.
I
For any database
Management
System For example,
Memory Allocation is definitely one of its core, so many people who want to learn more about a database management system will want to have a look, and I am no exception.
Memory usage MySQL
1. Use the explain statement to view the analysis results, as shown in figure
Explain select * From test1 where id = 1;
:
Id selecttype table Type possible_keys key key_len ref rows extra columns
Where, type = const indicates that the index is
MySQL database performance optimization-Cache Parameter Optimization
Databases are IO-intensive applications. Their primary responsibilities are data management and storage. We know that the time for reading a database from the memory is
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