Re: Best encription method?

Sir, I must adopt the encryption. I shall bear the cost of the memory. Thank you for the guidance. Vikram A From: Johan De Meersman vegiv...@tuxera.be To: Vikram A vikkiatb...@yahoo.in Cc: MY SQL Mailing list mysql@lists.mysql.com Sent: Tue, 28 September,

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:

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:

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: Kill All Proccesses

mysqladmin kill id,id,... 2010/9/29 Willy Mularto sangpr...@gmail.com 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

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

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

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

Re: Not to show until a certain date

On Wed, Sep 29, 2010 at 8:33 AM, Patrice Olivier-Wilson b...@biz-comm.com 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

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: 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 dae...@daevid.com 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

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 nice

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

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) unsigned

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 reading on

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;

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

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,

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 have

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

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 issue

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 sangpr...@gmail.com Hi, I see so many

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 sangpr...@gmail.com wrote: AFAIK mysqladmin just kill a proccess and can not do kill all instances. sangprabv sangpr...@gmail.com

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 :| My