I have a small PHP website that gets a fair amount of traffic. It's a
simple layout with two tables. I average about 50 concurrently open
apache sessions and 40 open mysql connections. I am calling for
persistent connections from the mySQL/PHP API.
But here is the kicker. Each mySQL thread
Ok,
So how do I optimize memory usage? Where to start ?
-Jon
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 9:16 PM
To: Jon Shoberg
Cc: [EMAIL PROTECTED]
Subject: Re: .Optimize mySQL memory usage ? 41MB threads ??
In the last
Any suggestions on replicating data from DB2 files to a mysql database
across a network? Is it possible to link a mysql table like to a portion of
the DB2 data/tables then hotcopy is across the network to the remote
database?
Thanks
Jon
myODBC and MS Access will let you link (live) to a mysql database. Is there
a way to get the mysql linux client to link to another database system?
Could mysql create a live view of data from a as400/DB2 table ? Using odbc I
presume ?
Thanks
Any suggestions on how to pull off the following ...
I'd like to setup a box to function primarily as a database server.
Secondary functions will be running some java applications, basic apache web
server. My intent is to use mySQL as the db behind a small web search
engine. I'll certainly be
HUH ?
Oh well lets try again, please read below ...
SQL = SELECT help FROM mysql.list WHERE spam NOT LIKE 'bounce%'
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your
HUH ?
Oh well lets try again, please read below ...
SQL = SELECT help FROM mysql.list WHERE spam NOT LIKE 'bounce%'
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your
Ok,
I am setting up a small bidding system. I have a table with one column for
BID and the other for MAX_BID with each row having a unique id number.
Anyone have a simple query example where I can select ID, BID, MAX_BID and
sort in descending order the BID and MAX_BID as if it were one
Well,
Another app was launched on my mySQL server. Only this one is poorly coded
and heavily used. Is there a way to change the priority of my connection?
My entire app consists of select statements. Once I changed everything to
SELECT HIGH_PRIORITY ..., that helped a ton. Can I bump
Ok,
I have a list/database of words that follows as ...
Top
...
Top/Arts/Food
Top/Arts/Food/Country
...
Top/World/America
Top/World/Japan
Top/World/Japan/Economy
Top/World/Japan/Food
Top/World/Japan/Food/Country
Top/World/Japan/Food/Country/By_Chef
...
How can I setup a regexp
To: Jon Shoberg; Beginners (E-mail)
Cc: *MySQL mail list
Subject: RE: Regexp Help !!!
-Original Message-
From: Jon Shoberg [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 13, 2002 4:47 PM
To: Beginners (E-mail)
Cc: *MySQL mail list; Jon Shoberg
Subject: Regexp Help !!!
Ok
I have a simple table with A LOT of data, 2.1M rows. this is purely a
development/test/learning endeavor.
The table structure is:
ID- auto-increment
url - varchar(255)
topic - varchar(255)
about - tinytext
Anyone use fulltext indexing under this scenario? The DB server is a P3-866
Anyone have a list of major e-commerce companies that use mySQL for
'significant' website and backend functions?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
13 matches
Mail list logo