Re: Possible to delay index writes until server is less busy?

Write to a memory table first then do a hotcopy on a scheduled basis. - Original Message - From: "Mathias" <[EMAIL PROTECTED]> To: Sent: Thursday, June 30, 2005 9:10 AM Subject: Possible to delay index writes until server is less busy? We've been benchmarking a database that in real

RE: What is best open-source platform alternative to overcome innodb 2Gb memory limit on Linux? FreeBSD?

speed. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.prnewsnow.com Free content for your website 469 228 2183 -Original Message- From: David Griffiths [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 15, 2005 11:17 AM To: Brady Brown Cc: mysql@lists.m

RE: Dual Opteron, linux kernels, 64 bit, mysql 4.1, InnoDB

thing in my current Raid 5 server is still waiting for the disks to read. That is what prompted me to think bigger processors, more ram and faster motherboard to compensate for using a Raid 3 to overcome the slowest hardware in my server. Thanks Donny Lairson President 29 GunMuse Lane P.O. bo

RE: Can I use LIKE this way?

ll implement this on http://www.sharedfeed.com for it opening day release next week. By avoiding talking to the hard drive cleaning up content on the fly is a snap. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -Origin

Can I use LIKE this way?

t know if that meant for the use of %_$dbad_% or if % $dbad % would have it looking for second position stuff.   ThanksDonny LairsonPresident29 GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183

RE: Get a Random Row on a HUGE db

This difference between using a 40 mb table and 4mb table with the same traffic was a 70 server load versus a .9 server load. So it was the amount of data that I was selecting that was choking this feature. - [EMAIL PROTECTED] wrote: >Thanks for that I implemented to my Random code. Same

RE: Get a Random Row on a HUGE db

out it, so no one row comes up every time or more often that others. Gunmuse, SELECT from firebase_content LAST_INSERT_ID() In that cmd, 'from ...' ain't right. I didn't understand either what's wrong with ORDER BY RAND() LIMIT 1. Also check the Perl manual for

RE: Get a Random Row on a HUGE db

Thanks for that I implemented to my Random code. Same problem that select * portion is just a nightmare. Remember I selecting 38mb of data when I do that. What I want to do is jump to a Valid random row. Now If I didn't delete content often that would be easy grab the last autoincremented row_i

Get a Random Row on a HUGE db

1, maxRow.maxID);randomRow = query("SELECT * FROM $table WHERE $column = $randomID");} while (randomRow.recordCount == 0); return randomRow;}*/?> ThanksDonny LairsonPresident29 GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183

RE: zip code search within x miles

distance calculation would help better understand this problem. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -Original Message- From: Richard Lynch [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 12:05 AM To

RE: Client Side Query cache

racts the low life's of the internet world. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -Original Message- From: Mister Jack [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 4:49 AM To: mysql@lists.mysql

RE: Relative Numeric Values

ex jumping call. Find * where 2 letter index equals 'ab' and 3 letter index equals 'abcd' I am sure there will be a better way to write that because at that time I am certain abcd may reside on different servers. Thanks Donny Lairson President 29 GunMuse Lane

RE: zip code search within x miles

I have a copy of the Zip Code db for MySql. Its a few years old but should be 99% accurate compared to new ones. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -Original Message- From: Scott Gifford [mailto:[EMAIL

RE: zip code search within x miles

in coming out in functions, and Perl already has some functions to do this I believe you just need the db. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -Original Message- From: Scott Haneda [mailto:[EMAIL PROTECTED] Se

FW: GWAVA Sender Notification (Spam)

This is what I call WAY OVER REACTING.   This member turned my email into the spam report immediately without thinking.  Now I am recieving these. ThanksDonny LairsonPresident29 GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183 -Original Message-From

RE: mysql_query Looping

basesoftware.com/firebase_downloads/firebase2.0_client_linux. zip http://www.firebasesoftware.com/firebase_downloads/firebase2.0_client_window s.zip Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -Original Message- From:

RE: Boolean searches

MY first post had html in it where I posted my indexin that I am using. URL UNIQUE 5451 URL expiresFlag INDEX 1 expiresFlag title FULLTEXT 1 title keywords body_1 FULLTEXT 1 body_1 body_2 Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM

RE: WARNING!!!! abuser on this list?

URL UNIQUE 5451 URL expiresFlag INDEX 1 expiresFlag title FULLTEXT 1 title keywords body_1 FULLTEXT 1 body_1 body_2 Whoops on the html copy, calm down there guy. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com

Boolean searches

1  body_1 body_2     Maybe his PHP is querying the database wrongly or is out of date.  I am running 4.1.8 Mysql What would be a good example on how to query the db for bring back ranked results based on what it found? ThanksDonny LairsonPresident29 GunMuse

RE: Performance Tuning - Table Joins

Your not indexing properly this should be a blink of a search. Or your looping your loops when you search. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent

RE: license question

rather use MySql an pay them the same rates MySql refused. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -Original Message- From: Daevid Vincent [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 30, 2005 10:18 PM To: 

RE: Slow access Apache + PHP + MySQL

g ram and 64bit servers. More along the line of a nice high-performance PIII. So be careful what you read. Learn the math to do it right and not the exampled settings you see in forums. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228

RE: Heap table says its Full?

Ok, Never mind my last statement because I didn't change anything and it worked this morning. Next problem I copied a 21MB db to the heap and it reported 248M of data once there? Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228

RE: Heap table says its Full?

I took a guess at that yesterday. I left the tmp_table_size 128M added the line max_heap_table_size 500M But to no avale. Still limited in the number to 12.7M I am using 4.1.8 as installed by Cpanel. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http

Heap table says its Fuul?

archReferrer` varchar(100) NOT NULL default '',  `searchIp` varchar(15) NOT NULL default '',  KEY `searchAffid` (`searchAffid`),  KEY `searchKeyword` (`searchKeyword`)) ENGINE=MEMORY DEFAULT Select * from fsearch_search;       ThanksDonny LairsonPresident29

RE: Auto loading a table

respectful 4 days. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -Original Message- From: sol beach [mailto:[EMAIL PROTECTED] Sent: Sunday, March 13, 2005 3:11 PM To: [EMAIL PROTECTED] Subject: Re: Auto loading a table With

RE: Auto loading a table

memory tables anyway. Should I add something into the creation of the table to override the defaults locally with that table? Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -Original Message- From: Michael Stassen [mailto

RE: Auto loading a table

lt '0', `fsearchClicked` varchar( 6 ) NOT NULL default 'no', PRIMARY KEY ( `fsearchId` ) , KEY `fsearchIp` ( `fsearchIp` ) ) ENGINE = MEMORY LOAD FROM TEST2 DEFAULT CHARSET = utf8 AUTO_INCREMENT =0 Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183

Auto loading a table

;,PRIMARY KEY ( `fsearchId` ) ,KEY `fsearchIp` ( `fsearchIp` ) ) ENGINE = MEMORY LOAD FROM TEST2 DEFAULT CHARSET = utf8 AUTO_INCREMENT =0 ThanksDonny LairsonPresident29 GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183

Loading data on startup

LairsonPresident29 GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183

RE: Yeah worked liked a dream

Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 3:17 PM To: Mysql Subject: Memory Tables and My.cnf

RE: Memory Tables and My.cnf config may not be right

cache_size = 32M query_cache_type = 0 skip-innodb thread_concurrency = 8 safe-show-database interactive_timeout= 15 tmp_table_size = 12800 Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183

Delete without Overhead on a MEMORY.

We are getting lots of Overhead in our MEMORY table when we delete rows that are to old.  So How do we delete from the table an not consumer MEMORY that we want later? ThanksDonny LairsonPresident29 GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183

Memory Tables and My.cnf config may not be right

-show-databaseinteractive_timeout= 15tmp_table_size = 12800 ThanksDonny LairsonPresident29 GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183

Is there a limit on Auto-increment

I am using the memory table in 4.1 to auto increment is there a limit to how big that number can get? ThanksDonny LairsonPresident29 GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183

Memory table questions

automatically.  That is actually part of the table build itself right? what does that SQL look like? ThanksDonny LairsonPresident29 GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183

Timed truncate of a table.

I am building a temporary memory table to store links in. Instead of having php truncating all links older than 10 minutes is there just a way to have the table do itself automatically? ThanksDonny LairsonPresident29 GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228

RE: Lots of searches

President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Friday, February 18, 2005 1:41 PM To: [EMAIL PROTECTED] Cc: Mysql Subject: Re: Lots of searches There's nothing you c

Lots of searches

uld return me those 5 phrases since the pattern gun is in the phrase.   My question is what is the best way to setup the db to make this search as fast as possible.  Right now its taking 45-50 seconds and I would like to get it down to 4-5 seconds. ThanksDonny LairsonPresident29 GunMuse La

A Heartfelt thank you.

very helpful and I am sure we finally update our server to 4.1.8 we will be back with a boat load of questions. I know we are interested the sub search functionality of the new MySql. Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183

RE: Import Excel data into table

NaviCat Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183 -Original Message- From: Steve Grosz [mailto:[EMAIL PROTECTED] Sent: Thursday, January 13, 2005 2:56 PM To: mysql@lists.mysql.com Subject: Import Excel data into

Pear abstraction class

tware. ThanksDonny LairsonPresident29 GunMuse LaneP.O. box 166Lakewood NM 88254http://www.gunmuse.com469 228 2183

Heap Help

I want to put a table in Ram (HEAP) with a field of at least 500 characters.  I do I do this if Blob and text are not allowed? ThanksDonny LairsonPresidenthttp://www.gunmuse.com469 228 2183

RE: Take a normal Table and Make it a Heap table

Can I put a MyISAM table into Ram permanently? Thanks Donny Lairson President http://www.gunmuse.com 469 228 2183 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 26, 2004 11:59 AM To: sol beach Cc: Mysql Subject: RE: Take a normal Table and M

RE: Take a normal Table and Make it a Heap table

I ran this and got the following error. Why doesn't heap support autoincrement? Or does it and I need to do something different. CREATE TABLE `xmllinks2` ( `rowID` int(11) NOT NULL auto_increment, `affiliateID` int(11) NOT NULL default '0', `pluginName` varchar(255) NOT NULL default '',

RE: Take a normal Table and Make it a Heap table

I agree and we are rewriting this application ourselves to accomidate these types of issues of making it faster faster faster. But I would like to "patch what I have" at the same time. Call me greedy Thanks Donny Lairson President http://www.gunmuse.com 469 228 2183 -Original Message-

Take a normal Table and Make it a Heap table

I have to pull in 200 search rows and store them temporarily in a Table called xmllinks  This is so I can track the click on the one link of the 200 I bring down.  Nothing is permanently stored in this table   This is just a normal table in a db right now but during peak traffic times it bog

Complete php,mysql packages

Wamp servers are an excellent windows install for It elimininates those little hiccups http://www.wampserver.com/en/index.php Thanks Donny Lairson President http://www.gunmuse.com 469 228 2183 -Original Message- From: Danesh Daroui [mailto:[EMAIL PROTECTED] Sent: Wednesday, November

RE: On but off topic Putting a file in Ram

Thank you that is exactly what we are looking for. Now we know we will need to build a 2 db system a dynamic db and a static db to get the best performance from our search. Thanks this will greatly decrease our need to rewrite our software later as the system grows. Thanks Donny Lairson Presiden

RE: On but off topic Putting a file in Ram

Heap/Memory tables that is the phrase I couldn't remember. The data is stored in the file system. I have one file that that is linked to via JavaScript to run a php file and send an output. That file accesses MySql OR if I am overloaded it bypasses my local system and goes directly to Findwhat.

RE: On but off topic Putting a file in Ram

Actually no. I have a file that is determined to be requested by mysql (Top 100 site) What I am wanting to do is put the images and or files into Ram to serve them from there instead of the harddrive and conserve hd resources for "not known" tasks. Thanks Donny Lairson President http://www.gunmu

Thread concurrency

Just out of curiosity I recently turned this up from a 4 to a 16 to see what would choke.  Nothing did.  Matter of fact it seems like my load went down quite a bit.   Is there something wrong with leaving it this way? Since it should be really simple tasks on Xeon processors shouldn't it be

On but off topic Putting a file in Ram

I have a small file that calls a search function at Findwhat in case Mysql locally overloads. I just put on a new partner who looks like they may call my server 40 million times a month. I know there is some way to put a file into Ram for super fast response. Question is how do I do this? Will i

How do you do the math

I see guys talk about doing the math to determine how many apache servers you need.  How much ram you have or have left.   My question is how do you determine how much your MySql can handle?   I am running a dell dual 2.8 with 2 gig of ram  Raid 5    Whats the max connections MySql can han

RE: newbie: relationships between fields

NaviCat search for it on google it will make your life much easier. Thanks Donny Lairson President http://www.gunmuse.com 469 228 2183 -Original Message- From: Amer Neely [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 1:43 PM To: MySQL Cc: Christian Kavanagh Subject: Re: new

RE: DBManager 3.0

Nice interface, but its crippleware. Anything that may be of use is locked out from testing exactly what they would tell me. I tried to run reports. Need to purchase. Tried to diagram but not sure what that did for me other than tell me what tables I already had. could see some benefit for buil

4.1.8

Does 4.1.8 address any of the issues I am reading about in 4.1.7? Are all of these issues valid or are you finding that its Lazy coding? Thanks Donny Lairson President http://www.gunmuse.com 469 228 2183 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubsc

UTF-8 compliance

What does this all entail?   Can we use Under_Scores in table names. ThanksDonny LairsonPresidenthttp://www.gunmuse.com469 228 2183

XML to Mysql

This may just sound stupid but I am going to ask anyway.   We run a search engine and we bring in 3+ XML feeds from other search engines  Via perl and PHP.   So we can end up with 300 results listed for EACH SEARCH.  They are only valid for that ONE SEARCH but we need to track every click f

Temporary Upgrade for Cpanel?

I read on the Cpanel.net forum that you can start the 4.0.22 mysql with a --new switch to use it as 4.1.7 so you can see if its compatible with my software.   Is this true and exactly how? ThanksDonny LairsonPresidenthttp://www.gunmuse.com469 228 2183