RE: Trouble with large data in MySql

2008-10-13 Thread John Murtari
follows on SMAS table > select campaignName, siteName, adnetwork,date_format(loggingTime ,'%d/%m/%Y') logDate, count(distinct requestid) adpage from SMAS where sucess = 1 GROUP BY 1,2,3,4 -- John _____

Additional language support for tracking server usage.

2008-10-13 Thread John Murtari
0| 699 | 646855 | -- John _______ John Murtari Software Workshop Inc. [EMAIL PROTECTED] 315.635.1968(x-211) "TheBook.Com" (TM) http://www.thebook.c

Re: Getting MySQL activity as a per database value

2003-10-06 Thread John Murtari
Jeremy Zawodny writes: > On Fri, Oct 03, 2003 at 08:29:17AM -0400, John Murtari wrote: > > Folks, > > > > I've done a lot of searches, tried out the tools I could > > find (like phpMyAdmin/mtop). We have a server with about 30 DB's > > a

Getting MySQL activity as a per database value

2003-10-03 Thread John Murtari
data available. Best regards! -- John _______ John Murtari Software Workshop Inc. [EMAIL PROTECTED] 315.695.1301(x-211)"TheBook.Com" (TM) ht