Because of a lapse in government funding, the information on this website may not be up to date, transactions submitted via the website may not be processed, and the agency may not be able to respond to inquiries until appropriations are enacted. The NIH Clinical Center (the research hospital of NIH) is open. For more details about its operating status, please visit cc.nih.gov. Updates regarding government operating status and resumption of normal operations can be found at OPM.gov.

Lexical Tools

MySql

Description

MySql is an excellent database by T.C.X. DataKonsultAB as free software. It is a true multi-user, multi-threaded SQL database server.

Capability

MySQL since 1996 in an environment with more than 40 databases containing 10,000 tables, of which more than 500 tables have more than 7 million rows. This is about 100 gigabytes of mission-critical data.

Limitations

  • It is not free for re-distribution.
  • It requires a person with system administration knowledge for one time installation.
  • It provides (requires) a person with DBA knowledge to setup accounts for users.
  • Based on above limitations, MySql is not suitable in shrink wrapped version of LVG.

References

Please refer to MySql Web site.

Notes

  • The default character set and collation for table need to be set as utf8 and utf8_bin when table is created to integrate with utf-8, respectively. 
    CREATE TABLE t ( ...) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;