[05:14] <androidbruce> seattlegaucho, are you a mysql guru?
[05:16] <valorie> he is!
[05:18] <androidbruce> well then he and I need to talk 
[05:19] <valorie> he's been scarce
[05:20] <valorie> I've been wishing he was in #amarok more too, but I see him rarely
[05:20] <androidbruce> yeah, gotcha
[05:20] <androidbruce> did you see that 11.04 is using banshee as it's default player instead of rhythmbox 
[05:20] <androidbruce> that makes me a sad panda
[05:21] <valorie> eh
[05:21] <valorie> amarok uber alles
[05:21] <valorie> lol
[05:24] <androidbruce> hahah yeah 
[05:25] <androidbruce> i'm running it now in a vm 
[05:28] <valorie> \o/
[17:22] <androidbruce> seattlegaucho: you around 
[18:48] <seattlegaucho> androidbruce: I am now
[19:01] <androidbruce> seattlegaucho: i am in need of some mysql schooling 
[19:01] <androidbruce> can you provide help/support?
[19:01] <androidbruce> what's your consultant fee?
[19:01] <seattlegaucho> no fee, my schedule is busy enough as-is to be able to moonlight :)
[19:02] <seattlegaucho> however, depending on the extent of what you need I can: a) point you in the right direction as you did when I rooted my G1
[19:02] <androidbruce> seattlegaucho: i gotcha. well if you could point me to some cool resources to learn mysql that would be great 
[19:03] <seattlegaucho> b) if you just need a couple of hours, get more involved hands-on and leave at a point from where either you finish it yourself or be back at a)
[19:03] <seattlegaucho> c) recommed a person and/or company that can help you out
[19:03]  * seattlegaucho points at himself for a starting point :)
[19:04] <seattlegaucho> shoot your first Q or describe your difficulties
[19:05] <androidbruce> well for starters what is the best way to manage mysql? phpmyadmin? 
[19:06] <androidbruce> also, are most commands performed in mysql, or mysqladmin?
[19:06] <androidbruce> im in the early stages of creating databases and websites. and i've just been reading and hacking through tutorials. 
[19:23] <seattlegaucho> the prefferred way it 'mysql'  ... the CLI utility
[19:23] <seattlegaucho> if you're more of a GUI guy, try out the latest MySQL Workbench
[19:23] <seattlegaucho> I never liked phpMyAdmin very much
[19:23] <seattlegaucho> it's too fat for the little it offers
[19:28] <androidbruce> seattlegaucho: how would i go about learning to use the CLI utility?
[19:28] <androidbruce>  help and man pages?
[19:29] <seattlegaucho> you have 2 main resources: a) docs and b) \h on the tool's command line
[19:29] <androidbruce> here is a softball for ya? what are the uses of mysql and are they're any alternatives?
[19:30] <seattlegaucho> as in 'mysql'  the CLI tool or MySQL the product?
[19:31] <androidbruce> ummm mysql the product 
[19:32] <androidbruce> then if you could elaborate on the cli vs gui/webinterface
[19:33] <seattlegaucho> alternatives to MySQL: a) MariaDB is my favorite ... it has all the worthy patches
[19:34] <seattlegaucho> b) stay MySQL: it's very good at what it does and Oracle is doing a very good job at fixing bugs and keep improving it
[19:34] <seattlegaucho> mysql CLI offers a flexibility that no other tools comes close
[19:35] <androidbruce> i have phpmyadmin installed, how would i access that interface on my box? i have apache installed and working
[19:38] <seattlegaucho> GUI usually tackle the basic stuff, they can't go as deep as the CLI can go
[19:39] <seattlegaucho> it probably has a URL or a HTTP port
[19:39] <androidbruce> yeah, i'm wondering where that config might be, guess i need to rtfm 
[19:39] <seattlegaucho> http://localhost:xxx/ would be my first guess (don't know what xxx value is) as with samba, cups, etc
[19:39] <androidbruce> got it 
[19:40] <androidbruce> it's localhost/phpmyadmin by default
[19:40] <seattlegaucho> that'd would've been my 2nd gues
[19:40] <seattlegaucho> *guess
[19:40] <seattlegaucho> however, once you get familiar with the CLI ... it's what everybody uses for admin
[19:40] <androidbruce> so i can create databases, and have cms's use those db's that i've created in mysql 
[19:40] <androidbruce> gotcha
[19:40] <seattlegaucho> yep
[19:41] <seattlegaucho> every app has it's own ways of dealing with it
[19:41] <androidbruce> what is a collation exactly? 
[19:41] <seattlegaucho> how you sort
[19:42] <seattlegaucho> different alphabets use different ordering criteria ... 90% of the times, you shouldn't worry about that
[19:42] <androidbruce> ahhh gotcha 
[19:42] <androidbruce> can you have a mysql server in a different location than the webserver?
[19:43] <seattlegaucho> for low volume data not necessarily, for medium to big data: mysql server should run on it's own
[19:43] <seattlegaucho> keep in mind that memory is more important than cores
[19:43] <androidbruce> space? 
[19:43] <seattlegaucho> depends on data volume
[19:43] <androidbruce> how much 'storage' should one allocated?
[19:43] <seattlegaucho> *don't* use regular NFS
[19:44] <seattlegaucho> we DB running with 1~2 GB and others with 600GB
[19:44] <androidbruce> ahh ok 
[19:44] <androidbruce> don't use regular NFS? what do you reccommend?
[19:44] <seattlegaucho> if you run it off a VM *never* run data and/or logs off a virtual disk
[19:44] <seattlegaucho> either local storage or a good SAN
[19:45] <androidbruce> ahhh dude to corruption?
[19:45] <androidbruce> due**
[19:45] <seattlegaucho> yep ... LVM degrades performance up to a 20% ... maybe more, maybe less depending on actual load
[19:45] <seattlegaucho> many people swear that XFS is better than ext3/4 for data
[19:46] <seattlegaucho> again ... depends on data traffic
[19:46] <seattlegaucho> if you use KVM for virtualization, go with *raw disk* for data and map it to an actual partition on disk 
[19:46] <seattlegaucho> ... need to go, be back in ~1hr
[19:52] <androidbruce> thanks a lot man 
[20:43] <seattlegaucho> androidbruce: I'm back
[20:46] <androidbruce> seattlegaucho: you rock bro, i owe you a beer 
[20:46] <androidbruce> seattlegaucho: how do i view docs/ help pages again?
[20:46] <seattlegaucho> we're even ... I'd never had that G1 running if it weren't for you :)
[20:46] <seattlegaucho> if you're on the 'mysql'  CLI ... type \h to get UI help or ... HELP command
[20:47] <seattlegaucho> the 2nd one points you gives you enough information to not need to remember syntax specifics and ...
[20:47] <seattlegaucho> the URL to the docs on the web 
[20:48] <seattlegaucho> the one I use the most is: pager
[20:48] <seattlegaucho> or \p
[20:48] <seattlegaucho> 'pager less'  pipes all the output to 'less' ... you can use more sophistaced pipes
[20:49] <seattlegaucho> 'pager' returns to use stdout
[20:49] <seattlegaucho> also, it's awesome to pipe commands through it
[20:49] <seattlegaucho> are we going to organize something for 11.04 release?
[20:49]  * seattlegaucho hates .10 releases, they always have something broken
[20:50] <seattlegaucho> 10.04 worked great w/ OpenVPN + NetworkManager
[20:50] <seattlegaucho> 10.10 with exactly the *same* settings, doesn't work
[20:51] <seattlegaucho> too bad that one of the LTS broadcomm wireless drivers broke and couldn't find a solution
[21:14] <androidbruce> sorry for no response, day job got me busy seattlegaucho 
[21:25] <seattlegaucho> np
[21:25] <seattlegaucho> my day job tends to do the same to me :)
[22:46] <androidbruce> exit
[22:46] <androidbruce> exit
[23:16] <androidbruce> seattlegaucho: you there bro 
[23:16] <seattlegaucho> working on an email ... so if you can deal with the pauses ... yes
[23:30] <androidbruce> seattlegaucho: if you were starting on a fresh machine, how would you go about getting mysql installed? 
[23:31] <seattlegaucho> for fooling around, go with the packages in teh distros repositories, unless you're in RH
[23:31] <seattlegaucho> for production, go with the latest package/tarball in the MySQL downloads section
[23:31] <seattlegaucho> ... today the choice of using 5.1 or 5.5 depends mostly on the app
[23:32] <seattlegaucho> some bad apps break when using 5.5
[23:38] <androidbruce> gotcha. ok how would you go about installing joomla on a fresh machine? install apache2, then mysql?
[23:40] <androidbruce> i already have it installed and running. but i dunno if i've used the best of methods
[23:55] <seattlegaucho> hmm ... I'd would've done it the other way around -> infrastructure first