Parameter(s) need to take care when setting replication over WAN

Hello, I am setting MySQL (5.0) replication over WAN for backup purpose (with SSL enabled). I have read the document: http://dev.mysql.com/doc/refman/5.0/en/replication.html, and wonder if any special tunning needed for using replication over WAN. Are there any configuration parameter(s) need s

Storage of UTF-8 char in MySQL

According to this document: http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html It said MySQL support UTF-8 using one to three bytes per character. But I have created a test table: -- create table test ( c char(5) ) default charset =utf8; >From the table status, the data length is alway

int(10) va int(11)

Assume MySQL int range (unsigned) is from 0 to 4294967295 There are total 10 digits. Why a lot of tutorial in the web tell you to declare, e.g. CREATE TABLE t1 (f INT(11) UNSIGNED); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Re: Why UTF8 need 24bit in MySQL?

Hi, On Tue, Jun 8, 2010 at 12:44 AM, Warren Young wrote: >  The Unicode consortium has stated that Unicode will > never require more than 21 bits per character[*], and 24 bits is the next > even multiple of 8 up from that. Maybe off topic, but just curious...If 3 bytes is enough for all Unicode

Why UTF8 need 24bit in MySQL?

http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html Since MySQL only support BMP, so in fact 16 bit is needed actually? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Table level locking when inserting auto-increment PK to InnoDB

Hey. Back to few years ago, InnoDB require table level locking when inserting auto-increment PK to the table, and Heikki said there will be a fix. Is this problem still exist now? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql

Re: Help saving MySQL

On Sun, Dec 13, 2009 at 11:48 AM, Michael Dykman wrote: > I hope the only reason this thread  is so quiet is because we are all > busy notifying our friends.  There are a hell of a lot more users > invested in MySQL than those who read this list.  Spread the word! > Let's stand up today to face t

Table size vs Memory requirements?

Hello, Is it common heard from people that if you have large table (assume MyISAM in my case), you need large memory in order to have the key/index in memory for performance, otherwise, table scan on disk is slow. But how to estimate how much memory I need? Consider a simple case, a MyISAM table