| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<Kemurii> basvg: you did 'CREATE DATABASE wordpress'? better do ... ON wordpress.* TO ...
<basvg> Kemurii: yes, I did a create database wordpress... when I log in as root then I can simply use the database no problem
<SpComb> hmm
<basvg> Kemurii: ok, the .* fixed my problem
<basvg> Kemurii: thanks a lot... I'd better read the docs to figure out why the .* is necesssary
<Darien> because they're table permissions
<Cereal> hey problem
<Cereal> if i run this querry: INSERT INTO usergroup_has_task (task_fk_id, usergroup_fk_id, access) VALUES (1,2,0001)
<Cereal> and the access field is a binary(4) type
<Cereal> its stored as 1\0\0\0
<Darien> hmm
<Darien> !man binary
<SQL> (Overview of String Types) : http://dev.mysql.com/doc/mysql/en/String_type_overview.html
<Kemurii> basvg: hehe, yeah, .* is funky huh :)
<SpComb> I've set all the memory things in my.cnf to low values, but each mysql process still eats 14m of memory
<SpComb> considering there are 10 mysql processes and I have 64m ram...
<Cereal> Darien, i have read that page
<Darien> ok
<SpComb> well, RES is 14m for each process
<Darien> I'm reading that page
<Kemurii> basvg: when you don't specify it, it sees it as a table, not a database.... foo.* is all tables in the database foo
<Kemurii> SpComb: no, not true
<Kemurii> SpComb: what you see is threads, and the 14m is the mother process
<SpComb> top shows threads?
<Kemurii> SpComb: this is when you use LInuxThreads, ps output shows the threads as processes, but that is mostly a hack
<Kemurii> SpComb: if you use NPTL threads library, you would only see the mysqld_safe and the mysqld process
<SpComb> well, there are 10 different PID:s
<basvg> Kemurii: thanks for the update!
<basvg> well, off to bed
<basvg> night all
<Kemurii> SpComb: yes, like I said
<Kemurii> bb bashusr
<Kemurii> bb basvg
<SpComb> so doesn't that mean 10 different proccess and thence ten dfferent memory spaces?
<Darien> no
<Kemurii> SpComb: MySQL uses 14Mb so to speak.. the threads are not using additional 14Mb, but maybe more or less, depends what the per connection memory allocation is, and the usuage
<Darien> an updated kernel will show it as one process
<Kemurii> not updated kernel
<Kemurii> dependign on whether you use LinuxThreads or NPTL
<SpComb> eek...
<SpComb> so there are ten threads you say?
<Kemurii> more modern distro's use NPTL, but LinuxThreads is available still... LD_***UME_KERNEL=2.4.1, IRRC
<SpComb> and one mysql process with 14m mem?
<Kemurii> SpComb: no reason to panic, normal **** :P
<SpComb> well, it looks as if it had 140mb mem (although there is only 66mb in use)
<SpComb> so not panicing, but this is a bit silyl
<Kemurii> SpComb: 14Mb is used
<Kemurii> SpComb: things you learn :)
<SpComb> indeed
<SpComb> so top displays threads?
<Kemurii> SpComb: like an apache is forking processes (by default), so there the memory utilisation for each process of Apache is important etc etc
<Kemurii> if you use NPTL on RedHat for example, you can do 'ps -eL -u mysql' to see the threads too
<SpComb> hmm
<domas> Kemurii: !!
<Kemurii> domas!!!!!
<domas> helloo!
<Kemurii> domas: fixed me wiki with lighttpd :)
<domas> woo, nice!
<domas> was there anything to fix?
<Kemurii> rewrite rules
<Kemurii> http://wiki.some-abstract-type-****.com/Tech:Lighttpd#Rewrite_rules_for_MediaWiki_in_Lighttpd
<domas> ah, you could just set 404 handler for a directory
<Kemurii> maybe I'll add to mediawiki docs, not sure yet :)
<domas> um, this jazzanova cd has nice tracks....
<SpComb> so mysql has one-two processes (with 14m mem use), and then one of those has ~10 threads?
<domas> SpComb: mysql has once process.
<domas> another might be just a shell wrapper
<Kemurii> okok, laters, off now :)
<SpComb> how confusing
<domas> that is, 'mysqld' is one process
<domas> mysqld_safe might be another
<domas> or instance manager
<domas> or mysqld_multi
<SpComb> I wonder how much ram one can stick in a two-SDRAMIMM slot
<SpComb> -IMM
<archivist> antique (as a few where)
<zobi1> is there something wrong with hashmysql/pastebin? I have been trying to post my query there(http://hashmysql.org/paste/index.php) and every time I submit the form I get back an empty page.
<_m0O> use pastebin
<zobi1> that is the pastebin right?
<zobi1> http://hashmysql.org/paste/index.php
<Duesentrieb> there are several pastebin sites
<Duesentrieb> use another one if this one does not work for you
<Duesentrieb> for example, http://pastebin.com
<Duesentrieb> (which m00 probably meant)
<zobi1> ok,thx
<WaterPoloGuy23> any resouce i can know from about java.sql.Date and java.util.Date compatibility??
<Duesentrieb> WaterPoloGuy23: they are not compatible in the OO sense. But both have methods to get the unix timestamp, and both can be constructed from such a timestamp.
<Duesentrieb> so, yo can easily convert on into the other
<Duesentrieb> (i think sql.Date even has a constructore that takes a util.Date)
<zobi1> can someone help me with left outer join here-> http://zobi.pastebin.com/663817
<Duesentrieb> zobi1: oh ****... uh, what are you tring to do, write a cgi script in nothing but sql?
<Duesentrieb> it sure is possible, it just sounds... insane. and poinles.
<Duesentrieb> can you reproduce your problem with a bit less clutter, like without all the replace stuff?
<zobi1> :) it is an indexer. I am just trying to edit it.
<Duesentrieb> uh, what do you mean it "hangs"?
<Duesentrieb> "hanging" usually means "its doing a lot of work"
<zobi1> well, the query works fine except when I add that bit of left outer join. When I run it mysql never comes back.
<zobi1> exactly, I have to restart mysql
<Duesentrieb> you probably only have to kill the client.
<Duesentrieb> and when you open another client and say "show processlist", you will probably see doing some work
<Duesentrieb> a big join can easily take days
<zobi1> I used phpmyadmin the first couple of times. now I am in the shell.
<Duesentrieb> it all depends on how big your tables are, what indexes are in place, what conditions are evaluated first, etc
<Duesentrieb> run the query, open a second mysql client in a second shell, type SHOW PROCESSLIST;
<Duesentrieb> otoh...
<zobi1> ok, will try that now
<Duesentrieb> do an EXPLAIN on your query, it may tell you why it's slow
<zobi1> hmm, I might be missing the index on the table I am joining.
<zobi1> no I am not missing an index
<Duesentrieb> have a peek here: http://dev.mysql.com/doc/refman/5.1/en/explain.html
<Duesentrieb> anyway, off to watch a movie
<Duesentrieb> bbl
<zobi1> thx
<_m0O> which movie?
<\zxc> This might be offtopic but: Anyone familiar with upgrading php to use the mysqli extension on a RHEL server with Plesk installed?
<osfameron> \zxc: it's not entirely offtopic, but you might be better off asking your question (here or in #php or similar) than asking for specific people
<M3> hi all!
<\zxc> osfameron: Okay, my question was: How? :P
<osfameron> \zxc: well, I don't know php or RHEL :-) but my first question would be "how do I get php installed with mysqli extension?"
<osfameron> do you already know how to do that (and are having problems with RHEL/Plesk) or is your problem with the first part?
<\zxc> osfameron: I know how to install php with the mysqli extension, however Plesk is also on the server, and I don't want to mess it up.
<osfameron> googling for php and mysql, suggests you need to compile php with --with-mysqli=...
<osfameron> ah, ok
<\zxc> I googled a fair bit.
<osfameron> what is Plesk, and why are you worried it will mess it up?
<\zxc> Plesk is a server management tool/control panel.
<osfameron> right, and what happens when you upgrade on your dev box? :-)
<\zxc> http://www.swsoft.com/en/products/plesk8/
<\zxc> The box I was developing on is Windows, without Plesk, and I already had the mysqli extension installed fine.
<osfameron> \zxc: right, so you are a 3rd party developer developing a solution for a client who doesn't have a test instance for you to try your application on?
<\zxc> er, there is a backup RHEL server for testing, but Plesk is rather expensive and isn't installed on that server :P
<osfameron> hmmm, silly Plesk if they are charging people to run it on their test server too
<\zxc> Agreed.
<osfameron> well, the requirements page on plesk doesn't suggest it will fail to work if PHP has mysqli compiled in
<osfameron> and if they company is paying plesk for their software, it occurs to me you would probably be able to log a support ticket with them to ask for info
<osfameron> but the best thing would be to run on a staging server, actually that's probably the only sane thing to do
<\zxc> Good points.
<\zxc> I'll wait for the sysadmin to appear and ask him to fix it.
<\zxc> And slap him for not having mysqli there in the first place. :)
<osfameron> hehe
<osfameron> we have a wonderful setup with a cluster of blades all of which are completely different
<osfameron> so depending on which server ends up servicing your request, it may or may not have the right perl modules, c libraries, etc.
<\zxc> haha
<\zxc> fun fun
<osfameron> and when we request new stuff, we have to say which servers to roll it out to
<\zxc> "all"
Return to
#mysql
or
Go to some related
logs:
#python
#perl
#gentoo
ubuntu rt2600
#perl
centos Accton EN1207D
90x96 dpi gnome
xpad cedega ubuntu
#ubuntu
suse dvb-utils repository
|
|
