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

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:

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:

Re: ibdata1 lost

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:sebastien.more

Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI sebastien.more...@unil.ch 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

Re: ibdata1 lost

Sebastien, On Wed, May 27, 2009 at 11:24 AM, Sebastien MORETTI sebastien.more...@unil.ch 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

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 sebastien.more...@unil.ch To: mysql@lists.mysql.com Sent: Thursday, April 23, 2009 5:24 PM Subject: How to show highly frequent words in fulltext index ? Hi, Is there a command

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