|kimseong||AndyGore: depends, if you want to truncate table and recover space, use per table, otherwise shared is fine|
AndyGore: easier to maintain all files in 1 place, but cannot shrink the size
|AndyGore||why is it so hard to shrink the size|
|kimseong||AndyGore: not possible to shrink at all|
AndyGore: unless you delete everything and import the data again
|Jonathan25||what is enum ?|
|AndyGore||kimseong: so by using each tabel in its own table space, you could drop the table, delete its table space, then create and import the table again ?|
|Zombie||I have an issue with my Information Schema|
select TABLE_NAME from information_schema.columns where COLUMN_NAME = `BOOK_CODE` OR `TITLE` OR `PRICE` GROUP BY TABLE_NAME ;
#1054 - Unknown column 'TITLE' in 'where clause'
|Zombie||This worked on one of my other databases.|
|chemisus||select TABLE_NAME from information_schema.columns where COLUMN_NAME = `BOOK_CODE` OR COLUMN_NAME = `TITLE` OR COLUMN_NAME = `PRICE` GROUP BY TABLE_NAME ;|
|Jonathan25||I can't auto_increment a column, here is my error I get: Incorrect column specifier for column 'poll_a'|
|L|NUX||alexp : see what archivist said|
|alexp||L|NUX: I thought so too but someone told me that when you hit 500,000 then you can run into issues, really need to optimize etc....|
|archivist||people are running far larger tables, just remember to use good indexes|
|jduggan_||so is there a decent way to replicate just one table??|
or do you replicate a whole db and the slave ignores what data it doesnt want?
|alexp||Do you think one way to manage huge amounts of users is to spread across several databases/servers. So at one point, new users get stored on a different server and database etc....|
|haptiK||Is there a limit to the number of subqueries one can execute within a statement?|
|archivist||alexp yes partition for high use|
|alexp||archivist: makes it harder to manage but it does seem to make sense|
|d-media||archivist: hey do you know how I can do that?|
|archivist||see comments on xaprb's blog http://www.xaprb.com/blog/2007/04/27/mysql-conference-and-expo-2007-day-4/|
|d-media||archivist: hey how could I exclude all rows in a return on a query that another table contains where id = 1 I want to exclude all matching number for blogid on the other table?|
|ghatak1||Hi, how do i search for a table in a db server with large number of databases;|
|d-media||what is a database entity?|
like a table?
|lewis||I am trying to import a database dump from MySQL 4 to MySQL 5. This is the error that I get for one table creation. Any ideas? http://pastebin.ca/465470|
|archivist||PRIMARY KEY ( `id` , `id` )|
by removing my union and creating a join i've narrowed my sql query from 2.7 seconds to 0.0018 seconds.