Re: ENGINE=ARCHIVE doesn't support INDEX!!??

Correct. I assume the thinking behind it, is that you use that kind of table for huge amounts of inactive data, so it doesn't matter if your selects are a bit slower. Also, keep in mind that because it is a compressed file format, you will be scanning much more data per physical read than with a re

Re: Is conversion required?

On Sep 29, 2010, at 5:15 PM, Paul Halliday wrote: > I just converted (reinstalled) a FreeBSD system from i386 to amd64. Of > course; I missed the memo. I have been struggling to get everything back > online. I just finished exporting a few Gigs of RRD's to XML so that I could > use them :| > > M

Re: Kill All Proccesses

you can do it by a simple shell script by doing a grep of id's and passing it to mysql. On Wed, Sep 29, 2010 at 8:31 PM, Willy Mularto wrote: > AFAIK mysqladmin just kill a proccess and can not do kill all instances. > > > > sangprabv > sangpr...@gmail.com > http://www.petitiononline.com/froyo/

Re: Kill All Proccesses

AFAIK mysqladmin just kill a proccess and can not do kill all instances. sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Sep 29, 2010, at 9:09 PM, Евгений Килимчук wrote: > mysqladmin kill id,id,... > > 2010/9/29 Willy Mularto > Hi, > I see so many locked tables and ca

RE: ORDER BY with field alias issue

Easy. SELECT DATE_FORMAT(`Time`, '%h:%i%p') as `Time_Format` FROM `reservation` ORDER BY `Time` > -Original Message- > From: BMBasal [mailto:bmb37...@gmail.com] > Sent: Wednesday, September 29, 2010 3:50 PM > To: 'Chris W'; 'MYSQL General List' > Subject: RE: ORDER BY with field alias is

ENGINE=ARCHIVE doesn't support INDEX!!??

I gotta ask... http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html#c11511 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: ORDER BY with field alias issue

It is inherent in your naming. As long as your alias "time" is the same as the column name "time", MySQL will have no way to distinguish which one you refers to exactly in your order-by clause, and chooses the alias in the select-clause as the one you intended. You confused MySQL. First, why you h

Getting a Value and an Average Value of Previous 20 Records in One Query

I have been struggling with this issue most of the day. I can get the result I need by using 2 queries, but that takes way too long. I'm trying to see if there is a way to get the same result within a single query. Here's the table CREATE TABLE `log` ( `id` int(14) NOT NULL auto_increment, `Va

Is conversion required?

I just converted (reinstalled) a FreeBSD system from i386 to amd64. Of course; I missed the memo. I have been struggling to get everything back online. I just finished exporting a few Gigs of RRD's to XML so that I could use them :| My question: I was s/rushing/stupid so I just moved /var/mysql to

RE: How to get hanging 1:M table rows as single column in main query?

BRILLIANT SELECT `id_fmr`, `fmr_number`, `fmr_system`, `fmr_station`, `created_ts`, GROUP_CONCAT(`seat`) FROM `fmr` JOIN `fmr_has_seat` USING (id_fmr) JOIN `dim_seat` USING (id_dim_seat) WHERE id_fmr = 3 GROUP BY id_fmr; id_

RE: INSERT DELAYED and created_on timestamps

> -Original Message- > From: Dan Nelson [mailto:dnel...@allantgroup.com] > Sent: Wednesday, September 29, 2010 2:26 PM > To: Daevid Vincent > Cc: 'MySQL' > Subject: Re: INSERT DELAYED and created_on timestamps > > In the last episode (Sep 29), Daevid Vincent said: > > I'm doing some re

Re: INSERT DELAYED and created_on timestamps

In the last episode (Sep 29), Daevid Vincent said: > I'm doing some reading on INSERT DELAYED > http://dev.mysql.com/doc/refman/5.0/en/insert.html > > I have a user_log table: > > CREATE TABLE `user_log` ( > `id_user_log` bigint(20) unsigned NOT NULL auto_increment, > `id_user` int(10) unsign

INSERT DELAYED and created_on timestamps

I'm doing some reading on INSERT DELAYED http://dev.mysql.com/doc/refman/5.0/en/insert.html I have a user_log table: CREATE TABLE `user_log` ( `id_user_log` bigint(20) unsigned NOT NULL auto_increment, `id_user` int(10) unsigned default '0', `created_on` timestamp NOT NULL default CURRENT_T

Re: Migrating my mindset from MyISAM to InnoDB

> 2.  Don't stare at the screen.  Start it, script the process & have it email > your phone when it's done.  Do something else in the mean time. I don't literally stare at the screen -- of course I script it and do other things.. but when I have a resource limited environment, it sure would be ni

Re: How to get hanging 1:M table rows as single column in main query?

GROUP_CONCAT() ? And group by id_fmr ? JW On Wed, Sep 29, 2010 at 2:38 PM, Daevid Vincent wrote: > Given three basic tables. An "fmr" table which has Field Maintenance > Reports, a Seat table and a "hanging" or "glue" table to map Seats to FMRs. > [See below] > > How do I get all the Seats to

How to get hanging 1:M table rows as single column in main query?

Given three basic tables. An "fmr" table which has Field Maintenance Reports, a Seat table and a "hanging" or "glue" table to map Seats to FMRs. [See below] How do I get all the Seats to be in a single "row" with the FMR data? If I make this kind of query, they come in as separate rows: SELECT

Re: Not to show until a certain date

On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson wrote: > On 9/28/10 8:33 PM, Chris W wrote: > >> >> SELECT * >> FROM announcements >> WHERE announcements_expiredate > CURDATE() >> AND announcements_postdate <= CURDATE() >> ORDER BY announcements_expiredate ASC Or how about something like

Re: Select NICE

At 10:49 AM 9/29/2010, Steve Staples wrote: Google has not been kind to me on this one, so I figured I would ask here... how can I select with NICE options, so that it doesn't KILL my server, or any other queries... Do you understand what I am asking? Steve Steve, You might look at http://

Select NICE

Google has not been kind to me on this one, so I figured I would ask here... how can I select with NICE options, so that it doesn't KILL my server, or any other queries... Do you understand what I am asking? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Re: Migrating my mindset from MyISAM to InnoDB

In the last episode (Sep 28), Gavin Towey said: > Also note, 5.5 isn't production ready. 5.1 is the current GA release. 5.5 is really really close, though (5.5.6 is marked as Release Candidate), Better to switch now while you're already doing a migration, and then install 5.5.x updates as they ha

Re: Kill All Proccesses

mysqladmin kill id,id,... 2010/9/29 Willy Mularto > Hi, > I see so many locked tables and can not be unlocked. Is there any single > command or tools to kill all processes? > > > > > sangprabv > sangpr...@gmail.com > http://www.petitiononline.com/froyo/ > > > > -- > MySQL General Mailing List >

Query locked at "Writing to net" state

Hello, I have a Windows Delphi application (Zeos component) which makes a request on a remote MySQL database. The server is in France. On a Windows workstation that is located in France (500 kilometers), the application works well despite the 200,000 records to retrieve. The same application

Re: Not to show until a certain date

On 9/28/10 8:33 PM, Chris W wrote: SELECT * FROM announcements WHERE announcements_expiredate > CURDATE() AND announcements_postdate <= CURDATE() ORDER BY announcements_expiredate ASC Thank you! -- Patrice Olivier-Wilson http://biz-comm.com -- MySQL General Mailing List For list archives: h

Kill All Proccesses

Hi, I see so many locked tables and can not be unlocked. Is there any single command or tools to kill all processes? sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lis