What types of applications deployed on MySQL and MySQL Customers

In the Application space, MySQL is very dominant with Web-based applications with them being the most popular.

 

 

 

 

MySQL’s customer base is centered in 5 key areas – Web, SaaS, Enterprise, Telecommunication, and  OEM.   There are more than 400 major customers, such as Google, Yahoo, YouTube, and Facebook. Utilitized in virtually every Web 2.0 companies such as Craiglist, Flickr, Wikipedia, and Zillow.  With strength in Teleco including customers such as Cisco, Comcast, Alcatel and China Mobile.  Strength in Enterprise customers including Associated Press, Shinsei Bank and Toys R’ Us.

 

Mysql存储引擎特性比较

下表列出了Mysql 主要数据引擎架构(如myisam、innodb Storage Engine )的特性比较:

 

Feature MyISAM NDB Archive InnoDB Memory
Storage Limits No Yes No 64TB Yes
Transactions No Yes No Yes No
Locking granularity Table Row Row Row Table
MVCC snapshot read No No No Yes No
Geospatial support Yes No Yes Yes No
Data caches No Yes No Yes NA
Index Caches Yes Yes No Yes NA
Compressed Data Yes No Yes No No
Storage cost (relative to other engines) Small Med Small Med NA
Memory cost (relative to other engines) Low High Low High High
Bulk insert speed High High Highest Med High
Replication Support Yes Yes Yes Yes Yes
Foreign Key support No No No Yes No
Built-in Cluster/High-availability support No Yes No No No

 

 

Dynamically add and remove storage engines.
Change the storage engine on a table with “ALTER TABLE …”

MySQL 如何获得当前会话的TRX_ID 事务ID

 

 

mysql>  show variables like '%commit%';
+--------------------------------+-------+
| Variable_name                  | Value |
+--------------------------------+-------+
| autocommit                     | OFF   |
| innodb_commit_concurrency      | 0     |
| innodb_flush_log_at_trx_commit | 1     |
+--------------------------------+-------+
3 rows in set (0.00 sec)

mysql> select version();
+-------------------------+
| version()               |
+-------------------------+
| 5.5.40-0ubuntu0.14.04.1 |
+-------------------------+
1 row in set (0.00 sec)


mysql>  insert into tv values(1);
Query OK, 1 row affected (0.00 sec)

mysql>  insert into tv values(1);
Query OK, 1 row affected (0.01 sec)

mysql> SELECT TRX_ID FROM INFORMATION_SCHEMA.INNODB_TRX  WHERE TRX_MYSQL_THREAD_ID = CONNECTION_ID();
+--------+
| TRX_ID |
+--------+
| 9648   |
+--------+
1 row in set (0.00 sec)

沪ICP备14014813号

沪公网安备 31010802001379号