.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 takes about 41mb!! :( Can anyone point me to resources on optimizing mySQL's memory usage under a moderate/heavy load? Thanks Jon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 episode (Oct 07), Jon Shoberg said: 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 takes about 41mb!! :( Can anyone point me to resources on optimizing mySQL's memory usage under a moderate/heavy load? Threads have no memory. You're getting misled by Linuxes threads implementation, which displays each thread as if it were a separate process. They actually share the same block of memory, which is why they're threads and not processes. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 giving its full text indexing a good workout. From a hardware standpoint I'll probably use a raid setup of a few hundred GB. IDE storage space is getting cheaper now days. I'm mostly concerned about file system limitations from the OS angle and mySQL's table size limitations and how everything comes together in one system This is primarily a research interest, nothing major. Any thoughts or comments would certainly be appreciated. Thanks jon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I have a table such as IDpath_idword ID is the primary key unqigned int path_id is a foreign key unsigned int word is a single word of text varchar (32) How can I set up the table such that all -pairs- of PATH_ID and WORD are unique? The table should look like the following 12jim 23tom 32joe 47jack but if I try an insert '2' and 'jim' again, the statement fails. Any thoughts? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I have a table such as IDpath_idword ID is the primary key unqigned int path_id is a foreign key unsigned int word is a single word of text varchar (32) How can I set up the table such that all -pairs- of PATH_ID and WORD are unique? The table should look like the following 12jim 23tom 32joe 47jack but if I try an insert '2' and 'jim' again, the statement fails. Any thoughts? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 one column? Example_tbl id bid max_bid 1 .2 .4 2 .1 .2 3 .4 .0 4 .4 .7 5 .7 .7 Selecting the id and creating X_BID in the query result which is the combined bid columns, ordering by the BID and MAX_BID Result_Set ID X_BID 5 .7 4 .7 3 .4 1 .4 2 .2 Make any sense ? Any thoughts on the AS and ORDER BY for this ? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
. 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 bump my db connection higher? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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/filter such that I can choose the prefix and the number of / in the results? Example: How can I query/filter the list such that I am looking for all Top/World/ matches that have only one more word after them. So my only results from the example about would be Top/World/America and Top/World/Japan. Then I would do the same for Top/World/Japan and get Top/World/Japan/Economy and then Top/World/Japan/Food. This is part of the program so I can count the number of / in the query/filter string. I jsut want to exclude the extra matches. Any thoughts? Thanks Jon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Regexp Help !!!
Thanks ! Glad I asked for some other thoughts on this. I totally over looked this and given how my indexes are setup, this will work much better. Thanks again, Jon -Original Message- From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 11:26 AM 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 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/filter such that I can choose the prefix and the number of / in the results? Example: How can I query/filter the list such that I am looking for all Top/World/ matches that have only one more word after them. So my only results from the example about would be Top/World/America and Top/World/Japan. Then I would do the same for Top/World/Japan and get Top/World/Japan/Economy and then Top/World/Japan/Food. This is part of the program so I can count the number of / in the query/filter string. I jsut want to exclude the extra matches. Any thoughts? Thanks Jon Not sure I would do it using regexps. Unless I misunderstand what you're trying to do, I would consider using LIKE as this will often be much faster: SELECT ... WHERE data LIKE TOP/World/Japan/% AND data NOT LIKE TOP/World/Japan/%/% - in essence: select all those records which start with TOP/World/Japan/, then subtract those which contain any further /. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 with 256mb, any guesses how long indexing will take? Its pupose could guiding search functionality on a website. Any comments/suggestions on using FULLTEXT ? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php