Re: numeric types

Hi I have already tried DECIMAL type but I cannot get what I want. Maybe the simple way to get data out of MySQL and data inside MySQL the same, is to reproduce what MySQL does by default on my data out of MySQL. Check out the DECIMAL type. / Carsten Sebastien MORETTI skrev: Hello, I

numeric types

Hello, I have a row which is defined as double unsigned (MySQL 5.0.26-Max, OpenSuse). Values in this row can go from a single digit, like 1, to values like 0.0006872207 or 1.2513e-18. I want to store exact numbers. But I would like also this: 1 stored as 1.0 0.098

Re: innodb_file_per_table cost

Hi Sebastian, It depends. In general, no. In some filesystems and operating systems, it actually helps. I think you can base your decision on whether it makes server administration easier for you. Regards Baron Thanks It seems there are no clear thresholds between I/O access, the number of

Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI wrote: Hi, Your data is gone (unless you can undelete it from whatever filesystems you're using). I think it's too late for this, because the MySQL server has been restarted. You may be able to recover from the file

Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI wrote: Hi, Your data is gone (unless you can undelete it from whatever filesystems you're using). I think it's too late for this, because the MySQL server has been restarted. You may be able to recover from the file

Re: ibdata1 lost

mysqld and the tables should be replaced with the old ones but with no data. Thanks for the schema. But the main problem is the data. The generation process was near completion when we lost ibdata1 file. So, no dump. Andrew -Original Message- From: Sebastien MORETTI [mailto

innodb_file_per_table cost

Hi, Does the use of "innodb_file_per_table" option imply a performance cost ? Compared to default: all InnoDB indexes are in ibdataX file(s). Thanks -- Sébastien Moretti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mys

ibdata1 lost

Hi, Is there a way to recover data and/or database schema when ibdata1 file has been removed (for InnoDB databases) ? (MySQL 5.0.26) Thanks -- Sébastien Moretti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsu

Re: How to show highly frequent words in fulltext index ?

It looks perfect. Thanks Google for "myisam_ftdump", HTH Cor - Original Message ----- From: "Sebastien Moretti" To: Sent: Thursday, April 23, 2009 5:24 PM Subject: How to show highly frequent words in fulltext index ? Hi, Is there a command to see which words ar

How to show highly frequent words in fulltext index ?

Hi, Is there a command to see which words are highly frequent in a fulltext index ? Thanks -- Sébastien Moretti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Performances between different filesystems

Hello, I look for updated performances between different file systems. I have only found performances computed between 2003 and 2005, and for x86. Do you have any updated performance tables for XFS, ReiserFS and Ext3 file systems, on linux x86 AND x86_64 ? And with or without raid ? Thanks -