#mysql - Sun 4 Mar 2007 between 00:04 and 00:59

NY Lost Funds



moqqanyone know the most efficient way to, using mysql spatial extensions, do a distance constraint? (i.e. select only points within a distance d from point p)
and would using their r-tree spatial index help ?
setuidIs there a way to find out which of my dbs is InnoDB and which are ISAM?
Or more succinctly, find out what data is in ibdata1, so I can clean/purge it?
ibdata1 is 691 megabytes, but ALL of my databases together, are only 346 megabytes... so what is in this file?
tupaexcuse me, but in phpmyadmin I get a Residue to purify or something like this
why does this appears?
or depurate I dunno, my phpmyadmin is in spanish
this is in used space
in a table
I get data, index, residue, effective, and total
WillIt's called "Overhead"
Run OPTIMIZE TABLE on them
Tu13eshow do I drop all tables from a db without dropping the db or typing out all the tables by hand?
WillWhy can't you drop the DB?
Tu13esI can't create db's on the server I'm on atm
I can drop it, just can't make a new one :P
WillYou'll have to do by hand
Tu13esyippee
will: thanks
Willnp
setuidHrm, InnoDB can't support fulltext indices?
That's... going to suck.
tupa, phpMyAdmin is flawed, don't use it
Shaba2Hello all
Anyone know were I can order that mysql certification book
GeekinBoxis a mysql cluster faster than a type memory database?
NefariousPriorIs it just me or is the download of mysql very hard to find on the mysql site?
setuidShaba2, which book?
Shaba2I do not remember the specific title
somone here told me about it.
msbhvnsetuid: howso?
setuidShaba2: What is the topic material?
msbhvn, It corrupts utf data
cld2if I have a list of files from a backup each day and I want to store those files would it be bad to make a new table for each day?
setuidcld2, No need to make a new table, just create new rows
cld2so just date stamp each entry and insert it all into one master table?
sorry for the stupidity. scheme design is something I know nothing about.
setuidJust add a row with a datetime attribute, and populate the other fields
cld2setuid: ok thanks.

Page: 2 9 16 23 30 

IrcArchive

NY Lost Funds