… INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path/to/SYS_FIELDS’ REPLACE INTO TABLE `SYS_FIELDS` FIELDS TERMINATED …` 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_update` …
Post: Converting Character Sets
March 17, 2009 By 22 Comments
… 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… (0.02 sec) mysql> ALTER TABLE `t1` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; Query OK, 0 rows affected (0.02 sec) Records…
Comment: Why MySQL could be slow with large tables ?
December 17, 2012 By 141 Comments
…only very slow. so please guide me where to set parameters to overcome this issue. my.cnf file contains the…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 =…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
…: 2006-11-12 00:01:45 Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: 1 row in set (0… Create_time: NULL Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: 1 row in set (0… MyISAM table rather than incremental insertions. I also compared it to compressed MyISAM – this would take 1250MB so Archive does compress…
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
…, PRIMARY KEY (`i`), KEY `j` (`j`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 mysql> show table status like “sample” \G; *************************** 1. row *************************** Name… 07:31:51 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: InnoDB free: 1591296 kB 1… random portion of rows (about 1/16) with random distribution to the pages (column j was populated by md5(rand()) values…
Comment: COUNT(*) for Innodb Tables
July 19, 2012 By 32 Comments
… “SHOW TABLE STATUS” command it will varry from real number to small degree, but this is perfectly fine for statistics on… 07:14:09 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: customer table 1 row in…
Comment: Using MyISAM in production
June 18, 2006 By 36 Comments
…. Here is how to see it: # myisamchk -dvv table.MYI MyISAM file: table.MYI Record format: Packed Character set: utf8_general_ci (33) File…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 141 Comments
…) — I have used a table MyISAM, info from phpmyadmin: Collation utf8_general_ci lenght row 122 row dimension avg 194 byte row 411…/mysql socket = /var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x… this configs? – do i switch table from MyISAM to InnoDB (if yes, how to configure InnoDB for best performance?) – what parameters i…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… 16:24:54 Update_time: NULL Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: 1 row in set (0… this software RAID could do in real IOPs. I started to experiment with different read_ahead configuration. Percona Server still allows me to enable Random Read_Ahead which is not available in MySQL…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… to possible duplicates. This problem is avoided when upgrading to Percona Server by converting the affected tables or columns to the collations introduced: utf8_general_ci to utf8_general50_ci, and ucs2_general_ci to utf8_general50_ci. Blueprint:utf8-general50-ci-5…
