Recently AWS released their version of MySQL called Aurora, they claim it delivers up to five times the throughput of standard MySQL. This article explores some of the depths of this database technology, especially coming from an Oracle Database background.<\/p>\n
Character Sets<\/strong> MySQL contains character set support that enables data to be stored using an assortment of character sets and perform comparisons according to a variety of collations. Character sets can be set at the server level, database and table left and at the column level. MySQL also supports the use of character sets for the MyISAM, MEMORY, and InnoDB storage engines.<\/p>\n You can see the supported character sets from the following statement<\/p>\n Note: The default character set is single byte, this can cause issues especially if you are using different languages and extended characters.<\/p>\n Character set problems affect not only data storage, but also communication between client programs and the MySQL server. If there is a requirement to communicate with the database server using a different character set from the default, the following example can be used after connecting to the server:<\/p>\n Applications that store data using the default character set and collation (single byte – latin, latin1_swedish_ci), no special configuration should be needed. If an application requires data storage using a different character set or collation (multi byte), different character sets can be set several ways.<\/p>\n Performance and Locking<\/p>\n Recently AWS released their version of MySQL called Aurora, they claim it delivers up to five times the throughput of standard MySQL. This article explores some of the depths of this database technology, especially coming from an Oracle Database background. Character Sets In an Oracle system, you can define 2 character sets, one is used … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39],"tags":[59],"class_list":["post-254","post","type-post","status-publish","format-standard","hentry","category-aws","tag-aurora"],"_links":{"self":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/254","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/comments?post=254"}],"version-history":[{"count":5,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/254\/revisions"}],"predecessor-version":[{"id":298,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/254\/revisions\/298"}],"wp:attachment":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/media?parent=254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/categories?post=254"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/tags?post=254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nIn an Oracle system, you can define 2 character sets, one is used for char, varchar2, clob etc but national Character set is used for nchar, nvarchar2,nclob.To find values you can issue the following statement:<\/p>\nselect * from nls_database_parameters where parameter like '%SET%';\r\n<\/pre>\n
Select * from information_schema.character_sets;<\/pre>\n
SET NAMES 'utf8';<\/pre>\n
show open tables where in_use=1;\r\nshow full processlist;\r\nshow engine innodb status;\r\nselect * from information_schema.events;\r\nselect * from information_schema.character_sets;\r\nshow character set;\r\nshow status 'max_used_connections';\r\nselect * from information_schema.PARAMETERS;\r\nselect * from information_schema.GLOBAL_VARIABLES;\r\n\r\nSET FOREIGN_KEY_CHECKS=1;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"