RE: MySQL Cluster / NDB & MyISAM mix

Thanks. Yes it's a delicate construct but tables like 'IP2Location' give me a headache as NDB tables. Yet I have to test if 7.0.X can handle it. -Original Message- From: Michael Dykman [mailto:mdyk...@gmail.com] Sent: Mittwoch, 14. Oktober 2009 17:33 To: Christian Meis

MySQL Cluster / NDB & MyISAM mix

Hi guys. Ok lets say i've 2 server running MySQL, NDB node and NDB manager on each. Now I don't want to convert all tables to NDB instead I leave a few as MyISAM. Is it officially supported if I setup a master-master replication between the two MySQL instances and add ignore entries for all NDB ta

Re: Small InnoDB table with many concurrent queries

ah sorry... there are a few UPDATEs too but most is SELECTs... 60:40 i would say. > Excuse me. But why concurrent queries request table locks? > > 2009/4/20 living liquid | Christian Meisinger > >> Hi there. >> >> I've a small table with my daily banner

Small InnoDB table with many concurrent queries

Hi there. I've a small table with my daily banner hits. 1. version was with myisam but with a lot of concurrent queries (all SELECTs) i get too many table locks. so i changed it to an innodb table. works great most of the time. sometimes it seems to be too much, starting at about 500 concurrent

Re: I don't understand why SCSI is preferred.

> We're using Opterons, Linux 2.6.x, and a SiL (Silicon Image) SATA > chipset whose particular model number I don't have in front of me. > > After MUCH MUCH MUCH trial and error we've discovered that: > 1) 2.6.16 substantially alleviates the problem but doesn't eliminate it. > 2) There is a 3Ware

Re: I don't understand why SCSI is preferred.

> * - For example: We faced a NASTY problem using AMD 64-bit CPUs + SATA + > Linux where I/O on the system (the WHOLE system, not JUST the SATA > spindles -- network, PATA, USB, EVERYTHING) would suddenly come to a > grinding halt (or very nearly halted) randomly when the SATA subsystem > was under

Re: ~Mysql performance~

> Hi, > > I have 2 mysql servers with version 5.0.15-standard-log running on > redhat es4 installed on 2 different geographic locations. The default > storage engine used is innodb on both the servers. I run an insert query > on both the servers that inserts 25,00,000 records. first server takes >

Re: 4.1.16: updates not using index prefixes

Pete Harlan wrote: > FYI, > > 4.1.16 appears not to be using prefixes of compound indexes when doing > updates. Reverting to 4.1.15, or adding an index consisting of only > the desired field, restores reasonable behavior. > > I have added feedback to a possibly-related bug, >

Re: Upgrading to 5.0.15

Gary Richardson wrote: > We moved directly from 4.0.20 to 5.0.16. Worked like a charm. I had a > script that went through and optimized all tables with keys on > text/varchar and char fields. > > We're also slowly ALTERing innodb tables to get them into the new > compact format. i tryed to update

Re: high load average with 4.1.16

>>uploaded it: >> >>http://img394.imageshack.us/img394/4808/topgraphtoday9fp.jpg >>http://img394.imageshack.us/img394/3403/bottomgraphweeks2vf.jpg > > > Nice graphs. What tool do you use to make them? http://www.cacti.net/ on the 'additional scripts' page you get scripts for almost everything t

Re: high load average with 4.1.16

Christian Meisinger wrote: >>i added a jpg of our cacti graph. >>the top graph shows avg load of today. >>and the bottom graphs show 4 weeks back. > > > mh where are my jpgs... i can't post attachments here? uploaded it: http://img394.imageshack.us/img39

Re: high load average with 4.1.16

> i added a jpg of our cacti graph. > the top graph shows avg load of today. > and the bottom graphs show 4 weeks back. mh where are my jpgs... i can't post attachments here? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

high load average with 4.1.16

last week i upated to 4.1.16 and the average load increased. today i switched back to 4.1.15 and the average load decreased immediately. i added a jpg of our cacti graph. the top graph shows avg load of today. and the bottom graphs show 4 weeks back. has anyone else the same problem? what's wrong

Re: Analyzer/Graph for binary logfiles

> What kind of values do you want charted? Have you looked at the binlogs to > see what is available? What you want to chart may not be part of the > actual data so you may want to expand your search to the general log file > as well. If you want database statistics, those are available through

Analyzer/Graph for binary logfiles

Does anyone know a script/program to create statistics or graphs from a binary mysql logfile? A graph view daily, monthly data andsoon would be great. best regards chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Re: How to extract only the first few lines from a longtext field

>>You could use the LEFT() function to return for instance the 200 first >>characters: >> >>SELECT LEFT(article,200) AS start_of_article >> FROM articletable WHERE ... >> >>You could also use the SUBSTRING_INDEX() function, if your lines are >>separated with \r\n: >> >>SELECT SUBSTRING_INDEX(arti

Replication 4.1.11 to 5.0.4beta

if i start to replicate the following table, i get this error: 050503 10:08:35 [ERROR] Key 1 - Found wrong stored record at 0 050503 10:08:35 [Note] Retrying repair of: './plugin_data/renderer' with keycache 050503 10:08:35 [ERROR] Key 1 - Found wrong stored record at 0 what's the problem??? ---

Re: Get a Random Row on a HUGE db

> $last_row ="SELECT from firebase_content LAST_INSERT_ID()"; > $last_row_query = $dbi->query($last_row); > $last_row_result = $row->id; i think LAST_INSERT_ID will not work for what you wonna do. if you open a connection to MySQL and call LAST_INSERT_ID without a INSERT it will return 0. http://