Re: adding an index to a very large table (hours and hours??)

Yes it will take a long time depending on the size of the index also On 8/10/07, x x <[EMAIL PROTECTED]> wrote: > > I'm attempting to add an index to a table with 70 > million rows. > > DB server running on a reasonably fast Intel Mac on a > relatively slow drive. > > Should this take hours to com

adding an index to a very large table (hours and hours??)

I'm attempting to add an index to a table with 70 million rows. DB server running on a reasonably fast Intel Mac on a relatively slow drive. Should this take hours to complete ? So far it's taken 5 hours and counting. I'm afraid it's going to destroy my drive ! ___

Changing Big Big integer Value

I've recently converted a CRM database with about 20k entries. I exported the data to ACCESS had to tweak the field names and value then Inserted all into mySQL with mySQL Administrator. During the conversion out of the CRM into ACCESS the unique Primary Key for each contact, which is also the F

Re: Insert Select query problem

Thanks Jay, I had to make a change to the first part of the query to get the results that I wanted but your suggestion was definitely what I needed to get to the solution. Thanks again. For those that are interested, here's the final solution, INSERT INTO purchase (Source, Item, Qty) SELEC

MySQL Ends Enterprise Server Source Tarballs

Is this anything to be concerned about? We are Enterprise customers. We distribute mySQL on our appliance that we sell. It doesn't seem like we should worry, now. But I'm a little nervous about the future? http://linux.slashdot.org/article.pl?sid=07/08/09/2047231

Re: Insert Select query problem

Ed Reed wrote: Hi All, I have an issue that I need to resolve that is difficult to explain. I hope that someone can understand what I*m trying to do and shed some light on a solution. Here goes. I have three tables, inventory, which is a list of transactions with positive and negative value

Insert Select query problem

Hi All, I have an issue that I need to resolve that is difficult to explain. I hope that someone can understand what I*m trying to do and shed some light on a solution. Here goes. I have three tables, inventory, which is a list of transactions with positive and negative values; request, which e

Re: Inserting null values in mysql with PHP

My apologies.. I scanned back looking for the reference but couldn't find it... I thought it worth reiterating what turned out to be your point because there seems to be so much confusion around this issue. - michael On 8/9/07, Brent Baisley <[EMAIL PROTECTED]> wrote: > Actually, I said to m

Re[2]: Ошибка JOIN

> thats very smart to post in russian to an ENGLISH OONLY list! Sorri, i not speak english Прошу извинить меня, но я не говорю по английски. I have described as could, mistake cost(stand)s that. hereon appeared drain to memories, I happened to to overload server

Re: remove temporary table from SELECT query

Hi , "ORDER BY", will always use some temporary table for doing sort operation. For that matter, any group function, like min,max,group by,order by will use temporary table before displaying the final results. Regards anandkl On 8/10/07, Mike Zupan <[EMAIL PROTECTED]> wrote: > > neither of those

Re: remove temporary table from SELECT query

neither of those have fixed the issue.. I can create a sample database if anyone wants it to be of some help. Mike On 8/10/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > Also, its not good to set sort_buffer_size=256M, as this much of memory > will get allocated to each session, and if u have mo

Ошибка JOIN

Hi! uname -a Linux mysql1 2.6.16TD322 #8 SMP Thu Jul 27 18:39:45 MSD 2006 i686 unknown unknown GNU/Linux mysqld -V mysqld Ver 4.1.22-standard-log for pc-linux-gnu on i686 (MySQL Community Edition - Standard (GPL)) Выполнялся такой запрос из под PHP (в нем была допущена ошибка) $Query = "S

Re: MAKE QUERY USING JOIN BY RETRIEVING DATA FROM TWO MYSQL SERVER

Hi Everybody, If any body knows how to implement federated storage engine and how to setup it. How it works. Please enrich me also. -Regards, Krishna On 8/10/07, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > Its not possible in innodb or myisam engine, you can do it using fedrated > if i am not wr

Re: remove temporary table from SELECT query

Also, its not good to set sort_buffer_size=256M, as this much of memory will get allocated to each session, and if u have more than 10 connections at any point of time then it will more than 2GB RAM will get allocated and system will be slow. I feel sort_buffer_size=1MB should be good in my.cnf Yo

Re: remove temporary table from SELECT query

at your mysql prompt set sort_area_size=1; try this regards anandkl On 8/10/07, Mike Zupan <[EMAIL PROTECTED]> wrote: > > Which is the my.cnf entry I need to increase. I'm only getting around 4k > > back_log = 75 > skip-innodb > max_connections = 500 > key_buffer = 512M > sort_buffer_s

Re: remove temporary table from SELECT query

Which is the my.cnf entry I need to increase. I'm only getting around 4k back_log = 75 skip-innodb max_connections = 500 key_buffer = 512M sort_buffer_size = 256M join_buffer_size = 128M read_buffer_size = 128M sort_buffer_size = 128M table_cache = 1800 thread_cache_size = 384 wait_timeout = 7200

Re: MAKE QUERY USING JOIN BY RETRIEVING DATA FROM TWO MYSQL SERVER

Its not possible in innodb or myisam engine, you can do it using fedrated if i am not wrong. regards anandkl On 8/10/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote: > > Hi All, > > There are two mysql server. I need to retrive data from two different > hosts > (mysql server) and by usi

Lots of queries doing "statistics"

Hi all, I'm working on a site at the moment that experiences a strange problem when the traffic passes a certain point. Active connections are usually < 50, but at about 9pm every evening (our peak time) they suddenly leap up to max_connections. I wrote a script to log the output from show f

MAKE QUERY USING JOIN BY RETRIEVING DATA FROM TWO MYSQL SERVER

Hi All, There are two mysql server. I need to retrive data from two different hosts (mysql server) and by using a join make a query. Is it possible to make a query which can fetch data from two different mysql server using join. -Regards, Krishna

Re: Plz Help!!! SELECT not working with Å Æ Ø Ä Ö Characters

in addition to the correct character-set also set the appropriate collation sequence suomi VeeJay wrote: Hello there I have a problem. When I try to select some names starting with extra alphabets (Å Æ Ø Ä Ö, etc), I simply don't get required results i.e., if I give a select command like: se