Re: why size of table c united from table a and b are bigger than a+b ?

chylli wrote: chylli [EMAIL PROTECTED] writes: Chris [EMAIL PROTECTED] writes: Because you're adding all columns from a and b into it. It is too slow. Has anyone better methods to do that work? Drop the indexes on c and create them at the end. Each row that's being added, it's updating

Re: Can Innodb reuse the deleted rows disk space?

hi, Chris I'm sure it will, what makes you think it won't? Because some paper say that when the row is deleted or update, Innodb just make a mark that the row is deleted and it didn't delete the rows. I can't find more information about the re-use tablespace. Can you give me more? Regards,

Re: Can Innodb reuse the deleted rows disk space?

leo huang wrote: hi, Chris I'm sure it will, what makes you think it won't? Because some paper say that when the row is deleted or update, Innodb just make a mark that the row is deleted and it didn't delete the rows. I can't find more information about the re-use tablespace. Can you give me

Re: Can Innodb reuse the deleted rows disk space?

hi, Chris So, the deleted rows' disk space in tablespace can't re-use when I use Innodb, can it? And the tablespace is growing when we update the tables, even the amount of rows do not increase. Regards, Leo Huang 2006/7/28, Chris [EMAIL PROTECTED]: leo huang wrote: hi, Chris I'm sure

optimize mysql geometric query

hi, i have attached my geometric query which is very slow. how to optimize this query regards shann ___ Hot new product - Spider Networks introduces stunning online ePortfolio solution for students and teachers

Re: why size of table c united from table a and b are bigger than a+b ?

A good idea, thanks very much. -- Thanks Regards Chylli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: optimize mysql geometric query

Try to run an explain on the query to see how mysql optimizes it. Also have a look at your system resources while the query runs to see if you have a problem with memory/swapping. I am not sure (since i've never used union), but my guess is that mysql uses temporary tables for this, so maybe

What does optimize mean?

Seeing posts about mysqlcheck on the list prompted me to check out that utility. A lot of it I can see is very useful, and I understand what it does. However, what does the optimize command mean? What does it do? The help file says that the -o option optimizes, but what does that mean?? I

Re: What does optimize mean?

read the manual: http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html Jesse wrote: Seeing posts about mysqlcheck on the list prompted me to check out that utility. A lot of it I can see is very useful, and I understand what it does. However, what does the optimize command mean? What

Threads of terminated clientapplications

Hello MySQL Comunity. We have a problem with abortet clients and long time querys. If our application performs a long time select statement on the mySql database and the application is abortet, the query still runs! We tried several time-out variables like wait_timeout, interactive_timeout

RE: Mysqlcheck issues

-Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Thursday, July 27, 2006 22:40 To: Dilipkumar; Dirk Bremer; mysql@lists.mysql.com Subject: RE: Mysqlcheck issues The trouble with myisamchk is that it requires the server to be offline. This

RE: Mysqlcheck issues

-Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Thursday, July 27, 2006 22:42 To: Dirk Bremer Cc: mysql@lists.mysql.com Subject: Re: Mysqlcheck issues Dirk Bremer wrote: I am using MySQL server 4.1.10 on Windows 2003 Server with MyISAM tables. I have an issue

MySQL lock tables - bug or not?

I'm using MySQL as the db for Drupal (PHP based CMS), on shared hosting. There are repeated errors because the db user does not have permission for LOCK TABLES, which Drupal uses. The ISP says that they don't grant this permission because ... MySQL has a bug which allows users with

MySQL 4.1.21 has been released

Hi, MySQL 4.1.21, a new version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that

Re: MySQL 4.1.21 has been released

Joerg Bruehe wrote: Hi, MySQL 4.1.21, a new version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and

Re: how to move datadir to a different file system

On Thursday 27 July 2006 08:35 pm, Dilipkumar wrote: Hi, If the tables are not in use you can tar -cvzf filename.tar.gz the datadir and move it to the new server, but you should use the same mysql version. I'd mysqldump the tables, move to the new filesystem, then re-import the tables again.

Re: MySQL 4.1.21 has been released

On Fri, Jul 28, 2006 at 07:34:07AM -0600, John Meyer wrote: Is there still development going on of mysql 4? In general, only security-related bugs are being fixed in the 4.1 tree. (Sometimes other bugs will get fixed in those trees in the course of implementing a fix intended for the later

Re: Can Innodb reuse the deleted rows disk space?

In the last episode (Jul 28), leo huang said: 2006/7/28, Chris [EMAIL PROTECTED]: leo huang wrote: Because some paper say that when the row is deleted or update, Innodb just make a mark that the row is deleted and it didn't delete the rows. I can't find more information about the re-use

Re: Threads of terminated clientapplications

In the last episode (Jul 28), André Ress said: We have a problem with abortet clients and long time querys. If our application performs a long time select statement on the mySql database and the application is abortet, the query still runs! We tried several time-out variables like

Re: MySQL lock tables - bug or not?

I am not aware of any such bug related to the LOCK TABLES privilege. Like you I could not find a mention in our bugs database, for any version. It is easy to demonstrate that this is not the case. If permissions are properly set up, LOCK TABLES can be restricted to a database just like every

Re: What does optimize mean?

OK, I missed it this time because I partially typed in something when searching for this in the manual. I searched for optimiz, and stopped there and ran across optimization But missed the OPTIMIZE TABLE entry. Sorry about that. I'll read through that. Thanks, Jesse - Original Message

Bug in mysqldump or mysql-server 5.0?

[I searched the bug database...please let me know if I missed an already filed or fixed bug.] I am trying to dump a database from MySQL 4.0.24 using the client tools from 5.0. Debian server, Ubutnu 6.06 client. I use this command line (watch for wrap): mysqldump -u jkugler -p -h dbserver

Way too slow Load Data Infile

I executed a Load Data Infile 24 hours ago and its still running. Yikes! I have 6 of these tables to load and at this rate it will take forever. Can someone please run through my Status variables and let me know if there is a way I can optimize it? (These values are current with the Load Data

Re: Way too slow Load Data Infile

I ran a file monitor and it appears MySQL has been updating the table's index for the past several hours as part of the Load Data Infile process. Is there any way to speed this up? I'm using MySIAM tables in v4.1.10. Here are the settings I'm using. Is there anything in there that will speed up