Ben
>This ranks a set of lists based on the number of named parts
>the
contain in them. anyone either a) know how to rewrite this
>for version
< 4.1 or b) make it faster.
SELECT l.listID, COUNT(*) AS Occurrences
FROM componentsToLists AS l
INNER JOIN components AS c ON l.componentID=c.ID
I managed to figure out a query that does what I want.
SELECT listID, COUNT(*) AS Occurrences
FROM componentsToLists
WHERE componentID = ANY(
SELECT components.id
FROM components
WHERE componen
I've heard absolutely wonderful things about this transaction-safe storage
engine. We're using InnoDB now and are always looking for the best solution
as we scale our DB operations.
Has anyone tried the SolidDB for MySQL beta stuff yet?
What do you think of it?
Cory.
Omnipilot, the makers of the LASSO application server now offer a free
developer version of lasso professional. It has the best web-based database
browser and SQL utility that I've ever seen. It has native MySQL connectors,
it's a snap to get up and running.
Cory
Scott Baker <[EMAIL PROTECT
I still get the same error. Not sure what I'm doing wrong.
On 8/25/06 5:49 PM, "Greg Joss" <[EMAIL PROTECTED]> wrote:
> Go to Control Panel>System>Advanced. Click Environmental Variables and Find
> the PATH variable under System Variables and add the full path, i.e.
> c:\Program Files\...\my
Go to Control Panel>System>Advanced. Click Environmental Variables and Find
the PATH variable under System Variables and add the full path, i.e.
c:\Program Files\...\mysql\bin to the variable.
-Original Message-
From: David Lazo [mailto:[EMAIL PROTECTED]
Sent: Friday, August 25, 2006 2:54
On 8/25/06, David Lazo <[EMAIL PROTECTED]> wrote:
I didn't add it anywhere because the file exists in mysql/bin folder
c:/program files/mysql/bin
Does it need to be somewhere else??
mm.. i don't know, you tell us !!! try it. !!!
--
http://www.obed.org.mx ---> blog
--
MySQL General Mailing
I didn't add it anywhere because the file exists in mysql/bin folder
c:/program files/mysql/bin
Does it need to be somewhere else??
On 8/25/06 5:03 PM, "João Cândido de Souza Neto"
<[EMAIL PROTECTED]> wrote:
> It could seems stupid, but you tried to put this file on c:\windows\system32
> or th
hi brent
here's what i'm playing around with...
i'm writing a very limited web parsing/scraping app... rather than do a
sequential process, that's time consuming.. i'ver created/tested a kind of
parallel app that quickly spawns a child app for each url i need to fetch.
this can quickly genera
It could seems stupid, but you tried to put this file on c:\windows\system32
or the similar folder of your system?
"David Lazo" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
> I'm having problems with MySQLInstanceConfig.exe - Unable To Locate
> Component
>
> This application
A couple of comments:
- Simultaneous connections can be increased, but at some point the user
than runs the mysqld process will run out of file handles it can allocate
(each table takes 2 or 3).
- If we are talking about a database server and test server being the same
box then what are you trying
I'm having problems with MySQLInstanceConfig.exe - Unable To Locate
Component
This application has failed to start because LIBMYSQL.dll was not found.
Re-installing the application may fix this problem
I have tried to re-install, but I get the same message.
I read the following related thread
Just getting that number of processes running I think would be a challenge. A setup I recently worked on runs a few hundred
processes per box, and that kind of maxes out the CPU.
Approach 1, been there, done that. Too messy.
Approach 2, considered it, but you may end up with processes that neve
You don´t like phpmyadmin?
"Scott Baker" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
> What's the best MySQL client for Linux? I'm using FC5 and only
> yesterday did the MySQL Query Browser start working on FC5. Before
> that I've been using the *OLD* mysqlcc which works, but
What's the best MySQL client for Linux? I'm using FC5 and only
yesterday did the MySQL Query Browser start working on FC5. Before
that I've been using the *OLD* mysqlcc which works, but is lacking
some features. I think the QB is a more polished product, but is
lacking some featuers of the older my
Hello,
Although I can't speak to the timing of the newsletter getting sent out.
A list of upcoming webinars can be found at:
http://www.mysql.com/news-and-events/web-seminars/
Feel free to respond to me privately any suggestions for future topics of
interest and we'll try to make them happen.
T
hi...
i'm trying to determine which is the better way/approach to go. should an
app do a great deal of file i/o, or should it do a great deal of read/writes
to a mysql db...
my test app will create a number of spawned child processes, 1000's of
simultaneous processes, and each child process will
Why is it that the Newsletter goes out after the Web Seminar's have already
occurred. There have been several that I would have liked to see, but I got
the news letter a day after the event occurred. It would be nice to know at
least a day ahead of time when these things are going to happen.
Just noticed that you said partitions. I am assuming that you meat
multiple drives in a raid array.
Bill
David Lazo said:
> Thanx again.
>
> For the time being, we will keep 4 drives with Dan's suggestion. OS and
> MySQL running from there.
>
>
>
> On 8/25/06 11:03 AM, "Dan Buettner" <[EMAIL PR
Thanx again.
For the time being, we will keep 4 drives with Dan's suggestion. OS and
MySQL running from there.
On 8/25/06 11:03 AM, "Dan Buettner" <[EMAIL PROTECTED]> wrote:
> James, with just 4 drives, you can set up one big RAID 10 disk
> (usually called a "logical disk", with Dell PERCs I
Who knew this list had so many funny people. And I came here for the
serious folks. Take me off this list! ;)
Thanks for all the help peoples
-Original Message-
From: Chris Knipe [mailto:[EMAIL PROTECTED]
Sent: Friday, August 25, 2006 10:46 AM
To: mysql@lists.mysql.com
Subject: Re: Te
Only thing I could guess is that at some point in your code you are executing:
INSERT INTO a VALUES ("NOW()")
instead, which for me on 5.0.21 results in -00-00 00:00:00
Perhaps you have a function in your code that automatically
quotes/escapes data prior to inserting or updating... that wou
Chris Knipe wrote:
Doh.. Wrong email ;)
INSERT INTO a VALUES (NOW()) ?
Sorry, it was not for you, I wanted Jeremiah's query... replied the
wrong mail... my fault! ;)
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
Sorry, I think I had James and David backwards there!
On 8/25/06, Dan Buettner <[EMAIL PROTECTED]> wrote:
James, with just 4 drives, you can set up one big RAID 10 disk
(usually called a "logical disk", with Dell PERCs I think it's a
"container"), and then partition it for your different needs.
James, with just 4 drives, you can set up one big RAID 10 disk
(usually called a "logical disk", with Dell PERCs I think it's a
"container"), and then partition it for your different needs.
If you have 4 73 GB disks, you probably have around 135 GB formatted
capacity with RAID 10; I'd do somethin
Doh.. Wrong email ;)
INSERT INTO a VALUES (NOW()) ?
Regards,
Chris.
- Original Message -
From: "Renato Golin" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>;
Sent: Friday, August 25, 2006 4:30 PM
Subject: Re: MySQL NOW() function producing -00-
INSERT INTO a VALUES (NOW()) ?
Regards,
Chris.
- Original Message -
From: "Renato Golin" <[EMAIL PROTECTED]>
To: "Nicholas Vettese" <[EMAIL PROTECTED]>
Cc:
Sent: Friday, August 25, 2006 4:31 PM
Subject: Re: Testing Email
Nicholas Vettese wrote:
I have been having problems with my
Nicholas Vettese wrote:
I have been having problems with my email, and I wanted to test to this
list.
Will let you know when I receive it...
--renato
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Chris Knipe wrote:
After patiently injecting at about 400 queries per seconds, a couple of
hours later, I had about 5 million records in a table. Not a single one
of them experienced the above
It's one every 5 million and 1 entries... try again ;)
Also, maybe (very improbable) it can be
I have been having problems with my email, and I wanted to test to this
list.
Thanks,
nick
David Lazo wrote:
I'm sorry to bother you again with this.
So we have the server but we have 4 Drives and now that I'm trying to set up
the RAID10 I'm starting to think I needed 5 Drives one for the OS?.
Please advise.
David.
We built one pretty close to this recently. You definitely
We are using an NOW() function in our database and occasionally it
produces odd results. There are entries where it states: -00-00
00:00:00 instead of the current time. Is this a bug, or are we using the
function incorrectly?
After patiently injecting at about 400 queries per seconds, a coup
Hi Adrian,
On 8/25/06, Adrian Greeman <[EMAIL PROTECTED]> wrote:
"The security settings could not be applied to the database because the ..
I am pasting here the text of one of my earlier posts to this list:
I got MySQL 5.0.22 running successful
Jeremiah Foster wrote:
Hello all,
We are using an NOW() function in our database and occasionally it
produces odd results. There are entries where it states: -00-00
00:00:00 instead of the current time. Is this a bug, or are we using the
function incorrectly?
MySQL version info:
mysql Ver
Hello all,
We are using an NOW() function in our database and occasionally it
produces odd results. There are entries where it states: -00-00
00:00:00 instead of the current time. Is this a bug, or are we using the
function incorrectly?
MySQL version info:
mysql Ver 12.22 Distrib 4.0.26, for
35 matches
Mail list logo
