ANN: MySQL Performance Monitoring

fo on what SPM monitors: http://sematext.com/spm/index.html Happy monitoring! Mick Emmett Sematext Group, Inc. *http://sematext.com/ <http://sematext.com/>*

Re: MySQL tweaking.

for your reply. I have the system load down a fair bit.Was something silly on my behalf. I had mysql logging all queries to disk. serious i/o loads. I have since stopped this and now system is seeing 100qps and only 1% aborted attempts. ( was 20qps and 20% Aborted queries. ) -- Regards Mick

MySQL tweaking.

s Swap: 2008116k total,0k used, 2008116k free, 1533628k cached ----- Regards Mick Pollard ( lunix ) BOFH Excuse of the day: Nonfatal Hardware Timeout Warning -- MySQL General Mailing

Import Query From Access?

Hi I am pretty new to mysql. I am porting an access driven website to mysql. All has gone pretty much to plan bar one final page. This page is basically a listing of duplicate users based on the email field. In the access db I had a predefined query called emailduplicate The site asp page cal

Re: GUI for mySQL

I have to concur, MS Access with ODBC linked tables is not a good solution when those tables contain large amounts of data. I had queries run for hours and then come up with a simple "ODBC Failed" message at the end of it. Maybe Access has improved though. Tod Harter wrote: > Watch out wit

Re: group by help?

You're right, it wasn't the answer I wanted to hear ;-) But it has a ring of truth to it. Thanks for all your help Mick Paul DuBois wrote: > At 13:34 +0100 4/19/02, Mick Watson wrote: > >Thank you :-) > > > >I do realise the SQL is not being used as it

Re: group by help?

make this choice in a consistent manner. A tough task probably, and obviously group by is not the perfect answer, but you can see why the developer made that choice as it does make mySQL make an arbitrary decision... just not a consistent one :-) Thanks Mick Richard Emery wrote: > As a relati

Re: group by help?

ables are that affect this behaviour I could minimise the inconsistancy...? Thanks for your time Mick Richard Emery wrote: > mysql is acting correctly. > > GROUP BY is used to consolidate data for SUMming, COUNTing, etc. Your > SELECT statement makes not such request. You have sim

group by help?

has chosen differently simply because of the presence or absence of the gene_id = 24173 in the create table command I want to try and figure out why mySQL is making these rather inconsistant decisions and see if it's possible to remove thi

MySql "fatal error" in mysql-opt.exe

t Apache running happily with Perl and PHP, and this is going to tip me over the edge...! Thanks in advance, Mick. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/