Computer Science, asked by anuj, 1 year ago

What are the technical specification of MySQL?

Answers

Answered by raaj25
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
Similar questions