Hi,
You can convert the tables themselves semi-online. Just do
set global innodb_file_per_table=1;
and no a no-operation alter on each table with alter table tablename
engine=innodb;
Note that the global variable is just a default, the currently connectd
threads will use the shared tablespace
Thanks, Rolando!
It's kind of a scary procedure (dump, drop, reload) that involves significant
down-time, but I guess it's necessary.
On 11 Feb 11, at 10:24, Rolando Edwards wrote:
> I wrote an article in www.stackoverflow.com about how to convert absolutely
> every InnoDB table to .ibd and pe
I wrote an article in www.stackoverflow.com about how to convert absolutely
every InnoDB table to .ibd and permanently shrink the ibdata1 file
http://stackoverflow.com/questions/3927690/howto-clean-a-mysql-innodb-storage-engine/4056261#4056261
Enjoy !!!
Rolando A. Edwards
MySQL DBA (SCMDBA)
1
Dump the entire DB, drop the DB, restore the DB.
On Fri, Feb 11, 2011 at 11:53 AM, Jan Steinman wrote:
> Our incremental backups seem to be filling with instances of ib_logfile1,
> ib_logfile2, and ibdata1.
>
> I know that changing a single byte in a single INNODB table causes these
> files to b
Our incremental backups seem to be filling with instances of ib_logfile1,
ib_logfile2, and ibdata1.
I know that changing a single byte in a single INNODB table causes these files
to be "touched."
I put "innodb_file_per_table" in /etc/my.cnf, but apparently, that only causes
new databases to be
> From: David Brian Chait
>
> No, what he is suggesting is that you use Access or MSSQL, and link Mysql to
> either platform via ODBC so that you can use it indirectly.
Can someone recommend a good ODBC tutorial or reference?
I've tried a couple times to tie things together with it, and always
log(2, no_of_jobs + 1) will give 0 for 0 jobs, 1 for 1 job, 1.58 for 2 etc. etc.
On 11 Feb 2011, at 14:04, Johan De Meersman wrote:
> How about the square root of the number of jobs, or some other root if you
> want another coefficient? That doesn't have the limiting behaviour a
> logarithmic fu
How about the square root of the number of jobs, or some other root if you
want another coefficient? That doesn't have the limiting behaviour a
logarithmic function offers, though.
On Fri, Feb 11, 2011 at 2:08 PM, Richard Reina wrote:
> Hi Travis,
>
> This is very helpful thank you. Howev
Hi Travis,
This is very helpful thank you. However, is there a way to make it not be
less than a 1. As it's written below someone with one job gets a zero and
someone with no jobs gets a NULL. It would be great if someone with 1 job
got a 1 and someone with zero jobs got a 0.
Thanks again,
R
I accidentally drop the database mysql. I now cannot restore tables to the
database or do much of anything some details can be found here
http://serverfault.com/questions/234321/i-accidently-dropped-the-mysql-db/234340#234340
after a few unsuccessful uninstalled/reinstalls i wrote whereis mysql an
The only case in which you recover automatically the disk space is with
MyISAM tables,
In case of other storage engines is depending on the specific engine.
And the only guaranteed way to have new optimized tables is *full* dump and
reload.
Rolando link is good.
Cheers
Claudio
2011/2/11 Rolando
11 matches
Mail list logo
