| 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 ? the type. |
| kimseong | !man enum |
| the_wench | see http://dev.mysql.com/doc/refman/5.0/en/enum.html |
| 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' |
| chemisus | yea |
| 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' |
| Zombie | OH! |
| Jonathan25 | !man specifier |
| 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? |
| haptiK | Hello. |
| 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` ) |
| haptiK | holy cow by removing my union and creating a join i've narrowed my sql query from 2.7 seconds to 0.0018 seconds. thats ridiculous |