Time Nick Message 10:52 kados I see 10:47 paul with a very specific content, and only a few readers. 10:47 paul although most have only a "few" circ, because they are search libraries 10:47 paul max circ should be something like x0 000 10:46 paul and i've no libraries with more than 1 branch 10:46 paul Next week i'll put to production a library with 45 000 items, that will be my biggest 10:45 paul the biggest will be 100 000 items when all catalogued, for instance 18 000 10:45 paul lower than you ;-) 10:45 kados so paul ... I've a few questions about your libraries: which is the biggest? and what are annual circ, # of borrowers, # of items? 10:32 kados (add the m2 to that list ;-)) 10:32 kados so the m1 doesn't use index, the marc_bibli doesn't use index and the biblio doesn't use index ... that's a lot of missing indexes for a search 10:23 paul maybe somethings changed but i've forgotten at the moment 10:23 sylvain vu pour le lost paul merci 10:23 paul strange. they are supposed to be used, you're right. 10:22 kados so what are sndx_word and Search_Marc indexes for? 10:22 kados yep .. well that gets rid of the filesort 10:22 paul ok, so, really strange... 10:22 paul (maybe a good place to investigate... remove the orderby) 10:22 kados (and I took out the order by ) ;-) 10:21 kados that's what I was thinking 10:21 paul (except order by) 10:21 paul strange because almost nothing has changed since 2.0 on this side of Koha 10:21 paul mmm... 10:20 kados (given our limitations) 10:20 kados opac queries are pretty laggy (6-10 sec) ... I'm going to try to figure out if there a way to optimize further 10:20 kados right 10:19 paul where your is 10x this ! 10:19 paul for sure, but my DB is only 20 000 biblios 10:19 kados I agree 10:19 kados hmmm, 839 is REALLY not good ... I'd take 47 happily:-) 10:19 paul that's why marc_words is a must-have-asap... 10:18 paul (that is not very good i agree) 10:18 paul 47 1 1 12 20 10:18 kados ok 10:18 paul with a french query, I get results like yours : 10:18 kados hmmm, maybe ... how about doing a french query ... 10:17 paul isn't my "row" column due to a "english" query where i have only french db ? 10:15 kados any ideas? 10:14 kados that's my problem ... I wonder how to solve it 10:14 kados the rows on yours 10:14 kados one major difference 10:14 paul | m2 | range | bibid,word | word | 255 | NULL | 1 | Using where; Distinct | 10:14 kados but the keys don't look right (sndx_word and Search_Marc aren't working?) 10:14 paul | biblioitems | ref | bibnoidx | bibnoidx | 4 | biblio.biblionumber | 1 | Using index; Distinct | 10:13 paul | biblio | eq_ref | PRIMARY,blbnoidx | PRIMARY | 4 | marc_biblio.biblionumber | 1 | Distinct | 10:13 paul | marc_biblio | eq_ref | PRIMARY,biblionumber | PRIMARY | 8 | m1.bibid | 1 | Using where; Distinct | 10:13 paul | m1 | range | bibid,word | word | 255 | NULL | 1 | Using where; Using temporary; Using filesort | 10:13 paul I have the same explain 10:12 kados I wrote my own order by sub for SearchMarc so I've been able to get rid of the 'using filesort' ... 10:12 paul mmm... stupid paste. 10:12 paul Extra 10:12 paul 10:12 paul rows 10:12 paul 10:12 paul ref 10:12 paul 10:12 paul key_len 10:12 paul 10:12 paul key 10:12 paul 10:12 paul possible_keys 10:12 paul 10:12 paul type 10:12 paul 10:12 paul table 10:12 paul I get : 10:11 kados | biblioitems | ref | bibnoidx | bibnoidx | 4 | biblio.biblionumber | 18 | Using index; Distinct | 10:11 kados | biblio | eq_ref | PRIMARY,blbnoidx | PRIMARY | 4 | marc_biblio.biblionumber | 1 | Distinct | 10:11 kados | marc_biblio | eq_ref | PRIMARY,biblionumber | PRIMARY | 8 | m1.bibid | 1 | where used; Distinct | 10:11 kados | m1 | ref | bibid,word | bibid | 8 | m2.bibid | 34 | where used | 10:11 kados | m2 | range | bibid,word | word | 255 | NULL | 839 | where used; Using temporary; Using filesort | 10:11 kados I've got some perf probs since the upgrade ... I'm afraid my indexes are not optimized: 10:11 kados explain select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1,marc_word as m2 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid) and ((m1.word like 'book')and (m2.word like 'boys')) order by biblio.title; 10:11 kados paul can you run this on one of your machines for me? 10:10 kados I'll commit it asap 10:10 kados sure ... it goes along with the suggest and spellcheck features ... 10:10 paul useful for official release ? 10:09 kados I wrote a small addition to SearchMarc that tracks all opac searches 10:09 kados opac queries 10:09 paul you mean opac query or apache query ? 10:08 kados hmmm, well we get about 500-1000 queries per day 10:07 paul any idea of opac use ? 10:06 paul ah, ok ;-) 10:06 paul you must be kidding 10:06 kados ;-) 10:06 kados sorry ... I meant 1.5 Mb 10:06 paul you mean 1500 BYTES .? 10:06 paul 1.5Kb ??? 10:06 paul do you have an idea of opac use ? 10:06 kados our network is mostly 1.5Kb 10:06 kados two in each branch for circ ... plus at least two others for other purposes (behind the desk) 10:06 paul i mean between branches 10:05 paul (10MB ? 100MB ? less ? more ?) 10:05 paul what kind of network ? 10:05 paul how many librarian computer ? 10:05 kados 30,000 borrowers 10:05 kados our circ is 620,000 10:05 paul ok. And how many issues per year ? 10:05 kados yep 10:04 kados three disks, one for database, one for filesystem and one for backups, etc. 10:04 paul just 1Ghz pentium ? 10:04 paul ok, thanks 10:04 paul i saw you chat with stephen about updatedatabase... 10:04 kados no raid 10:04 paul 4 disks in RAID 5 ? 10:04 kados last night we migrated to 2.2 10:04 paul just with specific mysql tuning (mysql cache in RAM) 10:03 kados our server info: 1Ghz pentium, 2gig of ram, 10,000rpm disks ... not a showstopper 10:03 paul 'morning joshua 10:02 kados hi paul ;-) 09:12 paul syl_away : là je sais, c'est lorsque la carte lecteur est perdue : on peut "désactiver" le lecteur par ce biais. Si le lost est coché, alors prêt impossible. 08:44 sylvain bon avant d'aller manger, une autre question, le sens de la colonne lost dans la table borrowers si quelqu'un sait ;) 07:51 sylvain ok 07:51 paul (au tel) 07:51 sylvain paul ? 07:49 sylvain une petite question encore (gros début de semaine :)) dans la fonction C4/Accounts2/manualinvoice on a des descriptions du style 'new card', 'lost item' ... Au niveau internationalisation, quand c'est pas dans des templates, il y a une méthode particluière pour les traductions ? 07:22 sylvain tu sais à qui je pourrais poser des questions concernant les lecteurs ? 07:20 paul non pas trop. 07:19 sylvain paul, une autre question du même style, dans la table borrowers, on a un champ area, tu sais à quoi il correspond ? 06:46 sylvain ok, merci quand mm ;) 06:45 sylvain tiens paul une petite question si tu as le temps, quand je crée un lecteur, pourquoi est-ce que sa date "joined" n'est pas initialisée ? Ca se spécifie quelque part ? 06:37 paul coucou 06:37 sylvain hi all 05:15 paul kados, i'm here (9AM in France now, was 4AM when you "called" me, so I was in bed. I suspect you are in bed now ;-) 05:14 hdl salut paul 05:14 paul salut hdl 01:34 kados paul around? 00:44 rach which would seem a lot easier 00:44 rach or the librarian looking up and counting them 00:43 kados harry seldon would beg to differ ;-) 00:43 rach without some sort of pressure matt :-) 00:43 rach yep i reckong it's not really possible 00:43 kados (like they do in phone queues) 00:43 kados but it's probably possible 00:43 kados we'd need a statitition to tell us how to calculate it 00:43 kados well Koha could surely provide data for that 00:42 kados ahh ... I understand 00:42 rach no I think they mean a physical queue 00:41 kados we have a special script for that 00:41 rach but I rang HLT and they reckoned you couldn't 00:41 kados right ... so you mean for reserves? 00:41 rach ah I wanted to know how you might tell how many people were in a que waiting to to get items issued (without being able to see them) I assume you can't, but wondered if there was some sort of assumption based statistic, like if you get this many people issued in 5 mins then they must have been in a que 00:40 kados what's up? 00:40 kados rach: here now 00:01 rach and can you answer a dumb question for me? 00:01 rach joshua are you there/ 23:27 kados reboots are all good 23:23 owen Stephen said the intranet format search wasn't working? 23:22 owen We'll have to post a message to the tech forum. 23:22 owen Bookmarks for the reserve list will be incorrect now. 23:08 shedges yep, I'm done for the night. Thanks, Joshua! 23:07 kados requires a reboot ;-) 23:07 kados shedges: so if it's alright with you I'll swap RAM and optimize mysql ... 23:00 shedges I'm click on "Reserve List" in the left navigation bar -- takes me to the main page 22:59 kados it's working for me 22:59 kados it's not? 22:58 shedges what a minute -- !! Thought I saw it working. 22:58 shedges yep -- nice! 22:57 kados reservelists included ;-) 22:56 shedges I've beat on about everything I can think of -- it looks to me like we can all go to work tomorrow. 22:55 kados you sure? ;-) 22:55 kados ahha ... here it is 22:55 shedges well, the world won't end if we don't have a reserve list tomorrow. 22:55 kados maybe ... although I don't see that in the scripts 22:54 kados ahh ... I think I know one of the probs with owens scripts ... he hardcoded the IP which has changed ... 22:50 shedges owen's biblio frameworks show up in the pull down list on the cataloguing screen, they just default right now to the full MARC framework. 22:49 shedges confusing... 22:48 kados hmmm, james has it bookmarked as reserve_list.php on his machine ... 22:48 shedges intranet-reserve_list.php? 22:47 kados hmmm, reservlist.php isn't even in the same place is it... 22:45 shedges I don't think it's something to do with frameworks. 22:45 shedges they're both php reports... 22:44 kados i wonder if it's related to the frameworks ... 22:44 kados hmmm, we'll have to ask owen about that one 22:43 shedges But now I see "Format Search" (intranet-item_report.php) also doesn't work. 22:42 kados afaik ... 22:40 shedges "Reserve List" won't work until cron does it's thing -- right? 22:36 shedges works now! 22:36 kados ahh ... wrong permissions 22:36 shedges looks like it's pointing to selectbranchprinter.pl 22:34 kados hmmm ... setbranch just threw an error 22:26 shedges sounds good. Nice work, Joshua! 22:25 kados oh ... and I need to make sure that koha.athenscounty.lib.oh.us:8080 points to the right place 22:25 kados afaik the only thing left is swapping out the RAM and getting the self-checkout Vhost up 22:24 kados cool ... have a good evening 22:18 owen I had set up some biblio frameworks, and I'll have to do that again but it's not urgent 22:18 kados cool 22:17 owen Yes 22:17 kados interesting ... so is it fixed owen? 22:17 kados owen did you make the changes to params ... I can't remember exactly what they were ... something to do with frameworks? 22:16 kados kohaadmin should be the same ... 22:16 owen Yep, it was using the biblioitemnumber instead of the biblionumber. And it just happened to work most of the time. I wonder if that bug has been around since we first upgraded the opac? 22:14 shedges looks like it has a new password, i'll call sometime and get that 22:13 kados shedges: you can access mysql on either IP 22:13 shedges seems like it should _never_ work, if that is the case 22:11 owen I'll bet it's a biblionumber/biblioitemnumber thing, and I've got the wrong variable in the template. 22:10 owen The link to the item has the correct biblionumber, but the id attached to the checkbox (for the bookbag) is different 22:10 shedges exit 22:09 owen I did a keyword search for 'scrapbook,' and one of the results was 'Ben Franklin's almanac' 22:08 shedges were they recent adds? old biblios? 22:08 owen The first test I did showed problems, and the second didn't. The third had only one bad one. 22:07 owen That's a strange problem with the book bag...we seem to be getting randomly incorrect biblionumbers here and there 22:07 owen Hmmm... little network hiccup there. 22:03 shedges Do I access mysql on 77? 22:01 kados owen: no ... we're online with the 76 77 addresses ... 66-69 are for test servers 21:58 owen kados: if I'm sftp'ing should I still use the .67 address? .69? 21:56 shedges owen, I think all opac-format-search needs is a little space between "limit by branch" and "limit by copyright date" 21:55 owen Can we have the koha.athens... url still point to the same machine anyway? 21:54 owen and it pointed to the intranet with the 8080 port 21:54 shedges the overdue notice spoint people to koha.athen... I'll need to change that. 21:54 kados ok ... 21:54 owen yes, it did point to the opac 21:53 owen yes 21:53 kados or was that always the intranet interface? 21:53 kados owen did koha.athenscounty.lib.oh.us _ever_ point to the opac? 21:52 kados update: search.athen... and intranet.athe... are working 21:46 shedges Seeing the way you solved some thorny problems (like displaying branch availability), I'm sure you come up with something clever! 21:44 owen Okay. I'll take another look at that. 21:43 shedges thought it looked a little like the whole page was "or" choices, no "ands" 21:42 shedges Cheryl was trying the OPAC and wasn't sure from the page payout if she could choose branch and recent acquisitions 21:41 owen shedges: what do you mean about the copyright "or" recent acquisition parameters? 21:33 shedges (time to play Solitaire for a while...) 21:32 shedges mine too, that machine must be unplugged now 21:31 owen ...but my opac search timed out. 21:31 owen Worked fine. 21:31 shedges (that's a website, sorry -- I guess it could be a W2K command!) 21:26 shedges whatismyip.com 21:26 owen Is there an easy way to find out from the Win2K command prompt? 21:25 kados but he can see the opac (not the intranet tho) 21:25 kados no the switch isn't done 21:25 kados owen what's your IP at home? 21:25 kados yea ... 21:23 shedges can owen see -- is the switch-over done? 21:23 owen The the opac still at .67? 21:23 owen Must be something in the template. 21:22 kados hmmm ... I'll have to check out that book bag error later 21:22 shedges IE still does some funky stuff, too, but I expect that anymore... 21:21 shedges but generally -- you guys DONE GOOD!! 21:21 shedges The book bag doesn't work in the OPAC. (When I choose items to add from the search results screen, it adds entirely different items -- the right number of items, but the wrong items) 21:21 shedges Another owen issue -- confusion over the copyright "or" recent acqusition parameters (or only applies to those two, not the other stuff on that page) 21:20 shedges opac doesn't automatically insert the zeroes in the card number anymore (I think Owen will need to apply Oscar's java script) 21:20 shedges found a few things for your list 21:20 owen What can I do? 21:20 shedges yep, and Joshua's in the process of switching machines (I think) 21:20 owen updatedatabase finally finished? 21:19 shedges we're testing 21:19 owen Hi 21:19 shedges hi owen 21:14 shedges uh -oh The book bag doesn't work in the OPAC. (When I choose items to add from the serach results screen, it adds entirely different items -- the right number of items, but the wrong items) 21:09 shedges I'm going to ask the catalogers to wait until I get there to do their import tomorrow. 21:09 kados ok ... 21:09 shedges sounds good 21:08 kados so my next step would be to pull out the ethernet cords on 77 and 76, configure 69 with those IPs and make sure all our DNS is working the way we expect before I reboot the machines and swap RAM 21:05 kados it's SSLed too ;-) 21:05 shedges (I REALLY like this Intranet!) 21:04 kados that's setup on the new server 21:04 kados ok ... 21:03 shedges yep -- the only one I know of anyway. 21:03 kados so I checked .76 cron and it looks like the only item we run in cron is reservelist.pl ... is that right? 21:03 kados but I tested it 21:03 kados that virtualhost isn't online atm 21:02 kados yep ... already does 21:00 shedges wonder if the self checkout will work... 20:57 kados yea ... looks great 20:57 shedges i'm in intranet, now -- nice! 20:57 shedges yep 20:57 kados yea ... I haven't uploaded the latest copy of that ... is it on .76? 20:56 shedges overduenotices.pl ? 20:55 kados so as far as custom scripts to I've been putting them in /build/utilities/ 20:53 kados owen has some configuration to do in parameters too iirc 20:53 shedges Another owen issue -- confusion over the copyright "or" recent acqusition parameters (or only applies to those two, not the other stuff on that page) 20:53 kados yep just got to APL 20:52 shedges you're back! 20:52 kados yep ... 20:47 shedges (I think Owen will need to apply Oscar's java script) 20:46 shedges opac doesn't automaticallt insert the zeroes in the card number anymore 20:41 kados I'm gonna head to APL ... BRB 20:41 kados ok ... opac is at http://66.213.78.67 and intranet is at https://66.213.78.69 20:41 shedges ok, thanks! 20:39 shedges 65.24.138.126 20:38 kados what does it tell you when you go to whatismyip.com 20:37 kados well ... I'll need to give you access if you're at home 20:37 shedges ah httpS 20:37 kados what's your IP 20:37 shedges refused... 20:37 kados it's https://66.213.78.69 20:36 shedges (what's the end of the IP?) 20:36 kados ok ... 20:36 shedges yep. I'll start with OPAC(?) 20:36 kados shedges: updatedatabase is finished ... ready for testing? 20:34 shedges kados: how much longer? 20:33 rach hi stephen 20:33 kados so ... updatedatabase just finished 20:28 shedges Hi rachel! 19:58 owen The database has been updating for about 12 hours now 19:57 rach oh wow 19:57 owen We're in the midst of a 2.2 upgrade today 19:57 rach hi owen 19:56 owen Hi rach 19:56 rach hello 19:38 owen I've been able to stop by, but I've been pretty busy with family stuff all day, so I'm glad we didn't have a bunch of urgent stuff going on 19:34 kados yep ... I'm bad at estimations 19:33 shedges a..l..w..a..y..s.. 19:32 owen Wow...I guess it always takes longer than we expect 19:31 kados still running updatedatabase 19:30 owen What's the latest? 19:29 kados not there quite yet owen ;-)