Time Nick Message 10:23 kados use lib '/build/koha'; 21:43 rach hi 21:05 rach hey 20:46 kados hey rach 20:39 rach howdy 20:37 chris excellent :) 20:36 kados and leaves the last two issued alone 20:36 kados hehe :-) 20:35 kados it cleans up issues real nicely 20:35 kados I just found a script I forgot I wrote 20:24 chris not sure if it does anymore 20:24 chris well it did .. on the moredetail.pl page 20:24 chris yep it does i think 20:18 kados does Koha query issues to find the last person who borrowed an item? 20:18 kados before I run this 20:14 chris better safe than sorry :) 20:14 kados that's what I did last time ;-) 20:14 kados right 20:14 chris maybe 20:14 chris cos null is less 20:14 chris and returndate is NOT NULL 20:14 kados does that query look right to you? 20:14 chris sweet 20:13 kados I've got a backup of the whole db and the issues table 20:13 kados scary ... I think last time I did this I mucked it up 20:13 kados issues 20:13 kados delete from issuse where returndate < "2005-04-01"; 20:12 chris :) 20:12 kados that's more like it ;-) 20:12 kados 26326 20:12 chris the % might be throwing it off 20:11 chris select count(*) from issues where returndate > "2005-04-01" 20:11 chris id try 20:11 kados that seems like an awful lot 20:11 kados 459336 20:11 kados select count(*) from issues where returndate > "2005-04%"; 20:11 kados huh ... something doesn't look right here: 20:08 chris i figure slashdot wouldnt use them if they were slow 20:08 chris yep 20:07 kados It'd be great if there was even just a 10% increase in speed 20:07 kados yea ... 20:06 chris the more i hear, the better they sound :) 20:06 kados right 20:05 chris so instead of having to find the new value each time, it has that in ram already 20:05 kados ahh that makes sense 20:05 chris yeah it writes on inserts 20:04 kados ahh ... so it does eventually write it to the table? 20:04 chris cos it doesnt have to check the table each time 20:04 chris basically means inserts are faster 20:04 chris but update the table when it needs to 20:04 chris so it keeps a counter in ram 20:04 chris InnoDB increments the counter by one and assigns the new value to the column. 20:02 chris that should be ok 19:58 kados http://dev.mysql.com/doc/mysql/en/innodb-auto-increment-column.html 19:58 kados hum ... handling of autoimcrement seems problematic unless I'm mis-reading 19:49 kados that's what I'm thinking 19:49 chris that buffer pool can only be good 19:49 chris nice 19:48 kados Fully integrated with MySQL Server, the InnoDB storage engine maintains its own buffer pool for caching data and indexes in main memory. InnoDB stores its tables and indexes in a tablespace, which may consist of several files (or raw disk partitions). This is different from, for example, MyISAM tables where each table is stored using separate files. InnoDB tables can be of any size even on operating systems where file size is limited to 2GB 19:48 kados huh: 19:48 kados Slashdot.org runs on InnoDB 19:48 kados yea ... I'm going to give it a shot this weekend on a test machine 19:47 chris certainly worth trying 19:47 chris hmm that might make for a nice speed increase 19:47 kados I didn't realize myisam did read locking 19:46 kados InnoDB does locking on the row level and also provides an Oracle-style consistent non-locking read in SELECT statements. These features increase multi-user concurrency and performance 17:52 kados more friendly than ever ;-) 17:52 chris sweet 17:51 kados and it takes me to a bio 17:51 kados so I hit wikipedia 17:51 kados only two titles ... and nothing ABOUT isaac asimov 17:51 kados Click 17:51 kados it says 'did you mean: Isaac Asimov?" 17:51 kados I type in 'isac asimov' 17:50 kados so this is pretty cool 17:34 chris heh 17:34 kados oops ;-) 17:33 kados msg chris one broken link 15:45 shaun gtg, bye 15:40 kados in fact, it's probably the only way to do it well 15:38 shaun (thats what i was suggesting would be easier...) 15:37 kados then copy over your database 15:37 kados in that case you should install it using installer.pl 15:37 kados ahh ... so you don't have koha installed currently 15:35 shaun because I don't have the database on my hd atm, and need all of the perl modules (i have copied and pasted from nfs, not installed via installer.pl) 15:35 Ben bye 15:35 Ben gtg 15:34 Ben or pointed out, e.g. *sarcastic* would it be easier to reinstall your OS? 15:34 Ben (shaun and I are not good with sarcasm unless it is conveyed in some physical way) 15:33 kados you've already got Koha installed ... why would it be faster to re-install it? 15:29 shaun ??? 15:29 kados re-installed ;-) 15:29 kados would it be easier if you installed your OS? 15:26 shaun why not? 15:25 kados nope 15:24 shaun would it be easier to do a fresh install of koha, and then copy the database across? 15:20 kados shaun: so first delete /var/lib/mysql/Koha 15:20 kados shaun: man scp 15:19 shaun what does scp -r do? | i do want to overwrite, this box's koha is currently unpopulated 15:19 kados then you will probably need to muck about with permissions a bit 15:19 kados unless you want to 15:19 kados (so you don't overwrite existing db ;-) 15:18 kados scp -r Koha /var/lib/mysql/Koha2 15:18 kados if Koha's there 15:18 kados cd /mnt/hdb7/var/lib/mysql 15:17 kados right so 15:17 shaun second hard drive mounted on /mnt/hdb7, which is mirrored on nfs, mounted on this box... 15:16 kados the import the resulting file into your new system 15:16 kados and run mysqldump 15:16 kados otherwise you'll need to boot of the other system 15:16 kados to your new system and it should work 15:15 kados you can copy over /var/lib/mysql/Koha 15:15 kados provided they were running the same version of mysql 15:15 kados shaun: you'll need to mount your second hard drive 15:13 shaun I already have all of the koha files (/usr/local/koha), and the httpd and mysql config, but not data, are identical 15:11 shaun but that still leaves out the mysql *data* - the two systems are separate, and mysqldump will not find the database, afaik - it is in a different daemon etc 15:10 shaun basically, it has two systems on two hard drives on one server (hda: default, production stuff, hdb: the new one that i plugged and played, which used to be in this box, serving koha) 15:10 kados grab conf files (like httpd.conf, my.cnf, etc) and you should be good to go 15:09 kados targzip your /var/www/ directory (or wherever your web files are) 15:09 Ben they just took avantage of its amazingness to make their own design 15:09 Ben shaun, ubuntu definitely use plone 15:09 kados right ... so you can just mysqldump all your databases 15:08 shaun o soz, you did... the production server is hosting all websites, no koha 15:08 kados mysqldump should take care of it 15:08 Ben there was a version of gentoo which used anaconda.. 15:08 kados shaun: yea ... i think I already responded no? 15:07 shaun kados: any ideas for the mysql thing? 15:05 shaun *stands up for gnome* try the optimisations. 15:04 Ben am I the only one here who experiences mental experiences of texture when using widgets? 15:03 Ben it is still unresponsive 15:03 shaun ben: same as me - you should not be experiencing any problems, imo 15:02 shaun i find that xfce's file manager is *stupid* 15:02 Ben 512mb ddram with an athlon xp 2400+ 15:02 shaun ben: what ram and proc do you have? 15:02 shaun also: i turned off bluecurve and used clearlooks instead 15:01 kados I use xfce 15:01 Ben I used kde, it is rather more responsive in the widget dept than gnome, but still, bluntly, a piece of bloated crap 15:01 shaun *that* 15:00 shaun ever used kde? you won't like tht :D 15:00 shaun before that, applications and actions loaded instantly 15:00 kados ntsysv is a nice util for this 15:00 shaun after rebuilding the gnome rpms (took about 2 hours) with arch-specific optimisations (for athlon-xp, -O2 etc), gnome is more responsive than ever 15:00 kados try not starting services you don't need 14:59 kados have you optimized it at all? 14:59 Ben and it makes the system feel soft & squidgy 14:59 Ben clicking applications means a few microseconds more to wait than clicking start 14:59 Ben shaun, gnome in general is unresponsive 14:58 Ben I am not a complete retard, I nearly installed gentoo once, but for some reason grub wouldn't load 14:58 shaun ben: what's slow about it once it's booted? 14:58 kados right ... you'll need to do that too 14:58 shaun in /boot/grub/grub.conf is the line from which one must remove rhgb (talk like yoda one must for sentence structure) 14:58 Ben I know what ubuntu is... 14:58 kados k 14:58 Ben I know 14:58 kados ubuntu is a linux distro ... it's pretty nice 14:57 kados xfce is a really fast desktop 14:57 Ben to boot 14:57 Ben any opinions on Ubuntu? 14:57 kados use xfce 14:57 Ben I do wish to retain the graphical stuff, but I don't want it to be as slow 14:57 kados shaun: the graphical boot doesn't load 14:57 kados shaun: huh ... that's the way all my systems are setup 14:56 shaun (good old redhat, always unique...) 14:56 Ben I tried copying the firefox application data folder across, but it just screws up chrome 14:56 shaun kados: it isn't like that - doing that defeats the object, as the system will boot, load the graphical boot, and then return to the white on black terminal 14:56 Ben hmm 14:55 kados that's pretty easy too ;-) 14:55 Ben If I reboot into fc3, I will need to reinstall all of my firefox extensions and transfer over my bookmarks, history & settings somehow 14:55 kados shaun: do you mean just the Koha database? 14:54 shaun the problem is that my server is running fc2, with a totally different data system (its my production server) 14:54 kados id:3:initdefault: 14:54 kados to 14:54 kados id:5:initdefault: 14:54 kados change 14:54 kados Ben: go to /etc/inittab 14:53 kados to transfer it you might want to gzip it up 14:53 Ben will do.. brb 14:53 Ben but really I am no good at linux use 14:53 shaun ben: remove "rhgb" from boot 14:52 kados mysql Koha < koha.sql 14:52 kados shaun: then on the new machine 14:52 Ben I tried, with the services 14:52 kados Ben: you can change that ;-) 14:52 kados mysqldump -uroot -pyourpassword --add-drop-table Koha > koha.sql 14:52 Ben booting takes about as long as windows does, and then it loads the graphical booter 14:51 shaun how do? 14:51 kados so ... transferring the database is pretty easy 14:51 shaun | ben, find me a package for which there is not some form of fc3 rpm... 14:51 kados right 14:51 Ben plus it is unstable and very slow 14:51 shaun that is: without booting up on the old hd and doing a dump? 14:51 Ben how common are the packages? for example, installing software is a nightmare on fc3, for which not much software is packaged 14:50 shaun well, my hard drive which had my koha installation on is on another box - is it possible to transfer the entire mysql system (obviously, I have /usr/local/koha sorted) over to this box, running the same version of mysql? 14:50 kados i guess it's main feature is really robust packaging 14:49 kados what's it like? 14:49 Ben what is debian like, btw? 14:49 kados what's your question? 14:48 shaun is anyone here good with mysql? 13:57 shaun chances are you're not reading this, but... thanks, rach 13:56 shaun hi again *staying with 2.6.10 for a while...* 12:37 shaun brb, loading up new kernel... 12:34 shaun (was that about performance or redhat stuff? 12:34 owen Nothing in particular 12:31 shaun hi all (what was the significant topic yesterday again?)