Index file ratio
Is there a correlation between myisam table file size and related .myi file size ? If I need to introduce additional index for some field in 40-50Gb table, would there be any concerns about my.ini settings like key_buffer_size etc. Is it possible to place index file to memory to speed up things during table alteration and then unload it ? Would that be rational ? regards, Khazret Sapenov CMS Inc.
Re: A question of negative numbers..
ABS(column) ? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 6:59 AM Subject: A question of negative numbers.. Hi, I have a query that returns a list of numbers ranging from -10 to +10 I would like to be able to have a 2nd column where a result of 5 is 5 but -5 is also 5, so in effect all the negative (and only the negative) results are made positive to find the deviation from zero. so 5, 4, -3, 4, -1, 0 would become 5, 4, 3, 4, 1, 0 I have been searching for if then else in google so I could do if a 0 then a = 0-a but no joy. is there a function to make negative numbers positive? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Subscription
Dear Tom [aka Cedomilj], Thank you for interest in MySQL AB - the world leader ... (blah-blah). Subscribing to MySQL mailing list is a free and unattended service. You don't have to remit any money to Nigeria (ZERO MILLION DOLLARS). Just sit back on your chair and read messages, posted to mailing list. No special arrangements needed. Best regards, MySQL DB Supporter - Original Message - From: Tom Murdock [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 03, 2004 12:56 PM Subject: Subscription Good evening, I would like to subscribe to MySQL mailing list. Thank you. Cedomilj _ FREE pop-up blocking with the new MSN Toolbar get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]