conflict in mysql manual for log files. buffer pool in innodb

There is seemingly conflicting advice in the mysql manual in regards to log file sizes and buffer pool sizes for inndob I only mention this because tweaking Innodb values and getting the best performance with inndob isn't easy because the mysql daemon has to be stopped, the log files deleted, ne

Innodb won't recognize index when optimizing query

Matt, Thank you for the help and you are correct the index can't be utilized when using !=. I will try your hack/work around. Thanks again. sql,query >Hi Heath, > >MySQL cannot use the trans_team query because you're using !=, for which >an index is never used (currently anyway). Do you think

Innodb won't recognize index when optimizing query

The query optimizer will not recognize an index on an innodb table. tranfer_logs is an innodb table, auth_user is not. As demonstrated below, trans_team is not even recognized as a possible key when EXPLAIN SELECT is used. (my apologies for the extra wide message). I am not sure if this is an i

RE: Thread Thrashing and 3.23.53a

After a weekend of pretty heavy usuage (150-200 queries per sec) I can say the "thread thrashing" has been fixed with the latest binary. Our load averages however, are still 2-3x what they were with the older binary. Even when mysql isn't being queried at all (when apache is shut down) the load a

Re: Thread Thrashing and 3.23.53a

Aren't these just aborted clients? When you upgraded before did mysql bring the server to its knees or just yield many aborted clients/connects? Any idea what your show processlist looks like when this is happening? Before mine was flooded with a ton of processes like this: | 17546 | root| loca

Re: Thread Thrashing and 3.23.53a

>Heath, I once had similar symptoms when my DNS resolving had problems >and all new connections "slept" for some seconds while they were >waiting for an response. My work-around was to use --skip-name-resolve >until the DNS problem was solved. Benjamin, Thanks for the suggestion but the connectio

Re: Thread Thrashing and 3.23.53a

ens? If at all. > > - Mark > > System Administrator Asarian-host.org > > --- > "If you were supposed to understand it, > we wouldn't call it code." - FedEx > > > - Original Message - > From: "heath boutwell" <[EMAIL PROTECTED]>

Re: Re: Thread Thrashing and 3.23.53a

> > MYTOP reports key eff at 98.30% > > +--+---+ > | Variable_name| Value | > +--+---+ > | Aborted_clients | 58| > | Aborted_connects | 6 | > | Bytes_received | 281234326 | >

Re: Thread Thrashing and 3.23.53a

--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > Can you post the output of SHOW VARIABLES? | +-+ | back_log| 50

Re: Thread Thrashing and 3.23.53a

> --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: >You're disk-bound, not CPU bound. Notice all the idle CPU time? And >the fact that the "b" column always has one process listed, while "r" >only does once in a while. 2 gigs of ram -- don't really know why we'd be disk bound. The my.cnf is pretty

Re: Thread Thrashing and 3.23.53a

--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > I've read others who've said it fixed the problem > for them. Did you > check the archives? Jeremy, Thanks for mytop. Its a great tool and its been a great help in diagnosing our problems. I saw where a few of the others claimed the latest binari

Thread Thrashing and 3.23.53a

Can anyone that was experiencing the thread thrashing problems with the other binaries confirm that this has been with resolved with 53a? I have installed the new binaries and will report what is observed here after periods of heavy load. Others on the list experienced the same occurances. Previ

strange processlist

Thanks to Jeremy Zawodny for his great tool, I was able to capture this during a server meltdown at the hands of an upraded MySQL binary (From 3.23.32 to 3.23.52). My story is a famliar one -- a db (MyISAM tables) that ran fine for 3 years all of sudden brings our cpu to a halt with an upgraded

Creating indexes on large tables -- tmp directory is full

Is there a way to change the directory used when mySQL copies the table for creating indexes on large tables? My tmp directory is partitioned for 509 megs and adding an index via ATLER TABLE or CREATE TABLE yields this: ERROR 3: Error writing file '/tmp/STFgNG04' (Errcode: 28) the .MYI file isn

Re: the quick and the dead...

Thanks for the information below. Also, according to the article here: http://www.webtechniques.com/archives/2001/05/hong/ The wildly popular amihotornot.com has served over 17.5 million page views in one month using mySQL exclusively. I don't know how extensively Yahoo Finance uses mySQL in th

the quick and the dead...

Since mySQL is one the fastest RDBMS in the world for pure SELECTs, this seems like the proper forum to pose the following: According to a recent story: http://news.cnet.com/news/0-1005-200-5561996.html?tag=tp_pr 35 Million keyword searches a day are done at the Goolge site. My calculator tell

Re: About reserved words: mySQL's dirty little secret

I guess my command of the english language isn't too great. I never realized that this quote from the manual: "You're allowed to do it (for example, ABS is an allowed column name), but whitespace is not allowed between a function name and the `(' when using functions whose names are also column

About reserved words: mySQL's dirty little secret

Evidently, one can use the ` to escape reserved words in mySQL. Why in the world this isn't mentioned in the manual is beyond me. Why no one on the list ever mentions it when some poor sap discovers that some random word has been made reserved for no reason is beyond me Why the mySQL developers