InnoDB support transaction. MyISAM does not support trantsaction.
http://www.databasejournal.com/features/mysql/article.php/3382171/Transactions-in-MySQL.htm
2010-05-04
Best regards
Timo Seven
blog: http://zauc.wordpress.com
#请翻墙浏览，或者指定hosts到74.200.243.252###
twitter: https://twitte
I think you've got it a little wrong. In MySQL, transaction log is different
from bin-log. Transaction logs are used only for Innodb while bin-logs are
optional and capture data related to all the storage engines. I believe, you
cannot read thru the transaction logs and these logs files (used in
Please help me to understand more about the mysql transaction log (
mysqlbinlog) file and its contents. Will it support only the innodb or all
the storage engine types like MyISAM, InnoDB?
Thanks,
Arsh Paul
On Mon, May 3, 2010 at 11:20 AM, raju.sakineti wrote:
> HI everyone,
>
>
> could somebody help me on how to do capacity planning for mysql
> databases. if anyone have documentation please provide me.
>
>
>
>
> thanks®ards
> varma
>
http://www.amazon.com/Art-Capacity-Planning-Scaling-Re
HI everyone,
could somebody help me on how to do capacity planning for mysql
databases. if anyone have documentation please provide me.
thanks®ards
varma
It works great for me. After working out the bugs and adding the spatial
index I am now searching in the 0.05 second timeframe vs. minutes
otherwise.
Dan
On Sun, 2 May 2010 23:39:41 -0700, Rob Wultsch wrote:
>> >>> On Sat, May 1, 2010 at 11:12 PM, dan wrote:
>> >>>
>>
On Sun, May 2, 2010 at 11:50 PM, Junior Ortis wrote:
> Hi guys, i have a server with 20GB InnoDb on a single database and i
> use just one user for its. I use mysql 5.4
>
> 1- If i change my SCSI 15k RPM to a SSD i will increase my performance ?
Umm, maybe. More information is required. Does the
