/srv/irclogs.ubuntu.com/2008/12/17/#ubuntu-website.txt

newz2000quiet room lately15:24
newz2000I went to a drupal training seminar last week and learned a lot15:24
newz2000Canonical hired the person who is in charge of visual appearance (cf: mark's blog post about making Ubuntu prettier than OS X)15:25
newz2000if you were at UDS you may have met him, his name is Julian (Hubbard may be his last name)15:25
nandI were at his presentation (like everyone else), *sounds* promising15:25
nandnow I'm looking at the actual results15:26
newz2000cool, I've hardly spoken with him so I'm eager to see action15:26
newz2000there's a job post for my team for a web *designer* http://webapps.ubuntu.com/employment/canonical_WD/15:26
nandI have always been a bit skeptical on designers speaking a lot too much :)15:26
newz2000in London though :-/15:26
nanddesigner I am not at all!15:27
newz2000nand: the difference between Julian and most designers is that he's been given authority by Mark S15:27
nandthat is why I'm now eagerly waiting for the results :)15:27
newz2000We released the module for launchpad auth in drupal15:28
newz2000(for Drupal 5, not ready for D6)15:28
newz2000that was last monday15:28
nandyep, I have hacked it and submitted patches for a migration process15:28
nandthat, we really need15:28
nandon the other side, the team plugin seems a bit broken, hadn't had the time to debug it yet15:29
nandgot locked out of my admin rights as soon as I activated it ^_^15:29
newz2000oh? Interesting15:29
newz2000I've been using it on two sites very nicely, but just yesterday I too got locked out.15:29
nandMy guess is it just erases roles, not merge them15:29
newz2000it does not modify the roles, yo uhave to map teams to roles15:30
nandtemporary solution is to log in using user uid 1 or disable the module in DB15:30
newz2000oh, maybe not the same prob, I can't even log in as uid 115:30
nand(not tested first solution, just a guess, used second solution :) )15:30
newz2000I do like the team/roles mapping a lot15:32
nandso will I!15:32
nandbtw15:32
nandI heard you need to be marked on LP so that your website can receive these infos?15:32
newz2000if you file a bug in ubuntu-website I get it15:33
newz2000if it's outside of that project you may need to mark me15:33
nand?15:33
newz2000(I'm also default for canonical-website)15:33
newz2000oh15:33
newz2000sorry, mis-understood your question15:33
newz2000do you mean you need group membership in launchpad?15:34
nandI mean, I heard that in order the team plugin to work, you need to register your website somewhere?15:34
newz2000oh. I thought that was not necessary now, but here's how to tell...15:34
nandI just heard that, not checked myself15:34
newz2000you try to login and the only data launchpad sends back is the openidurl. If lp tells you that it's sending your userid and/or email address that you're fine15:35
nandso far, I only get the login, not the email15:37
newz2000so it sends 'nand' back to the website or only the openid url?15:37
nand'nand'15:37
newz2000then you're set I believe. Let me ask stuartm real quick.15:38
nandbut ok, I know that you need to be registered somewhere to have mails too. The question is : do we need some similar case of registration for the LP teams plugin to work?15:38
nandboredandblogging: heya!15:39
boredandbloggingnand: hey, how are you?15:40
nandstill at work for now...15:40
nandjust so that you can take time to critisize my quick mockup meanwhile : http://www.ndeschildre.net/downloads/UBnews.html15:41
nandnewz2000: ^15:41
nandvery quick one, with a few of the ideas I had15:42
newz2000ah, that was you15:42
nandplease don't bite! :)15:42
nandme?15:42
newz2000btw, stuart says you need to register the site's "trustroot" which is in the docs.15:43
nandtrustroot... okay, I'll see that15:44
newz2000so are we having our meeting now or are we doing it later?15:44
* nand is still at work15:44
newz2000ok15:44
nandI'll much prefer having it once I'm back home15:44
newz2000sure, do you have a time in mind?15:45
nand19 UTC, still okay?15:45
boredandblogging19 UTC is fine with me15:45
newz2000sounds good to me15:45
nandgood15:45
newz2000I need to make a trip to the passport office, apparently mine looks tampered with.15:46
newz2000it got wet.15:46
newz2000-$10015:46
newz2000:-(15:46
boredandbloggingnewz2000: did you have trouble with it when travelling?15:46
newz2000no, I was in the US so my driver's license worked15:46
boredandbloggingright15:47
newz2000but I may have to go to London at the start of the year which will be a problem.15:47
boredandbloggingoooh15:47
boredandbloggingnewz2000: there was an email on -news-team yesterday started by james westby about the calendar stuff15:47
boredandbloggingI added you to it15:48
boredandbloggingcan you reply to it?15:48
boredandbloggingthink I've got everyone thinking about it at this point :-P15:48
* newz2000 looks for it15:48
newz2000oh, filed under fridge15:50
* newz2000 replies15:50
boredandbloggingnewz2000: thanks15:50
boredandbloggingis it me or is it very hard to find well designed news sites?16:54
nandlemonde.fr ? france24.com ?16:59
nandokay, let's keep that for in two hours :)16:59
boredandbloggingnand: I do like the layout of france24.com17:06
nanda problem common to lots of these news websites is : ads everywhere17:07
newz2000well, instead of comparing to other news sites, ask what is the goal and who is the user17:08
newz2000we may have different goals than other sites17:08
* nand is going back home17:21
=== Turl1 is now known as Turl
newz2000boredandblogging: I'm heading out the door a few min later than I expected, when nand comes back if I'm not back yet for our meeting I'll be only moments away18:00
newz2000(passport office is 10m away and I have the paper work already)18:00
newz2000cutting it close but should be back on time18:00
nandre!18:30
nandnewz2000, boredandblogging: whenever you want18:30
newz2000ok, I'm back earlier than I expected... fail on the passport :-(18:31
nandforgot some paper?18:31
newz2000yeah18:31
newz2000try again tomorrow18:31
boredandbloggingi'm ready as well18:44
newz2000ok boredandblogging, nand, lets go18:45
newz2000who wants to start?18:45
boredandbloggingnand: ping18:46
nandyep, I'm here!18:46
boredandbloggingso let me start18:46
boredandbloggingthe audience for the website18:46
boredandbloggingbasically, cover inter, intra, and external communication18:47
boredandbloggingI place for teams to post things that members of their own teams want/need to know18:47
boredandblogginga place for locos to share their experiences doing things18:47
boredandbloggingand show off what they have been able to18:48
boredandbloggingso it will help all locos18:48
boredandbloggingand in general18:48
boredandbloggingcommunication with the outside world18:48
boredandbloggingfridge should be where "outsiders" come to find out the latest happenings in the Ubuntu community18:48
boredandbloggingmaybe I should say the scope is everything :-P18:49
newz2000well18:49
nandQuestion: should we include external news, such as found in http://ubuntu-news.net/ ?18:49
newz2000boredandblogging: lets start with persona18:49
newz2000who is our user (or users) and what do they want?18:49
boredandbloggingnand no, not unless its very high quality18:50
nandnewz2000: My opinion is : all. Technically involved contributors, developers, and average non-technical users18:51
newz2000instead of all, lets define them. We can't please everyone and we don't want to become a yahoo-like portal18:51
boredandbloggingnewz2000: what nand said, does that sound too big of a scope?18:51
newz2000yes18:51
newz2000:-)18:51
boredandbloggingok18:51
newz2000Lets figure out three persona that we can cater to18:51
newz2000and we'll make the focus of them...18:51
nandpersona?18:52
newz2000(not counting the admins or peopel who post events (necessarily))18:52
boredandbloggingright, lets start with technical/developers18:52
newz2000for example, a loco team user who wants to know when and where the next loco team meeting18:52
boredandbloggingthats not the use case I'm sure we are going for18:53
nandagree18:53
newz2000ok, go ahead, lets create the proper persona then18:54
boredandbloggingits more like the LoCo had a release party, this is what they did to get it going, this is what happened, this is what they learned, etc18:54
boredandbloggingand throw in some pictures and videos18:54
nandyep18:55
nandwe could include the planning part, but that would be a secondary optional goal18:55
newz2000ok, so one persona is a team that wants to brag about an event that happened in the past, possibly uploading pictures or videos18:56
boredandbloggingnewz2000: correct18:56
newz2000so that may not even be the right track18:56
newz2000because that's focusing on the people who are publishing events, and they'll benefit little from a redesign.18:57
newz2000It's the people who are interested in reading about that event that need to be defined.18:57
newz2000And maybe those people aren't even a good target, it's the people who come to the fridge to get some kind of information that we need to identify.18:57
newz2000Once we do that then we can decide how best to meet their needs with the design.18:57
boredandbloggingah right, I see18:58
boredandblogginghow about this...18:58
boredandbloggingloco members who are trying to find out what other locos are doing?18:58
nandand want to gain experience, tricks and tips from them?18:59
newz2000ok, that sounds good18:59
nand(how did the french do to gather 4000 people?? :) )18:59
boredandbloggingright18:59
nandnext: Ubuntu teams members, contributors ?19:00
nandpeople in the loop, technically advanced19:00
boredandbloggingone of the things james westby talked about was how sometimes developers fall off the map19:01
boredandbloggingthey go away for a while and then come back19:01
boredandbloggingsince MOTU stuff moves pretty fast, there is no way for them to keep track of what has changed19:01
nandand that's why they were talking about this Developer News19:02
boredandbloggingright19:02
boredandbloggingthis applies to non-MOTU related activities as well19:02
boredandbloggingsay Xubuntu needs a new ISO tested19:02
boredandbloggingthe reader might be anyone looking to help out19:03
boredandbloggingor looking for a way to participate19:03
boredandbloggingis that vague?19:03
nandin this case, it is a third kind of person : potential contributor19:03
newz2000it is  a bit vague19:04
newz2000so these are people who are in the community but need to stay in touch with what's happening?19:04
boredandbloggingright19:05
nandyes19:05
newz2000that sounds good enough19:05
boredandbloggingand maybe a separate persona of people who want to find ways to participate19:05
newz2000let me make a sugegstion for another...19:05
newz2000people who are not yet sold on Ubuntu and want to find out what's going on or hear the buzz19:05
boredandbloggingdefinitely19:06
nandthe outsider category19:06
boredandbloggingmedia folks who are looking for something to write about19:06
nandso summing all, we end up by targeting all people :)19:06
newz2000well, not really19:06
nandor let's say : who are we not targetting?19:06
newz2000not yet19:06
newz2000but we will19:07
newz2000we have three maybe four personas now we want to cater to19:07
nandwho do we don't want to target?19:07
newz2000wait19:07
newz2000:-)19:07
newz2000let's restate our personas and ensure we agree19:07
newz2000locos - want to know what other locos are doing19:07
newz2000insiders - trying to stay in touch with what's going on19:08
newz2000outsiders / press - looking for use cases or success stories about Ubuntu19:08
boredandbloggingyeah, looks right19:08
newz2000you started to mention a fourth...19:08
newz2000people who want to participate19:08
nandand we mentionned people wanting to contribute19:08
nandyeah19:08
newz2000is the fridge the best place for those? Do we currently help them?19:09
boredandbloggingthat maybe more of a ubuntu wanted thing19:09
boredandbloggingor the Partipcate page19:09
boredandbloggingParticipate19:09
nandthey may be inter related19:09
nande.g. "Call for testing" : you need people fast19:10
nandyou may want to put it in front page for a while19:10
newz2000ok, so that may be a good persona then19:10
nandbut on the overall, yeah, wanted19:10
nandwe don't want all help request on the news website. But a few once in a while would not hurt19:11
boredandbloggingyeah, depending on what it is19:11
nandand concerning the Fridge, for outsiders, its visibility is very bad19:11
nandhttp://ubuntuforums.org/showthread.php?t=98827819:11
nandinsiders : I'm not aware of any of us reading the fridge19:12
nandsince its content can be found on the planet19:12
boredandbloggingwhich we've discussed is a bad place to announce anything19:13
boredandbloggingthats why we need to revive the fridge :-)19:14
nandoh, new numbers on the poll! It was worse before19:14
boredandbloggingnewz2000: so what do you think?19:14
nandand locos: basically they is very few content for them.19:15
newz2000I was wondering if we need to revise our persona, or do you think the original three are OK (considering the comment about "insiders")19:15
nandstill ok for me19:16
newz2000ok, so we have our three persona19:17
newz2000who is not going to be best served by the fridge?19:17
nandwhy should one of these category be badly served?19:17
newz2000no, I mean who have we not discussed yet19:18
newz2000those that we are not catering to19:18
boredandblogginganyone who has no clue about Ubuntu19:18
boredandbloggingwhich is ok19:19
nandfor this, we need a good inter-website navigation, so that they can easily find ubuntu.com19:19
newz2000anyone else?19:19
boredandbloggingnot that I can think of19:20
newz2000ok, so we need to decide how to attract and serve our target users and how to deflect the others19:21
newz2000how can we make the target users happiest?19:21
* newz2000 is putting this on the wiki btw19:21
nandlots of news19:21
nandand well organized19:21
newz2000do all three persona care about the same news or do they each want something different?19:21
nanddifferent19:22
newz2000ok, for each, what do they want?19:22
boredandbloggingi think at a high level most would be interested in knowing some of the same thing19:22
boredandbloggings19:22
boredandbloggingfor example, the 4000 people french release party19:22
boredandbloggingit may be not technical, but it would surely interest everyone19:23
nandyeah19:23
nandthe most interesting piece of news understandable by all categories of people19:23
nandpieces19:24
newz2000ok, so what do the loco users want to know?19:24
boredandbloggingevents, bug james19:25
boredandbloggingjams19:25
nandevents on the LoCo team ("new locos database", ...)19:25
boredandbloggingi have a side question19:26
boredandbloggingare their not categories of news that cross all personas?19:26
newz2000yes, there probably are19:27
boredandbloggingfor example, the Ubuntu Hall of Fame19:27
nandbig pieces of news19:27
boredandbloggingthats not loco or developmental specific19:27
boredandbloggingfree culture showcase, etc19:27
newz2000What's going to happen is that by identifying the needs of our users we'll create a homepage where everyone who is a target user gets satisfaction19:27
boredandbloggingso all three personas find something for themselves on the homepage?19:28
newz2000yes19:28
boredandbloggingmakes perfectly good sense19:28
boredandbloggingback to locos19:29
newz2000Events and bug jams so far19:29
boredandbloggingthink they would like to know the high level things19:29
boredandbloggingfree culture showcase19:29
boredandbloggingopen week19:29
newz2000maybe we should also identify what they don't want to see... is there something that would either turn them off or waste their time19:30
boredandbloggingtoo much technical stuff :-P19:30
boredandblogginglow level technical discussions or topics19:31
newz2000good19:31
newz2000here's what i have so far: https://wiki.ubuntu.com/Fridge/Persona19:31
newz2000we can revise this at any time so lets move on to the next persona, insiders19:32
boredandblogginginterested in MOTU, docs, testing19:33
nandthey will like news from their team19:33
boredandbloggingor maybe they are just subpersonas of insiders19:33
nandand also getting the headlines from others teams19:34
newz2000nand, those last two combined == 'everything'19:34
newz2000:-D19:34
nandeheh19:35
newz2000What will turn the insiders off?19:35
boredandblogginghmm19:36
nandaverage users tip and tricks... well, any newbie related stuff19:36
boredandbloggingwhich I doubt we will have much of19:37
newz2000ok19:37
newz2000Outsiders19:37
nandIf we let people submit posts... :)19:37
boredandbloggingnand: thats a whole different issue19:37
boredandblogging:-P19:37
nandOutsiders, we can see it in Brainstorm, want to know what's going on in the development of Ubuntu!19:38
newz2000I've made a note of it19:38
nandand while being technically accessible19:38
boredandbloggingright, no one wants to join IRC or mailing lists to find out19:38
nandit's just out of question for them19:38
nandoh, and19:39
nandfor the average user, Ubuntu is... everything. No upstream conception19:39
nandso they will expect news related to... every area19:40
nandXorg, kernel, ...19:40
newz2000good observation nand, I think I agree19:40
nandthey'll want to know when a new ATI hardware is supported, they'll want to know when a new big feature has finally landed on gnome, and so on...19:41
boredandbloggingits fine if we can tell them, but can point them upstream if needed19:43
newz2000here's what I ahve so far: https://wiki.ubuntu.com/Fridge/Persona19:43
nandif they do have some kind of news items, of course.19:43
nand(and non technical ones)19:43
nandokay19:44
boredandblogginglooks good19:44
newz2000so you're starting to see the kinds of things that would make a good homepage for our users19:44
newz2000and what to avoid19:44
nandA kind of three main subportal may be a good idea19:45
newz2000maybe, but as  you noted, some of the things are interesting to multiple target users19:46
newz2000so I wouldn't do one-column per persona19:46
nandoh nono I was not thinking of that19:46
newz2000instead focus on ways to get interesting data for each above the fold19:46
nandbut roughly that: http://www.ndeschildre.net/downloads/UBnews.html19:46
nand(the big tabs)19:47
nand(roughly :) )19:47
newz2000sure19:47
nandFirst page combine a little of all, but no to almost no technical stuff at all19:47
newz2000nand, are you good at theming?19:47
nandI'm not really a designer. I can get some stuff done, but that takes me much longer than a designer would do :)19:48
newz2000if I give you my html and images can you make it into a theme?19:48
nandno problem19:48
newz2000ok, I have a working html template but it's not a drupal theme19:49
boredandbloggingwould now be a good time to talk about LP integration and videos?19:49
newz2000almost19:49
nandand language support? :)19:49
newz2000nand: it looks like yours but has better typography, simpler layout code and is fixed width (and we can adjust the width)19:49
boredandbloggingoh yeah, I was gonna mention the width thing19:49
newz2000go for it19:50
nandyeah, do we want fixed or not?19:50
newz2000What I have is fixed but we don't have to use fixed19:50
newz2000if we do, I think the fridge can support a wide fixed-width19:50
boredandbloggingif not fixed width, something that doesn't go all the way across19:50
nandpb with fixed is that it sucks on big screen. Pb with non-fixed is that it's harder to make a good theme of it19:50
newz2000yeah19:51
newz2000why don't we start with what I have19:51
nandwhat do you have?19:51
nandOh19:51
newz2000it's pretty good and if we make it 950px wide it will work nicely19:51
nandand I forgot19:51
newz2000for most people19:51
newz2000(can be seen on shipit currently)19:51
nandby theme, you mean the outside of the page?19:52
newz2000yes19:52
newz2000just the shell, the brown part with the rounded corners19:53
nandok19:53
newz2000I also have the graphic I made for the fridge currently if that helps (in svg format)19:53
nandwe should maybe keep the design part for later and first see about languages, LP integration and videos?19:53
newz2000ok19:54
nandConcerning languages, why not make this available in several languages? Drupal offer the infrastructure to translate existing nodes19:55
nandthat could be managed by community members19:56
nanda real life example is http://observers.france24.com/en/, http://observers.france24.com/fr/, http://observers.france24.com/ar/19:57
newz2000So where do people who want non-english ubuntu news go now?19:57
nandin their local loco team website, if it exists (rare), or... nothing19:58
boredandbloggingyeah, depends on the locos who speak that language19:58
newz2000Ubuntu.com is english only and depends (and in the future will explicitly refer people to) localized sites.19:59
newz2000not saying same has to be for fridge20:01
boredandbloggingthe thing is, I'm not sure how much of the fridge would get translated if the option was available20:01
newz2000especially considering how fast news can change20:01
newz2000what about lp integration?20:01
nandwe can let the local members decide what to put on their frontpage20:01
nandLP integration : tested locally on Brainstorm, works great.20:02
nandLP teams binding needs some bugs fixes20:02
boredandbloggingi wanted this specifically for comments (can be used for other things if needed)20:02
newz2000ok, so to comment must have a launchpad id?20:03
boredandbloggingif a reader is already logged into LP, use their name, maybe their profile pic20:03
nandsound ok. Avoid spam pbs20:03
boredandbloggingnewz2000: thats a tricky question20:03
boredandbloggingwould like it to be open, but I'm afraid of spam20:03
boredandbloggingmaybe some captcha could help20:04
newz2000there is spam blocking plugins like mollum and etc20:04
nandokay, one or the other20:04
nandif LP data available, display img and stuff20:04
nandotherwise too bad20:04
nandVideos?20:05
newz2000go for it20:05
boredandbloggingyes20:06
boredandbloggingthis is my big thing20:06
boredandbloggingi think the front page should always have a nice picture or video20:06
boredandbloggingthe content from UDS alone gives us material for a couple of months20:07
newz2000ok, would that be self hosted or on youtube/etc?20:07
nandI do agree, as much as possible, videos/imgs20:07
boredandbloggingand I don't think we should be hosting any of the videos either20:07
boredandbloggingyoutube is being used for the UDS stuff20:07
boredandbloggingwe just embed20:08
newz2000I saw a good demo last week of how to add videos to your website when they're hosted elsewhere20:08
nandCCK and stuff20:08
newz2000piece of cake, though I don't know about the security/firewall concerns (with that server being able to ping youtube)20:08
boredandbloggingi'm a bit worried about the different sizes that all the different sites use20:08
newz2000yes20:08
boredandbloggingi tried embedding on the current fridge, and it let me20:09
boredandbloggingat least when previewing, didn't actually submit it20:09
nanddepend on the filter in use20:09
nandbut the size of the player can be given to the player20:10
nandanything more on videos?20:10
newz2000http://youdrup.com/ youtube clone done in drupal20:10
newz2000:-)20:10
boredandbloggingnie20:11
boredandbloggingnice20:11
Turlnewz2000: is there an ubuntu download page in other lang than english? you should make one if there isn't, or promote it if there is20:11
newz2000there is not, but one of my hopeful plans for next release is to make a syndicatable download iframe that can be localized20:12
newz2000that's an unofficial goal currently. :-)20:12
Turlgreat :)20:12
nandNow I'd like to see the frontpage:20:12
Turland how's that automatic mirror selection going?20:12
nandit should not be in a blog format, where the latest comes first. Instead, items would be ordered by the editors20:12
newz2000Turl: good, I got approval for geoip but I'm going to have a meeting with #is this week or next to discuss it in details20:13
nandso that important pieces of news stay longer on top20:13
Turl#is? what's that?20:13
newz2000information systems20:13
newz2000the people who make the servers work20:13
Turloh great :)20:13
newz2000performance is going to be a concern so we'll be playign with it some after the new year (tentatively)20:14
TurlI don't think you'll have performance issues20:14
newz2000yeah, the download page is currently proxied but not cached (so I hear)20:14
Turlhow many simultaneous users use the download page? 500?20:14
newz2000geoip should not add much at all to that20:15
newz2000good question, I dont' know, but a lot20:15
newz2000but because it is proxied getting the correct IP can be a challenge sometimes20:15
boredandbloggingdo we need to discuss the front page more?20:15
* newz2000 isn't worried though20:15
newz2000I'm ok with whatever you want to do on the front page20:16
nandok, anything else?20:16
Turla cheap VPS server can handle 500+ users on a forum (vBulletin) with the correct caching & webserver, I don't think you'll have any problems20:16
newz2000I can help with suggestions or technical difficulties but if you and nand want to head it up I'm fine with that20:16
newz2000Turl: ubuntu.com gets far far far more than that20:16
newz2000people litterally sit on the homepage and press refresh over and over again20:17
Turlyeah, but I don't think 100+ users at the same sec will enter the dl page, will them?20:17
newz2000yes20:17
Turl:O20:17
newz2000at times, like on release day for example. :-)20:17
boredandbloggingnand: do you want to try creating a real theme and testing it out?20:17
boredandbloggingthen we can go over it and discuss?20:18
Turlwell, you can have more than one vps server I imagine :p no problem either20:18
newz2000nand: why don't you draw it first20:18
nandboredandblogging: I'll try to refine the one I started20:18
boredandbloggingyou know, release early, release often :-)20:18
nandbut that will take some time... I'm quite tired of working all day on a news website already ;)20:18
newz2000nand: I'll send you the the theme I started and you cn use it if you like20:19
nandok thx20:19
Turlbtw newz2000, I fixed the IE issue I had yesterday, with the help of css's top:20:20
boredandbloggingnand: do we want to set a timetable for the first iteration?20:20
boredandbloggingI don't know whats a good time estimate20:21
nandI may have something early January...20:22
nandI don't promise anything!20:22
boredandbloggingnand: how about we say January 15th?20:23
newz2000nand: two emails sent, one with theme, one with fridge graphics20:23
newz2000cc'd boredandblogging20:23
nandnewz2000: thx20:23
nandboredandblogging: I don't like fixed deadlines, that gives me extra pressure :)20:24
nandI'll let you know once I have something20:24
boredandblogginglol, ok20:24
newz2000every time you say that boredandblogging moves the date one day closer20:24
boredandblogging:-P20:24
nandboredandblogging: could you send me a little bit of the fridge DB?20:25
nandor even the whole DB20:25
boredandbloggingnewz2000: can you do that?20:26
newz2000I can get a dump of everything but the users table for you20:26
nandjust need the node table, if my assumption that you're not using CCK is right20:28
newz2000sorry, you get it all. :-)20:29
boredandbloggingheh20:30
nand:p20:30
newz2000hmm... maybe should have ignored sessoins table too20:30
nandyeahh, takes hundreds of Mb in brainstorm20:32
newz2000anonymous users20:32
newz2000learned a performance trick, using memcached for sessions helps a bunch20:32
newz2000haven't used it yet20:32
newz2000nand: can I give you a link to an 80m file for you to download and then let me know when finished, or would you rather do it tomorrow?20:33
nandnewz2000: you can do it right now20:34
boredandbloggingcan't everything from the session table just get cleared occasionally?20:34
newz2000nand: ping me when you have it and I'll delete it20:34
newz2000boredandblogging: yes, cron.php clears out old stuff automatically20:35
nandnewz2000: thanks20:35
nandnewz2000: by default, it does not clear the session table20:35
newz2000oh, really? that explains a lot.20:35
newz2000the problem with sessions table is that it uses MyISAM table format by default and therefore locks the whole table for updates and deletes20:36
newz2000causing serious contention issues20:36
newz2000(basically site goes offline for long operations)20:36
newz2000I've got a script somewhere that clears it 1000 records at a time to avoid contention20:36
nandnewz2000: okay, finished, thx20:42
newz2000my pleasure20:42
=== Turl1 is now known as TUr1
=== TUr1 is now known as Turl1
=== Turl1 is now known as Turl
=== Turl1 is now known as Turl

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!