|moqq||anyone 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 ?
|setuid||Is 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?
|tupa||excuse 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
|Will||It's called "Overhead"|
Run OPTIMIZE TABLE on them
|Tu13es||how do I drop all tables from a db without dropping the db or typing out all the tables by hand?|
|Will||Why can't you drop the DB?|
|Tu13es||I can't create db's on the server I'm on atm|
I can drop it, just can't make a new one :P
|Will||You'll have to do by hand|
|setuid||Hrm, InnoDB can't support fulltext indices?|
That's... going to suck.
tupa, phpMyAdmin is flawed, don't use it
Anyone know were I can order that mysql certification book
|GeekinBox||is a mysql cluster faster than a type memory database?|
|NefariousPrior||Is it just me or is the download of mysql very hard to find on the mysql site?|
|setuid||Shaba2, which book?|
|Shaba2||I do not remember the specific title|
somone here told me about it.
|setuid||Shaba2: What is the topic material?|
msbhvn, It corrupts utf data
|cld2||if 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?|
|setuid||cld2, No need to make a new table, just create new rows|
|cld2||so 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.
|setuid||Just add a row with a datetime attribute, and populate the other fields|
|cld2||setuid: ok thanks.|