LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-20-2010, 01:29 AM   #1
Stephan_Craft
Member
 
Registered: Jul 2008
Posts: 184

Rep: Reputation: 30
show variables like 'innodb_flush_method'; empty


Hi,

when I check mysql innodb_flush_method it's empty. is it normal?
 
Old 02-28-2010, 10:36 PM   #2
rigor
Member
 
Registered: Sep 2003
Location: 19th moon ................. ................Planet Covid ................Another Galaxy;............. ................Not Yours
Posts: 705

Rep: Reputation: Disabled
AFAIK, yes, it's normal. Here's the supporting documentation produced by running the command:

info mysql

if your mysql related files are complete and properly installed. Then navigating to:

storage-engines==>innodb==>innodb-parameters

then search for innodb_flush_method, this is the info for linux:


*Permitted Values *
*Type* (linux) `enumeration'
*Default* `fdatasync'
*Valid Values* `fdatasync',
`O_DSYNC',
`O_DIRECT'



Formerly it was possible to specify a value of `fdatasync' to
obtain the default behavior. This is no longer possible as of
MySQL 5.1.24 because it can be confusing that a value of
`fdatasync' causes use of `fsync()' rather than `fdatasync()' for
flushing.

So AFAIK, the default is to have no value for that parameter.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Bash Script: parse active process stderr, strip, dump into variables, use variables TimeFade Programming 1 02-13-2010 06:09 AM
Samba shares show empty folders Venefyxatu Linux - Wireless Networking 8 06-18-2008 01:50 AM
Gentoo VNC, empty dialog box !! "Question" window is empty ! TheHushedCaskeT Linux - Software 0 02-01-2005 10:14 PM
netatalk shares always show up empty lukebeales Linux - Networking 4 01-09-2004 10:33 PM
Redhat Linux 6.2 – Email Delivered to Server but POP3 and IMAP Mailboxes show empty. RCorbet Linux - Software 0 04-14-2003 09:26 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 11:52 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration