#mysql - Fri 20 Apr 2007 between 06:17 and 06:50

NY Lost Funds



Wulf_no, 2.5gb
err.. 2.5mb
Desinethat's great
2 million records only 2.5mb :)
mrgibsonHi, on one server, I do a Select on 2 differnt database in same time, on my ISP server, its not working, does MySQL have a configuration item to disable this feature?
Wulf_sorry.. read `,' as `.' of course 2,395 MiB is 2.5GB
in German , and . have reversed meaning..
Desineah damn
Wulf_mrgibson: do you get an error message?
mrgibsonyup
Wulf_mrgibson: different mysql versions?
mrgibsonI dont know, I have not checked yet
but something like SELECT FROM database.table do not work anymore
chadmaynardshow grants; on each
schnoodlesanyone know how to make a whole InnoDB table have utf8 support
mrgibsonI have 2 different settings with grant
my local server say GRANT ALL PRIV ON *.*
my ISP server say GRAND USAGE ON *.*
and GRANT SELECT,INSERT,UPDATE,DELETE,DROP for each database
ekimus!man inheritance
the_wenchSorry - I have no idea what function you're talking about! but try http://dev.mysql.com/inheritance
ekimus!man create table
the_wenchsee http://dev.mysql.com/doc/refman/5.0/en/create-table.html
ekimusdoesn't mysql support support table inheritance?
mrgibsonlook like I need to do multiple connections for each database
ZzimmYYi get dovecot: imap-login: Disconnected: trying to connect to it ?
mikedld|whi there
is there any way to get size of data stored in BLOB than LENGTH()?
Clackwellmikedld|w: other than you mean?
or like?
mikedld|wyes
other than
LENGTH() takes too much time...
chadmaynardusually you store the size upon insert
mikedld|wI can't believe this number isn't saved somewhere to quickly fetch it...
Clackwellmikedld|w: really? odd. i don't see a reason for it taking a lot of time, but i am thinking in terms of another db engine. maybe store the size in the same table ?
mikedld|w: yeah, you'd think mysql would keep it around for general purposes in the first place.
mikedld|wI can't store size since I'm not a developer but QA engineer
Clackwellmikedld|w: in another db engine with blob support you can select the blobs, get the "id" of each blob and can that way locate the file containing the blob data. getting it's size is easy at that point.
no clue about mysql though, sorry.

Page: 2 9 16 23 30 37 44 51 58 

IrcArchive

NY Lost Funds