Did you use what version of MySQL.

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #294,815 by folkert 10/18/07 10:49:57 PM Reply	Did you use what version of MySQL. I told you to use 5.1. There are specific enhancements in MySQL in 5.1 And exactly what kinds of setting were you using? If you have lotsa memory... let it use it. If you have drives that blaze... tweak it stop batching/buffering, if you have both... tell it to use more. And if you didn;t try 5.1, you missed much. -- [link\|mailto:greg@gregfolkert.net\|greg], [link\|http://www.iwethey.org/ed_curry\|REMEMBER ED CURRY!] @ *i_wethey* `PGP key: 1024D/B524687C 2003-08-05 Fingerprint: E1D3 E3D7 5850 957E FED0 2B3A ED66 6971 B524 687C Alternate Fingerprint: 09F9 1102 9D74 E35B D841 56C5 6356 88C0 Alternate Fingerprint: 455F E104 22CA 29C4 933F 9505 2B79 2AB2`
Post #294,817 by crazy 10/18/07 11:24:35 PM 10/18/07 11:29:40 PM Reply	No you didn't You said: Try the pre v6 stuff first, its pure gold. and use MySQL v.latest.(stable or devel) or use pre v6 stuff I did V5.0 1st. When I tried 5.1, I got into some lib dependancy issues. It's certainly not in stable, which is a bit scary. If you are telling me there is significant speeds on query, then I'll try again. But if you are referring to all the new whizbang features (and yes, there are LOTS) that I don't care about, then I'll pass. Edited by crazy Oct. 18, 2007, 11:29:40 PM EDT Expand All History
Post #294,818 by crazy 10/18/07 11:35:25 PM Reply	This is the 5.1 list of enchancements [link\|http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html\|http://dev.mysql.com...sql-nutshell.html] The only thing referenced is the partitioning and that doesn't help the initial poor SQL optimization for the straight selects of smallish tables. I think I'm expecting too much since I have my Oracle experience.

Hey Greg! Database choice time - (crazy) - (40) - Oct. 4, 2007, 06:20:01 PM EDT

PICK? /me dux -NT - (boxley) - (1) - Oct. 4, 2007, 09:03:58 PM EDT

You can't duck low enough. </CLUB> -NT - (crazy) - Oct. 4, 2007, 09:47:10 PM EDT

Firebird? - (CRConrad) - Oct. 5, 2007, 02:22:09 AM EDT

Well, I've got a new religion lately... - (folkert) - (21) - Oct. 5, 2007, 02:51:03 AM EDT

Hmm, are they repeating Oracle's error: TOO MUCH "tweakage"? -NT - (CRConrad) - Oct. 5, 2007, 02:56:36 AM EDT

:-O - (static) - Oct. 5, 2007, 07:02:13 AM EDT

Oh and here is the MySQL Proxy page - (folkert) - Oct. 6, 2007, 12:01:27 AM EDT

Ok, playing with 5.0 - (crazy) - (14) - Oct. 8, 2007, 04:40:50 PM EDT

Some things are still slow in MySQL. - (static) - (13) - Oct. 8, 2007, 11:09:32 PM EDT

Oh yeah - I forgot about that - (crazy) - (12) - Oct. 8, 2007, 11:59:22 PM EDT

I saw an Oracle guy do a Bit Of Learning... - (static) - (11) - Oct. 9, 2007, 03:28:52 AM EDT

You teased me - (crazy) - Oct. 9, 2007, 09:20:16 AM EDT

On the other hand, maybe those MySQL people - (crazy) - (9) - Oct. 9, 2007, 04:58:50 PM EDT

OT have you looked at hadoop? - (boxley) - (5) - Oct. 9, 2007, 09:52:48 PM EDT

Nope - (crazy) - Oct. 9, 2007, 10:35:25 PM EDT

/me rubs eyes - (imqwerky) - (3) - Oct. 10, 2007, 08:37:47 AM EDT

You might have read it, but it's not what it said. -NT - (CRConrad) - (2) - Oct. 10, 2007, 04:48:24 PM EDT

I'm aware of that now - (imqwerky) - (1) - Oct. 10, 2007, 05:15:03 PM EDT

Ah. Forgot to get your head out, hadya? - (CRConrad) - Oct. 10, 2007, 05:26:34 PM EDT

Interesting. - (static) - (2) - Oct. 9, 2007, 10:21:48 PM EDT

"It's a bit of extra work" - not that much - (crazy) - (1) - Oct. 9, 2007, 10:38:18 PM EDT

Ah. I see. Wouldn't suit my use. :-) -NT - (static) - Oct. 10, 2007, 07:22:01 AM EDT

You play with partitioning yet? - (crazy) - (2) - Oct. 10, 2007, 12:56:07 PM EDT

Nevermind - needed key() -NT - (crazy) - (1) - Oct. 10, 2007, 01:14:55 PM EDT

Unusable - (crazy) - Oct. 10, 2007, 01:37:10 PM EDT

Rare updates, mostly reads? - (admin) - (4) - Oct. 5, 2007, 09:51:00 AM EDT

Still need SQL access - (crazy) - (3) - Oct. 5, 2007, 08:28:30 PM EDT

there is a sql like addon for berkley I dont care for it tho -NT - (boxley) - Oct. 6, 2007, 11:35:12 AM EDT

"Guide to Oracle Berkeley DB for SQL Developers": - (CRConrad) - (1) - Oct. 6, 2007, 01:46:11 PM EDT

I'm sorry, you must have thought I wote (new thread) - (crazy) - Oct. 6, 2007, 03:18:43 PM EDT

Here we go again - (crazy) - (9) - Oct. 18, 2007, 10:01:39 PM EDT

Did you use what version of MySQL. - (folkert) - (2) - Oct. 18, 2007, 10:49:57 PM EDT

No you didn't - (crazy) - (1) - Oct. 18, 2007, 11:29:40 PM EDT

This is the 5.1 list of enchancements - (crazy) - Oct. 18, 2007, 11:35:25 PM EDT

MySQL has lots of ah incompleteness in it's optimizer. - (static) - (2) - Oct. 19, 2007, 12:01:14 AM EDT

I have a tough time restructuring - (crazy) - (1) - Oct. 19, 2007, 12:25:56 AM EDT

Fair enough. -NT - (static) - Oct. 19, 2007, 09:19:44 AM EDT

Sigh... Didn't look too deeply into Firebird, didja? - (CRConrad) - (2) - Oct. 19, 2007, 06:36:52 AM EDT

Sigh - This time it's an option - (crazy) - Oct. 19, 2007, 07:50:50 AM EDT

Ehh, you never CARED! - (crazy) - Oct. 19, 2007, 06:05:16 PM EDT

Then again, I think our walls are made from the salvaged hulls of exotic alien spacecraft so YMMV.
116 ms