June 19, 2013

Post: How to recover table structure from InnoDB dictionary

April 22, 2013 By 4 Comments

… 4. Load dumps of the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD …NULL, `first_name` VARCHAR(45) CHARACTER SET ‘utf8‘ COLLATE ‘utf8_general_ci’ NOT NULL, `last_name` VARCHAR(45) CHARACTER SET ‘utf8‘ COLLATE ‘utf8_general_ci’ NOT NULL, `last…

Filed Under: Insight for DBAs, MySQL Tagged With: , , , , , ,

Post: Converting Character Sets

March 17, 2009 By 22 Comments

… database (or set of tables) to a target character set and collation. Approach #1: ALTER TABLE `t1` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; Take… the entire database and re-importing it with the appropriate server & client character sets. This is a three-step process, where one must…

Filed Under: Insight for Developers Tagged With: , ,

Comment: Why MySQL could be slow with large tables ?

March 12, 2007 By 141 Comments

…query took longer the more rows were retrieved. Probably, the server is reaching I/O limits… I played with some buffer…auto_increment, `STRING` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL default ”, `URL` varchar(230) character set utf8 collate utf8_unicode_ci NOT NULL default…

Filed Under: Insight for DBAs Tagged With: ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… DEFAULT CHARSET=utf8 But, when we try to use this table, here’s what comes back: mysql: SET GLOBAL innodb_ft_server_stopword… with a setting of 1 versus a setting of 4. This may or may not be the case with multi-byte character sets or… of InnoDB FTS configuration which are both letter-case and character-set sensitive. Watch out! When you add your first FULLTEXT KEY…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Comment: When is it a time to upgrade memory ?

December 9, 2009 By 11 Comments

… wait_timeout=15 max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set=utf8 default-storage-engine=InnoDB bulk_insert_buffer_size…/mysqld.log pid-file=/var/run/mysqld/mysqld.pid The server (on amazon) has 7Go memory: [root@dom*************** log]# free -m…

Filed Under: Insight for DBAs Tagged With:

Comment: What to tune in MySQL Server after installation

October 8, 2012 By 118 Comments

… and the sorftware has the following settings: [mysqld] log-error=/var/log/mysqld.log init_connect=SET CHARACTER SET utf8 datadir=/data/mysql socket=/data…_size = 12M read_buffer_size = 4M [Server] server-id = 1 log-bin=/data/mysql/drbd [Server] server-id = 1 log-bin=/data/mysql/drbd…

Filed Under: Insight for DBAs Tagged With:

Comment: Why MySQL could be slow with large tables ?

June 20, 2007 By 141 Comments

… thread_concurrency=4 myisam_sort_buffer_size=950M character-set-server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow_queries=/var…

Filed Under: Insight for DBAs Tagged With: ,

Comment: Why MySQL could be slow with large tables ?

December 17, 2012 By 141 Comments

… records only very slow. so please guide me where to set parameters to overcome this issue. my.cnf file contains the….sock user=mysql init_connect=’SET collation_connection = utf8_general_ci; SET NAMES utf8;’ default-character-set=utf8 character-set-server=utf8 collation-server=utf8_general_ci [client] default-character-set=utf8 set-variable = max_allowed_packet…

Filed Under: Insight for DBAs Tagged With: ,

Post: MySQL Upgrade Webinar Questions Followup

June 28, 2012 By 7 Comments

… setting character set to utf8 – this is not needed as MySQL 5.5 continues to support various character sets same as previous MySQL versions. Moreover utf8 character set continues… from MySQL 5.5 to Percona Server 5.5 Compatibility is our highest priority with Percona Server, so it should be good…

Filed Under: Insight for DBAs, MySQL

Comment: Fixing column encoding mess in MySQL

January 26, 2011 By 32 Comments

… is utf8, the original data we imported may have been utf-8, the tables were MyISAM – it came out of Sql Server…. Searching everywhere, I have found nothing that tells me what character set encoding that is, and I’ve tried many. When it… upside-down exclamation marks and “section” glyphs, etc. And some characters look like „« (double-comma, double-left-angle-brackets…

Filed Under: Insight for Developers Tagged With:
« Older Posts