Each MySQL client can connect through TCP / IP sockets using any of the supported platforms.It offers support for up to 64 indexes per table.Password security is done through the encryption of all password traffic when establishing a connection with a server.At the security level MySQL offers a secure privilege and password system which allows host-based verification. #Install ssl mysql on mac updateSupports DELETE, INSERT, REPLACE and UPDATE functions.MySQL is able to refer to tables available in different databases using the same statement.Execute the EXPLAIN instruction to explain how the optimizer solves a query.It has support for LEFT OUTER JOIN and RIGHT OUTER JOIN with standard SQL and ODBC syntax.Supports chain types of fixed length and variable length.Compatible with various types of data both 1, 2, 3, 4 and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM and OpenGIS.Execute multithreaded tasks using kernel threads. ![]() It implements hash tables in memory which act as temporary tables.It executes a memory allocation system which is based on threads to optimize the actions.Implements SQL functions using an optimized class library focused on improving database performance.Integrates transactional and non-transactional storage engines. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |