…? What version is this? Did you install from packages? What does the error log say and what exactly does does not let me make connections mean? Also…
Post: Sysbench evaluation of iSCSI performance
July 6, 2006 By 2 Comments
… not fully described which makes it hard to judge what they really mean. Was it OLTP test or some other combination ? Was… than Serial ATA on large numer of connection could actually mean it is faster – regression with many threads often happens with… would also be especially careful making sure iSCSI driver peoperly does fsync() otherwise loosing database content might be the price for…
Comment: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
January 7, 2013 By 10 Comments
… writes into the transaction log. > 3. What does it variable mean of Innodb_buffer_pool_pages_flushed, does it in buffer pool to flush dirty pages then count one after flushed? Yes. > what… file correctly. The second part of your question is about what happens when you have a big transaction and very small…
Comment: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
December 29, 2012 By 10 Comments
… transaction log, isn’t it? 3. What does it variable mean of Innodb_buffer_pool_pages_flushed, does it in buffer pool to flush dirty pages then count one after flushed? what…
Comment: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
Jay – good summary, what you are thoughts on RAID stripe size? I had a … that is < RAID stripe size, in this case 256k. Does this mean that the RAID controller is not going to cut the… in parallel the across two drives? In my mind and what I have read, increasing the RAID stripe size typically doesn…
Comment: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…. What do you mean by “0. Create empty InnoDB tablespace.” ? > Must I import .ibd into an empty database ? In this case ibdconnect does not need to check if the space_id is already used, am I right ? “0. Create empty InnoDB tablespace.” means…
Post: MySQL Optimizer team comments on TPC-H Results
April 14, 2008 By 1 Comment
….0 SubQuery optimizations are non existent or priorities were wrong, what I’m saying is just they do not seems to… well known set of complex queries which use SubQueries. So what is the reason ? Why TPC-H queries are not targeted…. Summary: Poor MySQL 6.0 performance on TPC-H queries does NOT mean to quantify MySQL Optimizer Team work in any way:)
Comment: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… but instead to show how you can measure performance and what numbers you should look at. I just used the box…. What particular workload you’re speaking about and what storage engine ? For MyISAM it well may be the case because it does not…’re likely to use. I am also not sure what do you mean by outstanding writes are not lost on the crash…
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
…, upping this can improve performance” which is cool but it does not really tell you how exactly read_rnd_buffer_size… will stop fetching rows by pointers quickly For me this means since MySQL 4.1 this option is used in narrow… longer than max_length_for_sort_data it would frequently mean there are some TEXT/BLOB columns among them. It would…
Post: Upcoming Webinar - "Deploy MySQL Like a devops SysAdmin"
October 25, 2012 By Leave a Comment
… at least everyone is talking about it. But what does that really mean? And how does the DBA integrate the movement ? During next week…
