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