RE: .Optimize mySQL memory usage ? 41MB threads ??

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

.Optimize mySQL memory usage ? 41MB threads ??

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 ta

linking databases (mysql - db2) ?

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

replicating DB2 to mysql

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

mySQL System config ... jumbo db size

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 g

Spam Filtered - Re: Making Unique Pairs ??

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 you

Spam Filtered - Re: Making Unique Pairs ??

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 you

Order By Query - Simple Help

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

. Priority - mysql_connect() ??

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 bum

RE: Regexp Help !!!

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 > Su

Regexp Help !!!

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 query/fi

Suggestions - FullText ??

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

mySQL and E-Commerce ?

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) http://lists.mysql.com