Re: mysql float data type

problems you'd avoid when using DECIMAL instead ... -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) MariaDB Corporation | http://www.mariadb.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: mysql float data type

calculations though. see also: http://dev.mysql.com/doc/refman/5.5/en/problems-with-float.html -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) MariaDB Corporation | http://www.mariadb.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Long time for client to connect; not for script.

. This will disable fetching schema information on all possible table and column names for tab completion which can take quite some time depending on the shema size of the database you're connecting to ... -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) MariaDB Corporation | http://www.mariadb.com

Re: index collate

, this would come down to having a functional index or index on expression as you'd need to apply CAST() or CONVERT() on the column first to change the collation. MySQL doesn't have support for expression based indexes though ... -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) SkySQL

Re: fragmentation in innodb index

... -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) SkySQL - The MariaDB Company | http://www.skysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: backup of databases which have a mix of MyISAM- and InnoDB-tables

XTrabackup can handle both InnoDB and MyISAM in a consistent way while minimizing lock time on MyISAM tables ... http://www.percona.com/doc/percona-xtrabackup/2.1/ -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) SkySQL - The MariaDB Company | http://www.skysql.com/ -- MySQL General

Re: Case sensitivity

columns added later, but existing columns will keep their current character set and collation. ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name [COLLATE collation_name] is needed to change the default *and* all already existing columns -- Hartmut Holzgraefe, Principal Support

Re: Case sensitivity

%'; and explain what exactly you mean by is case sensitive. Are you referring to database and table names being case sensitive here, or to comparisons (=, LIKE) on textual values? Seeing a few example queries and the different results returned by 5.0 and 5.5 would sure help, too ... -- Hartmut

Re: Case sensitivity

. As the collation_database variables differ between the two servers (utf8_bin vs. latin1_swedish_ci) I assume that the same is the case for the actual tables, and that would perfectly explain why one treads lower/upper case as distinct while the other doesn't -- Hartmut Holzgraefe, Principal Support Engineer (EMEA

bzr bug or corrupted 5.7 tree?

wrong ... question is whether this is a corrupted tree or actually a bzr bug ... -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) SkySQL - The MariaDB Company | http://www.skysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Why is mySQL not respecting foreign characters as different

here: http://www.skysql.com/blogs/hartmut/adding-case-insensitive-distinct-unicode-collation -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) SkySQL | http://www.skysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Mysql cache issues???

results that may already be out-of-date, and the more active cache entries that need to be purged the longer it stays locked ... -- Hartmut Holzgraefe hart...@skysql.com Principal Support Engineer (EMEA) SkySQL AB - http://www.skysql.com/ -- MySQL General Mailing List For list archives: http

Re: how to get the levels of a table or a index in Mysql 5.6?

On 08.07.2013 04:23, 李炜(平安科技数据库技术支持部) wrote: how to get the levels of a table or a index in Mysql 5.6? Level? What is level supposed to be in that context? Cardinality? Or something completely different? /me confused ... -- Hartmut Holzgraefe hart...@skysql.com Principal Support Engineer

Re: REQUEST

On 07/04/2013 01:15 PM, Emmy Santi wrote: my name is Effiong Emmanuel.I love your products and your ways of helping human.pls can you send me MYSQL COMPILER to enable me install it in my laptop computer and practice.I will be gratefull if my request is kindly granted. what do you refer to

Re: Session ID Generation

anyway) and KILL (which requires SUPER privileges on the database anyway, and at that point you've already lost to an attacker ...) -- Hartmut Holzgraefe hart...@skysql.com Principal Support Engineer (EMEA) SkySQL AB - http://www.skysql.com/ -- MySQL General Mailing List For list archives: http

Re: Session ID Generation

. -- Hartmut Holzgraefe hart...@skysql.com Principal Support Engineer (EMEA) SkySQL AB - http://www.skysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: SHOW INNODB STATUS - FILE I/O - OS reads/writes/syncs?

-through/ has a pretty good description of the SHOW ENGINE INNODB STATUS output, even though it is not too detailed in this specific section. -- Hartmut Holzgraefe hart...@skysql.com Principal Support Engineer (EMEA) SkySQL AB - http://www.skysql.com/ -- MySQL General Mailing List For list

Re: open files in mysqld 5.1.53

On 06/13/2013 09:41 AM, walter harms wrote: Hello Manuel, thx for your tip. We caught the problem when we moved to partitions. Strange is that while testing the problem did not show up and even now we no clue why we experience the sudden burst of use for file descriptors. problem with

Re: string-likeness

, not operation type * do not maintain a full len1*len2 array, having only the previous and current row in two one dimensional arrays is sufficient (this esp. helps in C implementation as the functions working set is more likely to fit into CPU caches) ... -- Hartmut Holzgraefe hart...@skysql.com

Re: Version 5.6.2-m5 Boolean Datatype

On 05/22/2013 06:55 PM, Neil Tompkins wrote: Hi, I've just created some tables that I designed using the MySQL Workbench Model. However, the database type BOOLEAN which was in my models has been converted to TINYINT(1); I'm currently running MySQL Version 5.6.2-m5 on Windows 2008 server.

Spatial changes in InnoDB - Details?

don't seem to be possible with 5.7.1 [2] So what is the actual improvement in InnoDBs support of spatial types supposed to be? [1] http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html [2] http://pastebin.com/VnqZ6guG -- Hartmut Holzgraefe hart...@skysql.com Principal Support Engineer

test - please ignore

i said: ignore! -- hartmut -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Application lost database connection

it manually as needed ** add connection property 'autoReconnect=true' to have the MySQL Java connector deal with this automatically -- Hartmut Holzgraefe, MySQL Regional Support Manager, EMEA Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht München: HRB