INNODB database size

[Todd Smith]

Hello

 I have inherited an INNODB database. I am new to MySQL and may not be
describing my problem correctly so any suggestions or questions are welcome.
I have data files named ib_data_00 through ib_data_14 all of which are 2.0G.
I also have ib_data_15 which is 26G.  I am receiving errors saying that the
innodb space is full.  I know that the space isn't full because it is still
working.  I am wondering how I can get a true size of the space used.  I
would like to get back into the 2G segments. Any suggestions.

Todd


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Show Grants problem

[Todd Smith]

Hello
Does anyone know why a user would show up in a select from user query 
but
not in a show grants command.  What I am trying to say is I tried SHOW
GRANTS FOR 'user1'@'%' and received that there is no such grant defined for
'user1'... But when I run SELECT * FROM user WHERE User = 'user1' I do get
results.  Could the user have been added using an insert causing the SHOW
GRANTS to fail?


Any Ideas

Todd


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]