innodb_file_per_table cost

Hi, Does the use of "innodb_file_per_table" option imply a performance cost ? Compared to default: all InnoDB indexes are in ibdataX file(s). Thanks -- Sébastien Moretti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mys

ibdata1 lost

Hi, Is there a way to recover data and/or database schema when ibdata1 file has been removed (for InnoDB databases) ? (MySQL 5.0.26) Thanks -- Sébastien Moretti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsu

Re: FW: GRANT and ticks or no ticks...

On Wed, May 27, 2009 at 2:05 AM, Daevid Vincent wrote: > So why mySQL is putting back ticks in there even though I didn't, Because it doesn't save your original statements, but recreates an appropriate set from the grant tables. > and more importantly why doesn't the second line say: Becaus

Re: GRANT privileges should check for db.table existence

*shrugs* I, for one, appreciate a tool that doesn't try to be smarter than I am. If I want to be treated like an idiot, I'll use microsoft software. On Wed, May 27, 2009 at 2:38 AM, Daevid Vincent wrote: > I'm a little concerned and disappointed that the GRANT command doesn't do > any sort of c

Re: FW: GRANT and ticks or no ticks...

Start the server with --skip-grants-table. That will disable logins. Then do "delete from mysql.user" and restart :) Walter On Tue, May 26, 2009 at 6:05 PM, Daevid Vincent wrote: > Now I'm really confused. > > I just did this: > > REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'10.10.10.%'; > G

GRANT privileges should check for db.table existence

I'm a little concerned and disappointed that the GRANT command doesn't do any sort of checking (like a foreign key for example) to verify that the database and table exist?! I get the case of *.* but it seems crazy to me that it would allow foo.bar when neither a database named 'foo' nor a table

FW: GRANT and ticks or no ticks...

Now I'm really confused. I just did this: REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'10.10.10.%'; GRANT ALL PRIVILEGES ON mydb.* TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; and then I get this: SHOW GRANTS FOR 'user'@'10.10.10.%'; +

GRANT and ticks or no ticks...

Wondering which of these will work or not? (no quotes) GRANT ALL PRIVILEGES ON mydb.mytable TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; (backticks) GRANT ALL PRIVILEGES ON `mydb`.`mytable` TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; (single quotes) GRANT ALL PRIVILEGES O

dumb crash

Hydro Quebec just f***ed my server just as I was booting up three machines; XP is ok, FreeBSD 7.1 is the one with mysql problem, FreeBSD 4.10 - don't know, but boots ok. Result: can't access database. One table seems to abort mysqld. PhpMyAdmin connects to all databases except one. mysql> CHECK TA

RE: Understanding Transaction Deadlocks with Innodb

Hi Martin, Sorry my example wasn't clearer. I am doing a commit or rollback depending on the success of the overall transaction. What I don't do is retry parts of the transaction upon deadlock. Thanks for pointing that out, though! Best, Mike On Mon, 2009-05-25 at 16:46 -0400, Martin Gaint

Re: I need some example

Sorry ya, not for my project , just i wat to know Thanks 2009/5/25 Martin Gainty : > cannot help with implementation details unless we see your DB schema e.g. > mysql>use DB > mysql>show tables > msqyl>desc table1 > mysql>desc table2 > > Martin Gainty > _