Hello,
I would like to get some of your input on file systems to use with
mysql. Should I use a journaling filesystem ? Should I choose a
different one based on what I store (log files, myisam dbs, innodb
datafiles, etc ) ? Is there any file system tweaks you recommend ?
TIA
NOTICE: This email
The following does not work, it gives a syntax error.
innodb_data_file_path = ibdata1:10M:autoextend;ibdata2:10240M
I tried this instead and it didn't want to start and mysql crashes, is
it because it expects the data to be located in the 1st datafile ?
innodb_data_file_path = ibdata2:10240M;ib
Ryan Stille wrote:
Paul DuBois wrote:
At 4:40 PM -0600 2/20/07, Ryan Stille wrote:
Is there an easy way to test to see if MySQL already has the proper
tables loaded?
-Ryan
Yes, reload them. :-) After that, they're current! ...
After digging around on the net for a while I found an e
Out of curiousity, what should be done if they results are different. We checked
on one of boxes and got two different results:
SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'),
-> UNIX_TIMESTAMP('2007-03-11 03:00:00');
+---+
I'm not exactly sure what you should do, hence my earlier question about
the empty time zone tables. I get the same (correct) result on both of
my servers - on one of them I've updated the MySQL time zone tables, and
on the other the tables are empty, always have been. Hopefully someone
will
You need to "close" the size of ibdata1 and add the second file ibdata2
with the size you need (and i you like you can even add the autoextend
option, but only to the last ibdata file added)
for example, if you are aproaching the 1gb size on ibdata1, you specify
the maximun size that you want fo
Ryan,
I just restart MySQL on the one box that was off, and bingo ... the 2 results
are now the same. I think the system time zone was changed a while back, so
after restarting, it set it back to the default "SYSTEM" setting.
Mickalo
- Original Message -
From: "Ryan Stille" <[EMAIL P
