Re[2]: Mysql growing pains, 4 days to create index on one table!

2004-07-15 Thread Pete McNeil
On Thursday, July 15, 2004, 9:10:43 AM, matt wrote: mr Justin Swanhart wrote: Indexes can generate vast amounts of random i/o. Because of rotational latency, random i/o can really slow you down, especially if you are using IDE or SATA disks because they can't do tagged queueing like SCSI disks

Re: indexing text

2004-06-11 Thread Pete McNeil
On Friday, June 11, 2004, 7:00:39 AM, Csongor wrote: FC Hi, FC I have a table that has a few short text fields [text(4000), text(1000)] FC I would like to index. Do you think it is a good idea to index them FC simply, or is it better if I create auxilary fields which hold the MD5 FC for the text

Re: mysql 3, subquerie alternative

2004-06-10 Thread Pete McNeil
On Thursday, June 10, 2004, 1:20:03 PM, Mark wrote: MvB Hi, MvB For a project I'm creating a search function, the deal is this, a select MvB query must be submitted and in this query a check must be done to confirm a MvB previously found and accepted item is not shown anymore, a short version of

Re[2]: My question is too idiot for nobody answer?

2004-06-03 Thread Pete McNeil
On Thursday, June 3, 2004, 8:14:00 AM, Victor wrote: VP If you choose to copy the files I would ensure that you are getting the VP innodb binary logs as well if they do not exists in the mysql data VP directory. The innodb backup tool or even mysqldump may provide a more VP consistent snapshot.

Range query on datetime with index - any optimization?

2004-05-05 Thread Pete McNeil
Hello folks, I'm usinng MySQL 4.0.17. I have a table something like: RuleID int, GMTBase datetime, Credited bigint, ... I have an index built on GMTBase. I have rougly 8 million rows. GMTBase stores a datetime for the top of the hour on a given date. I want to build a summary of the last 2

Re: Range query on datetime with index - any optimization?

2004-05-05 Thread Pete McNeil
At 01:30 PM 5/5/2004, Daniel Clark wrote: I wonder if mysql isn't trying to process where GMTBase DATE_SUB(CURRENT_DATE, INTERVAL 2 DAY) What about doing this date subtracting in PHP and adding the result to the SQL statement. Nice try - but it's not the problem. Replacing the equation with a

Re: AW: C compared to C++/Java; Was: Re: InnoDB Hot Backup + MySQL em bedded?

2004-02-21 Thread Pete McNeil
Hello, Personally, I think it's a matter of choosing the best tool for the job. For myself and my team, Java is the work horse particularly - suited for rapid application development and when there is a strong cross platform requirement. This means that Java tends to dominate our utilities and

Connection Lost Dumping Data Unexplained Pauses

2004-01-18 Thread Pete McNeil
Kind MySQL List, I need your help. I have an installation of replicated MySQL servers. I am migrating to new servers and upgraded MySQL software. My previous servers were RH8, MySQL 4.0.14. (A, B) My new servers are Fedora, MySQL 4.0.17. (C, D) Most of my critical data is built using INNODB

MYSQLDump loses connection on large dump.

2004-01-05 Thread Pete McNeil
. The mysql server remains responsive to queries before and after the operation. No errors are reported in the .err file.) Thanks again in advance! _M Pete McNeil (Madscientist) President, MicroNeil Research Corporation Chief SortMonster, www.SortMonster.com VOX: 703-406-2016 FAX: 703-406-2017

Re: Seeking advice on best table structure

2003-08-20 Thread Pete McNeil
At 03:30 PM 8/20/2003 -0700, Scott Haneda wrote: What would be a good way to deal with the following... I have a form that has 5 checkboxes on it, lets say the checkboxes are for categories, and more than one can be selected. For example: please tell is what brochure you want [] car [] boat []

Re: how to convert SQL Server 2000 database to MySQL?

2003-07-26 Thread Pete McNeil
started. Hope this helps, _M Pete McNeil (Madscientist) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What's up with this GATOR crap?

2003-07-10 Thread Pete McNeil
I couldn't believe it so I looked. When I load the manual page I _do not_ see any such thing. Something else must be going on. _M At 11:43 PM 7/10/2003 -0400, C. Reeve wrote: Hi, I have noticed recently that every time I go to the MySQL manual page I get prompted to install Gator spyware. If