RE: Happy New Year

2009-01-01 Thread R.Rakesh 
Have a great and cherishable year ahead

*** Happy 2009 wishes from Me & Team ADA ***

 



Rakesh, "aDa"

www.adaindia.net

www.hybridskills.com

www.kalyxindia.com 

www.indianweatherman.org   

www.freedownloadshop.com  



 

From: Arumugam K [mailto:arumuga...@gmail.com] 
Sent: Wednesday, December 31, 2008 5:35 AM
To: akmah...@gmail.com; alluri.girid...@ge.com; ambu...@yahoo.com; 
ananth...@rediffmail.com; anil_chintakri...@satyam.com; anto singh; 
arr...@gmail.com; arumugam_kumare...@ge.com; arumugam_kumare...@satyam.com; 
arumugam.kumare...@ge.com; arumug...@rsi.ramco.com; arumuga...@gmail.com; 
arumuga...@rediffmail.com; arumuga...@yahoo.com; Arun. R; arun.chel...@tcs.com; 
Asif Iqbal; avpram...@gmail.com; Bala Mahesh :-); 
balamahes...@raysoftindia.com; balapi...@hotmail.com; bindhu bharathy; 
bobby_ni...@satyam.com; chenthi...@gmail.com; chent...@hmil.net; 
chintanhirem...@gmail.com; danilo.szabloc...@ge.com; 
dhanasekaran.balasubraman...@ge.com; dhinesh kumar; 
diamondunmah...@yahoo.co.in; dilse...@rediffmail.com; drhy...@gmail.com; 
drl...@gmail.com; durgaprasad.pullivar...@ge.com; 
gal...@hydrogen.cchem.berkeley.edu; gchen...@gmail.com; gomati.jagad...@ge.com; 
Gopinath Reddy; gopinathan.mani...@ge.com; harsha.du...@gmail.com; 
h...@nivethasoft.com; iqbal_a...@satyam.com; jfernan...@germinus.com; 
johncy.geo...@ge.com; johnvi...@rediffmail.com; kafoorsam...@gmail.com; 
karhikraj.loganat...@ge.com; karthic1...@gmail.com; karthick.rajend...@ge.com; 
krishna kumari; mahizh...@gmail.com; manojk.g...@gmail.com; 
mayela.esp...@ge.com; meeran; mgowrishank...@yahoo.co.in; 
mohan1.radhakrish...@ge.com; mother.blessi...@gmail.com; 
muthukar2...@yahoo.co.in; mysql@lists.mysql.com; nick.jenk...@ge.com; 
nilamuth...@gmail.com; nilamytheen; Ninan, Bobby (GE Money, consultant); nsk; 
NSK™ ㋡; parthasarathy.veeraragha...@ge.com; pinky.rajago...@ge.com; Poptest; 
prabha_ramas...@hyd.satyam.com; prabha_ramas...@satyam.com; 
prabha.ramas...@ge.com; priya_may...@yahoo.co.in; priya.aruch...@ge.com; 
radhakrishh...@yahoo.com; Radhakrishnan M; radhes...@gmail.com; 
raghavs_2...@yahoo.com; rajend...@precisionit.co.in; 
rajeshwara...@rediffmail.com; rakesh...@gmail.com; Ramesh Veturi; 
ramesh.periyas...@ge.com; rangababu.th...@ge.com; rathis...@gmail.com; ravi 
shankar the hungry tiger..; ravindran.a...@ge.com; 
revathy_subraman...@satyam.com; revathy.subraman...@ge.com; s_au...@yahoo.com; 
s.sundara kannan; sathyanarayanamoorth...@satyam.com; 
sathyanarayanamoor...@gmail.com; selvi_ramas...@satyam.com; senthil cr; senthil 
kumar; Senthil Kumar N; senthil.chelliahretnaraj@dnaoy.fi; 
senthil.sbil...@gmail.com; senthilkuma...@satyam.com; 
senthilkumar.ayyavuku...@oracle.com; senthilkumar...@ge.com; 
simo...@myself.com; Siva_Kalavakollu; sivakumar.dandayu...@ge.com; 
sivaprakasam.kasth...@ge.com; srinivas.bu...@ge.com; srinivas.bur...@ge.com; 
Srinivasan U; srinivasa...@tcs.com; Subramaniam O; 
subramania...@infotechsw.com; subramani...@infotechsw.com; 
sukanya_ramanat...@satyam.com; suki2...@rediffmail.com; t...@rsi.ramco.com; 
uvenkateshu; venkatasubbiah_velayut...@satyam.com; venkatesa_peru...@irco.com; 
venkateshwar.re...@ge.com; victor.lo...@ge.com; vijay.an...@ge.com; 
vijay.ku...@ge.com; Vivek M; Yamini Gupta
Subject: Happy New Year

 

Hi All,

New Year's Eve is the perfect time to bid goodbye to the year 2008 and welcome 
the New Year 2009. 

It's the time to rock and roll with friends and family

Let the New Year brings with it new hopes and new opportunities to explore.

! Wishing you all a happy and a prosperous New Year!

Regards

Arumugam.K

Re: slow query log

2009-01-01 Thread Ananda Kumar 
mysql> explain SELECT SUM(COUNTER_VALUE)  FROM STO_LIS sl,
-> SCAT_LIS sfl WHERE sl.STO_LIS_ID =
-> sfl.LIS_ID AND sfl.CAT_ID = '-1';

++-+---+--+---+---+-+-+--+-+
| id | select_type | table | type | possible_keys |
key   | key_len | ref | rows | Extra   |
++-+---+--+---+---+-+-+--+-+
|  1 | SIMPLE  | sfl   | ref  | PRIMARY,sfcatlist_lst |
PRIMARY   | 4   | const   |   23 | Using index |
|  1 | SIMPLE  | sl| ref  | STO_LIST_UK | STO_LIS_UK | 4   |
sm15.sfl.lis_id |1 | Using where |
++-+---+--+---+---+-+-+--+-+
2 rows in set (0.31 sec)

mysql>  SELECT SUM(COUNTER_VALUE)  FROM STORES_LISTING sl,
SFCATEGORY_LISTING sfl WHERE sl.STORES_LISTING_ID =  sfl.LISTING_ID AND
sfl.CATEGORY_ID = '-1';
++
| SUM(COUNTER_VALUE) |
++
|   NULL |
++
1 row in set (0.00 sec)




On 12/31/08, Baron Schwartz  wrote:
>
> Hi,
>
> On Wed, Dec 31, 2008 at 8:44 AM, Ananda Kumar  wrote:
> > Hi All,
> > I have enabled slow query log.
> > Generally this file will have sql's which take more than long-query time
> to
> > execute and also sql's not using indexes.
> > But i see sql's which does not come under the above condition.
> > I have set the long-query time to 1 Sec .
> >
> > The query takes less than 1 sec to execute and also uses indexes, but
> still
> > its recored in slow query log.
>
> What is the execution time shown in the slow query log?
>
> What is the query?
>
> If you can paste the whole log entry here, that would be good.
>
>
> --
> Baron Schwartz, Director of Consulting, Percona Inc.
> Our Blog: http://www.mysqlperformanceblog.com/
> Our Services: http://www.percona.com/services.html
>

How to Use Cascade Delete Properly

2009-01-01 Thread Lola J. Lee Beno 
I'm trying to understand how to use cascade delete properly but not sure 
if I have this backwards or not.  Here's an example: 


I have two tables:

mysql> describe adsource;
+-+--+--+-+-+---+
| Field   | Type | Null | Key | Default | Extra |
+-+--+--+-+-+---+
| adsource_id | varchar(35)  | NO   | PRI | NULL|   | 
| company_id  | varchar(35)  | YES  | MUL | NULL|   | 
| location| varchar(50)  | YES  | | NULL|   | 
| url | varchar(200) | YES  | | NULL|   | 
+-+--+--+-+-+---+



mysql> describe jobposts;
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-+---+
| jobpost_id   | varchar(35)  | NO   | PRI | NULL|   | 
| company_id   | varchar(35)  | NO   | MUL | NULL|   | 
| details  | text | YES  | | NULL|   | 
| job_title| varchar(50)  | YES  | | NULL|   | 
| postdate | date | YES  | | NULL|   | 
| salary   | decimal(5,2) | YES  | | NULL|   | 
| deadlinedate | date | YES  | | NULL|   | 
| adsource_id  | varchar(35)  | YES  | MUL | NULL|   | 
+--+--+--+-+-+---+




For jobposts; I have adsourcefk referencing adsource.adsource_id with 
cascade delete set. For adsource, I have companyfk referencing 
company.company_id with cascade delete set.


Now, say I have three jobposts records that have one referenced adsource 
record.  If I delete one jobposts record, there now remains two jobposts 
records.  If I delete the adsource record, the two jobposts records get 
deleted. I don't want this happening. 

What I want to have happen is: if I try to delete an adsource record and 
there are jobposts records containing that id as foreign key, I want the 
delete to NOT happen.  I can't use triggers because for some reason I 
can't get the triggers working properly.  Is there any way I can do this 
on the database side without having to write code in the application 
code I'm working on?


--
Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume | Blog at http://www.lolajl.net/blog/
"No greater injury can be done to any youth than to let him feel that
because he belongs to this or that race he will be advanced in life 
regardless of his own merits or efforts." - Booker T. Washington



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: how to disable InnoDB and MyISAM on ndb cluster

2009-01-01 Thread Eric Bergen 
Hi Nipuna,

InnoDB can be disabled with the skip-innodb option. MyISAM can't
really be disabled because it's required to read the grant tables.

-Eric

On Sat, Dec 27, 2008 at 4:21 AM, Nipuna Perera  wrote:
> Hi All,
>
> I'm using mysql-cluster-gpl-6.2.15 for create DB cluster in our server
> machines,
> currently I'm using 2 data nodes, 2 management nodes and two mysqld server
> nodes which were combine with same data directory in SAN.
> SAN for the collect binary logs only.
>
> What need to know are,
> 1. Is it possible to disable InnoDB and MyISAM engines while using the ndb
> cluster in mysqld servers, if it is yes, can you tell me the way of doing
> it?
> 2. Is there having any disterbance for ndb cluster by disabling the InnoDB
> and MyISAM?
>
> Thanks and Regards,
>
> --
> Nipuna Perera
> නිපුණ පෙරේ‍රා
> http://nipunaperera.blogspot.com
>



-- 
high performance mysql consulting.
http://provenscaling.com

RE: Can a JOIN statement do this?

2009-01-01 Thread Martin Gainty 

Happy New Year Mike-

JOIN USING(colId) and or JOIN ON(table1.colId=table2.colIdentifier) will 
preserve the use of Indexes which is faster

LIKE casts off Indexes and does a FTS

HTH
Martin 
Any recommendations on non-PHP Forum Software for Apache?

__ 
Disclaimer and confidentiality note 
Everything in this e-mail and any attachments relates to the official business 
of Sender. This transmission is of a confidential nature and Sender does not 
endorse distribution to any party other than intended recipient. Sender does 
not necessarily endorse content contained within this transmission. 




> Date: Thu, 1 Jan 2009 11:28:51 +0800
> From: mik...@qualityadvantages.com
> To: mysql@lists.mysql.com
> Subject: Can a JOIN statement do this?
> 
> Hello mysql and Happy New Year,
> 
> I am working with a Forum database. It contains a forums table, a
> posts table and a threads table. Some of the posts contain flash
> objects that I can find using a query like this one:
> 
> SELECT `pagetext`, `postid` FROM `post` WHERE `pagetext` LIKE
> '%someuniqueidentifier%'ORDER BY `postid` DESC
> 
> This query works fine for what I needed. Now, the requirement has
> changed to finding that latest object posted in a specific forum but
> the forum table has no direct reference to the postid. The thread
> table has a reference to the forumID but not a postID.
> 
> It looked something like this:
> posts table:
> 
> +-++
> | post_id | thread_id  |
> ++-+
> 
> forum table:
> 
> +--++
> | forum_id ||
> +--++
> 
> thread table:
> 
> ++--+
> | thread_id  | forum_id |
> ++--+
> 
> I know the forum ID that contains the objects but need to query the
> threads to see which ones contain posts with objects. Then grab the
> last one for processing.
> 
> So I think I have at least two queries now instead of the one I used to grab
> that latest objects from the database.
> 
> If I did manual queries, I would select the latest thread_id posted to
> forum_id and then a second query to find all the posts in that thread
> that contained objects and grab the last one posted.
> 
> I think this all might be combined with a join but I am not clear
> about how to do that because the conditional seems to need a result
> that I don't have until I run the first query, i.e. WHERE
> `forum_id`='163' AND `thread.thread_id`= (results of query to find
> last thread) AND `pagetext` LIKE %someobjectidentifier% DESC LIMIT 1
> 
> So, I am still wondering if using JOIN is the right path to purse to
> optimize this query.
> 
> Any suggestion greatly appreciated.
> 
> 
> -- 
> Best regards,
>  mikesz  mailto:mik...@qualityadvantages.com
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com
> 

_
Send e-mail anywhere. No map, no compass.
http://windowslive.com/oneline/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_anywhere_122008