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