key_buffer, performance issues and considerations.

Folks, A few months ago, I came here asking for directions on how I could improve performance of MySQL. Back then, I was using OpenBSD on a dual Opteron 248 with 2GB, LSI MegaRAID 320-1, 15k RPM SCSI discs, MySQL was (still is) 4.0.27, the database is MyISAM, reaching 50GB. After some

Quick Linux/MySQL performance questions.

Folks, I had some recommendations about operating system last time I posted, and decided to follow it. It's been a couple of weeks running Gentoo Linux 2006.0 SMP 2.6.15-gentoo-r5, with glibc 2.4 (NPTL), gcc 3.4.4, XFS as my FS, deadline scheduler and this has proven to be really stable --

Re: Quick Linux/MySQL performance questions.

Buettner, First of all, thanks a lot for your reply! This server has 4 disks to MySQL usage, in two pairs of RAID-1, connected to a single channel (ok, I realize now this means a bottleneck) LSI PCIe card. One RAID1 for MySQL logging and temp space, and the other pair for the database

Re: Quick Linux/MySQL performance questions. (fwd)

1) Is there a way to see MySQL using both processors? Is SMP helpful in this case? (This server is dedicated to MySQL, only one instance). PS (*nix) should tell you how your processors are used. PS does show me about the CPU usage, but it doesnt tell me which processor, or if they're being

Linux+AMD64+MySQL.

Folks, I'm used to run MySQL (4.0) with OpenBSD (3.7). Now I've decided to give Linux a shot, to see if I could gain some serious performance. The server I'm using is a dual Opteron 246, with 2GB RAM, LSI MegaRAID 320. CentOS 4.1 x86_64 seems to be a good OS. Although I thought that the

Myisamchk on really large tables.

Folks, We are going through a nasty problem, and I hope you guys can help me out. We are running a couple of MySQL 4.0.25 at 2 OpenBSD Opteron (246, 2GB RAM, 36GB RAID-1 15K), and for backup purposes, 1 Linux CentOS 4.0 Pentium 4 (3GHz, 1GB RAM, 80GB SATA 10K). They are all connected through

Slave integrity.

thoughts on this? Thanks a lot! Best regards, RV Tec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL TMPDIR.

if the primary runs dry? Thanks a lot, RV Tec [1] = http://dev.mysql.com/doc/mysql/en/Temporary_files.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL TMPDIR.

Clark, MySQL will stop processing the current query until space becomes available. It will then continue. Stop processing the current query means locking it all, and everything else has to wait for this query to be completed?! Thanks for your reply! Best regards, RV Tec -- MySQL General

TMPDIR on a 4.0.20.

help me: 1) How do I know, how much space am I using at the TMPDIR (when it is used, that is)? 2) What would happen in case of space starvation? Is that likely to cause a MySQL crash? Or it would just abort the resource-eater query? Thanks a lot! Best regards, RV Tec -- MySQL General

Re: MySQL Benchmark. OT and beyond...

5.2.1 with pthreads, but they weren't that different from LinuxThreads. As I write this e-mail, I'm configuring a Linux (Debian) box, later on I'll share those results. Best regards, RV Tec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

MySQL Benchmark.

, RV Tec Quick results: OpenBSD 3.5 super-smack -d mysql select-key.smack 50 10 Query Barrel Report for client smacker1 connect: max=53ms min=33ms avg= 43ms from 50 clients Query_type num_queries max_timemin_timeq_per_s select_index100043 7

Re: MySQL Benchmark.

perform much better than OpenBSD. I am going to compile MySQL with pthread on FreeBSD. This way I can truly compare those OS's. Linux is going to be my next test. Best regards, RV Tec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: MySQL Benchmark. OT and beyond...

million rows/month). Heck, if it was up to me, I would still be using Linux 0.99q on 386SX. Take care, RV Tec PS: There's no need to CC my address. I'm subscribed to the list. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: MySQL Benchmark. OT and beyond...

Err... I guess I owe Jeremy Zawodny an apology for mistyping his name. I promise next time I won't type without reading. His site is at http://jeremy.zawodny.com/. And I really recommend his book High Performance MySQL. Sorry for the typo, Zawodny! RV Tec -- MySQL General Mailing List

MySQL limits.

for your help! Best regards, RV Tec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL limits.

Folks, Tim, Oops! Forgot to mention that... we are running MySQL 4.0.18. Thanks a lot! Best regards, RV Tec On Tue, 18 May 2004, Tim Cutts wrote: On 18 May 2004, at 2:28 pm, RV Tec wrote: Is MySQL able to handle such load with no problems/turbulences at all? If so, what would