What are the technical specification of MySQL?
Answers
Answered by
0
Oracle MySQL Cloud Service
MySQL Database as a Service
Flexible Architecture
Open Source
Multi-threaded
Pluggable Storage-Engine Architecture
InnoDB, NDB Cluster
MyISAM, Merge, Memory, Archive
ANSI SQL Standards
ANSI SQL
SubQueries, Joins, Cursors
Prepared Statements
Views
Triggers
Stored Procedures
User-Defined Functions
Information Schema
Unicode
Referential Integrity
Server-enforced Data Integrity
Replication & High-Availability
InnoDB Cluster
Group Replication
Router
Built-in Replication Engine
Master/Slave, Ring, Tree
Row-based Replication
Semi-synchronous Replication
Multi-source Replication
Time-delayed Replication
MySQL Cluster HA
Global Transaction IDs
Slave Failover, Recovery
Multi-threaded slaves
Sharding
MySQL Cluster
99.999% Availability
Distributed architecture
Synchronous replication
Real-time transactional performance
Foreign Keys
SQL & Non-SQL data access
Auto sharding of data
Java, C++, memcached, HTTP
Storage Management
Storage Administration
Automatic Space Expansion
Built-in Space Reclamation
Auto Undo/Rollback Management
Customizable Storage Assignments
Compressed and Archive Tables
Packed Index Storage
Works with NAS or SAN storage
Security
SSL Support
Built-in Data Encryption/Decryption
SSL Key Generation
Password management
Fine Grained Object Privileges
View Support
Triggers for auditing
Query Logs for auditing
High-Performance
Performance Schema
SYS Schema
Optimized for high concurrency
Optimized for Read Only
Optimized for use with SSD
Multiple Index Type (B-tree, R-tree, Hash, Full Text, etc.)
Cost-based Optimizer
Diagnostics, and SQL Tracing
Optimizer Tracing
JSON EXPLAIN
OLTP and Transactions
ACID Transactions
Commit, Rollback
Foreign Keys
Referential Integrity
Row-level Locking
Customizable Lock Isolation Levels
Distributed Transactions (XA)
Snapshot Isolation
Repeatable Reads (readers don't block writers and vice-versa)
Automatic Deadlock Detection
Web Application Optimized features
Server-side Thread Pool
Connection Thread Caching
Query Results Caching
Load Balancing
Prepared Statements
Full Text Search
Multiple Character Sets
Multi-Terabyte Scalability
JSON Support
Native JSON Datatype
JSON Functions
Data Warehouse Optimized features
Fast Data Load Utility
High-Speed Multi-Insert Function
GROUP BY WITH ROLLUP
Aggregate UDF
Analytic SQL Functions
Multi-Terabyte Scalability
I hope it help you..
Please mark me brainlist
MySQL Database as a Service
Flexible Architecture
Open Source
Multi-threaded
Pluggable Storage-Engine Architecture
InnoDB, NDB Cluster
MyISAM, Merge, Memory, Archive
ANSI SQL Standards
ANSI SQL
SubQueries, Joins, Cursors
Prepared Statements
Views
Triggers
Stored Procedures
User-Defined Functions
Information Schema
Unicode
Referential Integrity
Server-enforced Data Integrity
Replication & High-Availability
InnoDB Cluster
Group Replication
Router
Built-in Replication Engine
Master/Slave, Ring, Tree
Row-based Replication
Semi-synchronous Replication
Multi-source Replication
Time-delayed Replication
MySQL Cluster HA
Global Transaction IDs
Slave Failover, Recovery
Multi-threaded slaves
Sharding
MySQL Cluster
99.999% Availability
Distributed architecture
Synchronous replication
Real-time transactional performance
Foreign Keys
SQL & Non-SQL data access
Auto sharding of data
Java, C++, memcached, HTTP
Storage Management
Storage Administration
Automatic Space Expansion
Built-in Space Reclamation
Auto Undo/Rollback Management
Customizable Storage Assignments
Compressed and Archive Tables
Packed Index Storage
Works with NAS or SAN storage
Security
SSL Support
Built-in Data Encryption/Decryption
SSL Key Generation
Password management
Fine Grained Object Privileges
View Support
Triggers for auditing
Query Logs for auditing
High-Performance
Performance Schema
SYS Schema
Optimized for high concurrency
Optimized for Read Only
Optimized for use with SSD
Multiple Index Type (B-tree, R-tree, Hash, Full Text, etc.)
Cost-based Optimizer
Diagnostics, and SQL Tracing
Optimizer Tracing
JSON EXPLAIN
OLTP and Transactions
ACID Transactions
Commit, Rollback
Foreign Keys
Referential Integrity
Row-level Locking
Customizable Lock Isolation Levels
Distributed Transactions (XA)
Snapshot Isolation
Repeatable Reads (readers don't block writers and vice-versa)
Automatic Deadlock Detection
Web Application Optimized features
Server-side Thread Pool
Connection Thread Caching
Query Results Caching
Load Balancing
Prepared Statements
Full Text Search
Multiple Character Sets
Multi-Terabyte Scalability
JSON Support
Native JSON Datatype
JSON Functions
Data Warehouse Optimized features
Fast Data Load Utility
High-Speed Multi-Insert Function
GROUP BY WITH ROLLUP
Aggregate UDF
Analytic SQL Functions
Multi-Terabyte Scalability
I hope it help you..
Please mark me brainlist
Similar questions
Science,
8 months ago
Math,
8 months ago
Math,
8 months ago
Social Sciences,
1 year ago
English,
1 year ago
Math,
1 year ago
Social Sciences,
1 year ago