Alter Table - InnoDB

Hello, we having an 60 GB InnoDB database. The table with the problem is about 12GB. On of our scripts has got a problem and run 60 times an alter table: ALTER TABLE `foo` ADD INDEX ( `bar` ) ; We had to kill the alter table commands with kill on the mysql console. Now we have one index on the

Re: Alter Table - InnoDB

Hi Jonas, When ever an alter table command is executed on mysql tables, mysql creates a temp file with all the data + the current table. Once the alter table command is done, it will drop the current table and rename the new temp file to the current table, that the reason the disk usage goes

Re: Alter Table - InnoDB

Hi Ananda, Since u have cancled the job, those in-complete temp files can be deleted from the file system. ok - but I'm using InnoDB. The IBdata file is bumped up. There are no temp files on the database directory. Greets, Jonas -- MySQL General Mailing List For list archives:

Re: Alter Table - InnoDB

So, now u dont have free space in your file system. Is this a production db. I think, restarting the db, should not cause any harm. Which version of mysql. regards anandkl On 12/4/08, Jonas Genannt [EMAIL PROTECTED] wrote: Hi Ananda, Since u have cancled the job, those in-complete temp

Re: Alter Table - InnoDB

I thought you always have to go to the physical location and delete the tmp files manually. These are created in tmp folder. I am not sure if restarting helps... Regards, Shachi Govil - Original Message - From: Ananda Kumar [EMAIL PROTECTED] To: Jonas Genannt [EMAIL PROTECTED] Cc:

Re: Alter Table - InnoDB

Hi Ananda, So, now u dont have free space in your file system. Is this a production db. I think, restarting the db, should not cause any harm. Which version of mysql. no free space it not my problem. I have only noticed that ibdata file uses more space than before. Yes this is an production

Re: Alter Table - InnoDB

Hello Shachi, I thought you always have to go to the physical location and delete the tmp files manually. These are created in tmp folder. I am not sure if restarting helps... since I am using InnoDB, there is no tmp folder. The Ibdata file after killing alter table commands: -rw-rw 1

Re: Alter Table - InnoDB

Hi, Since u have cancled the job, those in-complete temp files can be deleted from the file system. ok - but I'm using InnoDB. The IBdata file is bumped up. There are no temp files on the database directory. What's the problem with a larger ibdata-file? If the index is dropped, there is

Re: Alter Table - InnoDB

Hi jones, Innodb does not release the space unless you optimize the tables. To dot that you need to run dummy alter on all tables, by issuing Alter table table name engine=InnoDB but the space shall not regaing unless you start the table with innodb_file_per_table option. Then if you run the

mysql server crash

Hello, We see this error in the event viewer. The application, C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe, generated an application error The error occurred on 12/04/2008 @ 13:26:05.398 The exception generated was c005 at address 005471B4 (mysqld_nt). This is repeating

Re: Query to Select records in the last 4 weeks

Hi, I have tried to use this query: SELECT count(smsc_id) as total, insertdate FROM momtbak WHERE insertdate BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 4 WEEK) AND CURRENT_DATE() group by week(date_format(insertdate,'%Y-%m-%d'),3) to group records in the last 4 weeks by week. But the result

[SOLVED]Re: Query to Select records in the last 4 weeks

Hi, I finally found the solution SELECT count( smsc_id ) AS total, week( insertdate ) AS tanggal FROM momtbak WHERE insertdate BETWEEN DATE_SUB( CURRENT_DATE( ) , INTERVAL 4 WEEK ) AND CURRENT_DATE( ) GROUP BY week( insertdate ) Willy -- MySQL General Mailing List For list archives:

RE: Alter Table - InnoDB

Actually, that will not reduce the size of the ibdata1 file at all. Here is a GUARANTEED WAY to shrink that ibdata1 file, which YOU WILL NOW HAVE TO REPEAT EVER AGAIN !!! 1. Perform mysqldump of all databases, routines and triggers from the mysql server to /root/MyData.sql 2. Drop all

Re: How to create a unicode capable table??

Hello, Any thoughts on this? Thanks. On Tue, Nov 25, 2008 at 8:14 PM, Ali, Saqib [EMAIL PROTECTED] wrote: What Charset and Collation should I use while creating a mysql table such that it can take data from unicode SQL Server DB table? Thanks saqib http://doctrina.wordpress.com/ --

RE: How to create a Unicode capable table??

-Original Message- From: Ali, Saqib [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2008 1:02 PM To: mysql@lists.mysql.com Subject: Re: How to create a unicode capable table?? Hello, Any thoughts on this? Thanks. [JS] I'll be interested in seeing what responses you get. There

Re: Maintaining sort order with 'GROUP BY' and 'HAVING'

Its been a while since I posted this. Would like to check again with the folks on this list if they know why the results of query (b) are all blank on MySQL 5.0.22. It works fine with 5.0.51a. If it is a bug in 5.0.22, can someone suggest a workaround for this (other than upgrading MySQL).

Re: Maintaining sort order with 'GROUP BY' and 'HAVING'

Hi Nishi, I think what's more relevant is why did you downgrade to 5.0.22? The sorting issue you're experiencing was fixed for the 5.0.67 community release. Many bugs will have been fixed between 5.0.22 and 5.0.51a; downgrading is not a solution. Upgrade. If this is a new system you

Re: Could somebody tell me how to use the memcache engine inside mysql?

Thanks for your reply. I have installed memcached_function before this post. But when I use any function of this api, mysql client is dead. On Thu, Dec 4, 2008 at 12:15 AM, Rolando Edwards [EMAIL PROTECTED]wrote: Read The Attached PDF and Check Out These URLs