key_buffer, performance issues and considerations.

erver, I'm using only 37.5% of it to the key_buffer (6144). If I make this larger, will be a performance improvement or a stability killer? 3) Upgrade MySQL 4.0.27 to MySQL 5.0 -- this is going to be painful, but it is already on the way. Thanks a lot! RV -- MySQL General Mailing Lis

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

ive MYD (lotsof indexes). Read the Optimization sections of the mysql docs. More RAM will speed it up also. Thanks. I'll try to bump it up to 4GB to see what happens. Thanks a lot! RV -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

Re: Quick Linux/MySQL performance questions.

, and after I'm sure the hardware/OS is OK, we'll nail this and try to get it better. Best regards, RV On Fri, 12 May 2006, Dan Buettner wrote: Good morning RV - On your 3rd question, about how to make things faster: More RAM should help by allowing the server to keep more/all

Quick Linux/MySQL performance questions.

th (approx) 6GB each. And this can really slow things down with joins. How can I make this perform better? More RAM? The MYI files are almost twice the size of its respective MYD (lotsof indexes). Thanks a lot your help, guys. Best regards, RV -- MySQL General Mailing List For list arch

Linux+AMD64+MySQL.

uys can help: 1) pthreads is safer, but LinuxThreads is way faster? 2) What's the best io scheduler for 20GB MyISAM DB? I'm currently using cfq. 3) Does anyone have any tips on running MySQL+AMD64+Linux? Thanks a lot! Best regards, RV -- MySQL General Mailing List For list archives

Myisamchk on really large tables.

so we can bite memory some more. Only at the very beggining we see a CPU hog (peaking at 95%), but after a few seconds, the CPU use drops to 5%, maybe even less, and we see only HD activity -- and not that much. Is this right?! Any ideas?! Thanks for your time. Best regards, RV PS: Here

Re: Project Management

Hereby: http://www.phprojekt.com/ --> we have used this ourself http://www.dotproject.net more can be found here: http://www.hotscripts.com/PHP/Scripts_and_Programs/Groupware_Tools/index.html Greetings Reinhart Citeren David Ziggy Lubowa <[EMAIL PROTECTED]>: > > Good Afternoon, > > >

Slave integrity.

h tables with read lock). Any 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]

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 TMPDIR.

only 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]

TMPDIR on a 4.0.20.

guys can 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

Re: MySQL Benchmark. OT and beyond...

to see that kind of performance, when the expected was a lot higher. I can't remember if I shared the results with MySQL 4.0.20 running on a FreeBSD 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,

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 M

Re: MySQL Benchmark. OT and beyond...

(50 concurrent connections, 6GB database, increasing by 1 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: ht

Re: MySQL Benchmark.

ough, I thought that FreeBSD would 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.

MySQL Benchmark.

gards, 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

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

MySQL limits.

Thanks a lot 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]