Trace Mode creates a background image of an existing area in a sketch for you to use as a reference for tracing. In addition to serving as a visual reference, Trace Mode displays corner points and pop points to easily create additional stories, or areas such as basements that share some, but not necessarily all of the same walls. If I request for a lean trace, from the documentation I understand that we will not be able to run the function in generation mode. This is also an issue as interpretation mode makes the program slower. I see other options for trace now other than lean and technical like 0,1,2,3,4,5.
-->The EVENT_TRACE_LOGFILE structure specifies how the consumer wants to read events (from a log file or in real-time) and the callbacks that will receive the events.
When ETW flushes a buffer, this structure contains information about the event tracing session and the buffer that ETW flushed.
Syntax
Members
LogFileName
Name of the log file used by the event tracing session. Specify a value for this member if you are consuming from a log file. This member must be NULL if LoggerName is specified.
You must know the log file name the controller specified. If the controller logged events to a private session (the controller set the LogFileMode member of EVENT_TRACE_PROPERTIES to EVENT_TRACE_PRIVATE_LOGGER_MODE), the file name must include the process identifier that ETW appended to the log file name. For example, if the controller named the log file xyz.etl and the process identifier is 123, ETW uses xyz.etl_123 as the file name.
If the controller set the LogFileMode member of EVENT_TRACE_PROPERTIES to EVENT_TRACE_FILE_MODE_NEWFILE, the log file name must include the sequential serial number used to create each new log file.
The user consuming the events must have permissions to read the file.
LoggerName
Name of the event tracing session. Specify a value for this member if you want to consume events in real time. This member must be NULL if LogFileName is specified.
You can only consume events in real time if the controller set the LogFileMode member of EVENT_TRACE_PROPERTIES to EVENT_TRACE_REAL_TIME_MODE.
Only users with administrative privileges, users in the Performance Log Users group, and applications running as LocalSystem, LocalService, NetworkService can consume events in real time. To grant a restricted user the ability to consume events in real time, add them to the Performance Log Users group or call EventAccessControl.
Windows XP and Windows 2000: Anyone can consume real time events.
CurrentTime
On output, the current time, in 100-nanosecond intervals since midnight, January 1, 1601.
BuffersRead
On output, the number of buffers processed.
LogFileMode
Reserved. Do not use.
ProcessTraceMode
Modes for processing events. The modes are defined in the Evntcons.h header file. You can specify one or more of the following modes:
Value | Meaning |
---|---|
| Specify this mode if you want to receive events in the new EVENT_RECORD format. To receive events in the new format you must specify a callback in the EventRecordCallback member. If you do not specify this mode, you receive events in the old format through the callback specified in the EventCallback member. Prior to Windows Vista: Not supported. |
| Specify this mode if you do not want the time stamp value in the TimeStamp member of EVENT_HEADER and EVENT_TRACE_HEADER converted to system time (leaves the time stamp value in the resolution that the controller specified in the Wnode.ClientContext member of EVENT_TRACE_PROPERTIES). Prior to Windows Vista: Not supported. |
| Specify this mode to receive events in real time (you must specify this mode if LoggerName is not NULL). |
CurrentEvent
On output, an EVENT_TRACE structure that contains the last event processed.
LogfileHeader
On output, a TRACE_LOGFILE_HEADER structure that contains general information about the session and the computer on which the session ran.
BufferCallback
Pointer to the BufferCallback function that receives buffer-related statistics for each buffer ETW flushes. ETW calls this callback after it delivers all the events in the buffer. This callback is optional.
BufferSize
On output, contains the size of each buffer, in bytes.
Filled
On output, contains the number of bytes in the buffer that contain valid information.
EventsLost
Not used.
EventCallback
Pointer to the EventCallback function that ETW calls for each event in the buffer.
Specify this callback if you are consuming events from a provider that used one of the TraceEvent functions to log events.
EventRecordCallback
Pointer to the EventRecordCallback function that ETW calls for each event in the buffer.
Specify this callback if you are consuming events from a provider that used one of the EventWrite functions to log events.
Prior to Windows Vista: Not supported.
![Trace Mode 6.10.2 Trace Mode 6.10.2](http://www.adastra.ru/images/scada_tracemode_avtonom_600.gif)
IsKernelTrace
On output, if this member is TRUE, the event tracing session is the NT Kernel Logger. Otherwise, it is another event tracing session.
Context
Context data that a consumer can specify when calling OpenTrace. If the consumer uses EventRecordCallback to consume events, ETW sets the UserContext member of the EVENT_RECORD structure to this value.
Prior to Windows Vista: Not supported.
Remarks
Be sure to initialize the memory for this structure to zero before setting any members.
Consumers pass this structure to the OpenTrace function.
When ETW flushes a buffer, it passes the structure to the consumer's BufferCallback function.
Requirements
Minimum supported client | Windows 2000 Professional [desktop apps only] |
Minimum supported server | Windows 2000 Server [desktop apps only] |
Header |
|
Unicode and ANSI names | EVENT_TRACE_LOGFILEW (Unicode) and EVENT_TRACE_LOGFILEA (ANSI) |
See also
This chapter describes both the general MySQL Connector/NET 6.10 connection-string options that apply to all server configurations and the options related to systems using a connection pool (see Connection Pooling Options). Connection options have a default value that you can override by defining the new value in the connection string. Connector/NET option names and synonyms are not case sensitive.
For instructions about how to use connection strings with Connector/NET, see Section 5.1.1, “Creating a Connector/NET Connection String”.
The Connector/NET 6.10 options that follow are for general use with connection strings and apply to all MySQL server configurations:
AllowBatch
, Allow Batch
Default: true
When true
, multiple SQL statements can be sent with one command execution. Note: starting with MySQL 4.1.1, batch statements should be separated by the server-defined separator character. Statements sent to earlier versions of MySQL should be separated by the semicolon character (;).
AllowLoadLocalInfile
, Allow Load Local Infile
Default: false
Disables (by default) or enables the server functionality to load the data local infile.
AllowUserVariables
, Allow User Variables
Default: false
Setting this to true
indicates that the provider expects user variables in the SQL. This option was introduced with the 5.2.2 connector.
![Trace Mode 6.10.2 Trace Mode 6.10.2](https://preview.ibb.co/daPCtU/6_09.png)
AllowZeroDateTime
, Allow Zero Datetime
Default: false
If set to True
, MySqlDataReader.GetValue()
returns a MySqlDateTime
object for date or datetime columns that have disallowed values, such as zero datetime values, and a System.DateTime
object for valid values. If set to False
(the default setting) it causes a System.DateTime
object to be returned for all valid values and an exception to be thrown for disallowed values, such as zero datetime values.
AutoEnlist
, Auto Enlist
Default: true
If AutoEnlist
is set to true
, which is the default, a connection opened using TransactionScope
participates in this scope, it commits when the scope commits and rolls back if TransactionScope
does not commit. However, this feature is considered security sensitive and therefore cannot be used in a medium trust environment.
As of 6.10.6, this option is supported in .NET Core 2.0 implementations.
BlobAsUTF8ExcludePattern
Default: null
A POSIX-style regular expression that matches the names of BLOB columns that do not contain UTF-8 character data. See Section 5.16, “Character Set Considerations for Connector/NET” for usage details.
BlobAsUTF8IncludePattern
Default: null
A POSIX-style regular expression that matches the names of BLOB columns containing UTF-8 character data. See Section 5.16, “Character Set Considerations for Connector/NET” for usage details.
CertificateFile
, Certificate File
Default: null
This option specifies the path to a certificate file in PKCS #12 format (.pfx
). For an example of usage, see Section 4.10, “Tutorial: Configuring SSL with Connector/NET”. This option was introduced with the 6.2.1 connector.
CertificatePassword
, Certificate Password
Default: null
Specifies a password that is used in conjunction with a certificate specified using the option CertificateFile
. For an example of usage, see Section 4.10, “Tutorial: Configuring SSL with Connector/NET”. This option was introduced with the 6.2.1 connector.
CertificateStoreLocation
, Certificate Store Location
Default: null
Enables you to access a certificate held in a personal store, rather than use a certificate file and password combination. For an example of usage, see Section 4.10, “Tutorial: Configuring SSL with Connector/NET”. This option was introduced with the 6.2.1 connector.
CertificateThumbprint
, Certificate Thumbprint
Default: null
Specifies a certificate thumbprint to ensure correct identification of a certificate contained within a personal store. For an example of usage, see Section 4.10, “Tutorial: Configuring SSL with Connector/NET”. This option was introduced with the 6.2.1 connector.
CharacterSet
, CharSet
, Character Set
Specifies the character set that should be used to encode all queries sent to the server. Results are still returned in the character set of the result data.
CheckParameters
, Check Parameters
Default: true
Indicates if stored routine parameters should be checked against the server.
CommandInterceptors
, Command Interceptors
The list of interceptors that can intercept SQL command operations.
ConnectionProtocol
, Protocol
, Connection Protocol
Default: socket
or tcp
Specifies the type of connection to make to the server. Values can be:
socket
ortcp
for a socket connection.pipe
for a named pipe connection.unix
for a UNIX socket connection.memory
to use MySQL shared memory.
ConnectionTimeout
, Connect Timeout
, Connection Timeout
Default: 15
The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error.
ConvertZeroDateTime
, Convert Zero Datetime
Default: false
Use true
to have MySqlDataReader.GetValue()
and MySqlDataReader.GetDateTime()
return DateTime.MinValue
for date or datetime columns that have disallowed values.
Database
, Initial Catalog
Default: mysql
The case-sensitive name of the database to use initially.
DefaultCommandTimeout
, Default Command Timeout
Default: 30
Sets the default value of the command timeout to be used. This does not supersede the individual command timeout property on an individual command object. If you set the command timeout property, that will be used. This option was introduced with the 5.1.4 connector.
DefaultTableCacheAge
, Default Table Cache Age
Default: 60
Specifies how long a TableDirect
result should be cached, in seconds. For usage information about table caching, see Section 5.6, “Using Connector/NET with Table Caching”. This option was introduced with the 6.4 connector.
ExceptionInterceptors
, Exception Interceptors
The list of interceptors that can triage thrown MySqlException
exceptions.
FunctionsReturnString
, Functions Return String
Default: false
Causes the connector to return binary
or varbinary
values as strings, if they do not have a table name in the metadata.
IgnorePrepare
, Ignore Prepare
Default: true
When true
, instructs the provider to ignore any calls to MySqlCommand.Prepare()
. This option is provided to prevent issues with corruption of the statements when used with server-side prepared statements. If you use server-side prepare statements, set this option to false. This option was introduced with the 5.0.3 and 1.0.9 connectors.
IncludeSecurityAsserts
, Include Security Asserts
Default: false
Must be set to true
when using the MySQLClientPermissions
class in a partial trust environment, with the library installed in the GAC of the hosting environment. This requirement is new for partial-trust applications in Connector/NET 6.6.4 and higher. See Section 5.19, “Working with Partial Trust / Medium Trust” for details.
As of 6.10.6, this option is supported in .NET Core 2.0 implementations.
IntegratedSecurity
, Integrated Security
Default: no
Use Windows authentication when connecting to server. By default, it is turned off. To enable, specify a value of yes
. (You can also use the value sspi
as an alternative to yes
.) For details, see Section 5.4, “Using the Windows Native Authentication Plugin”. This setting only applies to the Windows platform and was introduced with the 6.4.4 connector.
Currently not supported for .NET Core implementations.
InteractiveSession
, Interactive
, Interactive Session
Default: false
If set to true
, the client is interactive. An interactive client is one where the server variable CLIENT_INTERACTIVE
is set. If an interactive client is set, the wait_timeout
variable is set to the value of interactive_timeout
. The client will then time out after this period of inactivity. For more details, see Server System Variables in the MySQL Reference Manual.
As of 6.10.6, this option is supported in .NET Core 2.0 implementations.
Keepalive
, Keep Alive
Default: 0
For TCP connections, idle connection time measured in seconds, before the first keepalive packet is sent. A value of 0 indicates that keepalive
is not used. Before Connector/NET 6.6.7/6.7.5/6.8.4, this value was measured in milliseconds.
Logging
Default: false
When true, various pieces of information is output to any configured TraceListeners. See Section 5.14, “Using the Connector/NET Trace Source Object” for further details.
As of 6.10.6, this option is supported in .NET Core 2.0 implementations.
OldGuids
, Old Guids
Default: false
This option was introduced in Connector/NET 6.1.1. The back-end representation of a GUID type was changed from BINARY(16)
to CHAR(36)
. This was done to allow developers to use the server function UUID()
to populate a GUID table - UUID()
generates a 36-character string. Developers of older applications can add 'Old Guids=true'
to the connection string to use a GUID of data type BINARY(16)
.
Password
, pwd
The password for the MySQL account being used.
PersistSecurityInfo
, Persist Security Info
Default: false
When set to false
or no
(strongly recommended), security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state. Resetting the connection string resets all connection string values, including the password. Recognized values are true
, false
, yes
, and no
.
PipeName
, Pipe Name
, Pipe
Default: mysql
When set to the name of a named pipe, the MySqlConnection
attempts to connect to MySQL on that named pipe. This setting only applies to the Windows platform.
Currently not supported for .NET Core implementations.
Port
Default: 3306
The port MySQL is using to listen for connections. This value is ignored if Unix socket is used.
ProcedureCacheSize
, Procedure Cache Size
, Procedure Cache
, ProcedureCache
Default: 25
Sets the size of the stored procedure cache. By default, Connector/NET stores the metadata (input/output data types) about the last 25 stored procedures used. To disable the stored procedure cache, set the value to zero (0). This option was introduced with the 5.0.2 and 1.0.9 connectors.
Replication
Default: false
Indicates if this connection is to use replicated servers.
As of 6.10.6, this option is supported in .NET Core 2.0 implementations.
RespectBinaryFlags
, Respect Binary Flags
Default: true
Setting this option to false
means that Connector/NET ignores a column's binary flags as set by the server. This option was introduced with the 5.1.3 connector.
Server
, Host
, Data Source
, DataSource
, Address
, Addr
, Network Address
Default: localhost
The name or network address of the instance of MySQL to which to connect. Multiple hosts can be specified separated by commas. This can be useful where multiple MySQL servers are configured for replication and you are not concerned about the precise server you are connecting to. No attempt is made by the provider to synchronize writes to the database, so take care when using this option. In Unix environment with Mono, this can be a fully qualified path to a MySQL socket file. With this configuration, the Unix socket is used instead of the TCP/IP socket. Currently, only a single socket name can be given, so accessing MySQL in a replicated environment using Unix sockets is not currently supported.
SharedMemoryName
, Shared Memory Name
Default: MYSQL
The name of the shared memory object to use for communication if the connection protocol is set to memory
. This setting only applies to the Windows platform.
Currently not supported for .NET Core implementations.
SqlServerMode
, Sql Server Mode
Default: false
Allow SQL Server syntax. When set to true
, enables Connector/NET to support square brackets around symbols instead of backticks. This enables Visual Studio wizards that bracket symbols with [] to work with Connector/NET. This option incurs a performance hit, so should only be used if necessary. This option was introduced with the 6.3.1 connector.
SslMode
, Ssl Mode
, Ssl-Mode
Default: Preferred
This option was introduced in Connector/NET 6.2.1 and has the following values:
None
- Do not use SSL.Preferred
- Use SSL if the server supports it, but allow connection in all cases.Required
- Always use SSL. Deny connection if server does not support SSL.VerifyCA
- Always use SSL. Validate the CA but tolerate name mismatch.VerifyFull
- Always use SSL. Fail if the host name is not correct.
TableCaching
, Table Cache
, tablecache
Default: false
Enables or disables caching of TableDirect
commands. A value of true
enables the cache while false
disables it. For usage information about table caching, see Section 5.6, “Using Connector/NET with Table Caching”. This option was introduced with the 6.4 connector.
TreatBlobsAsUTF8
, Treat BLOBs as UTF8
Default: false
Setting this value to true
causes BLOB
columns to have a character set of utf8
with the default collation for that character set.
TreatTinyAsBoolean
, Treat Tiny As Boolean
Default: true
Setting this value to false
causes TINYINT(1)
to be treated as an INT
. See Numeric Type Overview for a further explanation of the TINYINT
and BOOL
data types.
UseAffectedRows
, Use Affected Rows
Default: false
When true
, the connection reports changed rows instead of found rows. This option was introduced with the 5.2.6 connector.
UseCompression
, Compress
, Use Compression
Default: false
Setting this option to true
enables compression of packets exchanged between the client and the server. This exchange is defined by the MySQL client/server protocol.
Compression is used if both client and server support ZLIB compression, and the client has requested compression using this option.
A compressed packet header is: packet length (3 bytes), packet number (1 byte), and Uncompressed Packet Length (3 bytes). The Uncompressed Packet Length is the number of bytes in the original, uncompressed packet. If this is zero, the data in this packet has not been compressed. When the compression protocol is in use, either the client or the server may compress packets. However, compression will not occur if the compressed length is greater than the original length. Thus, some packets will contain compressed data while other packets will not.
UseDefaultCommandTimeoutForEF
, Use Default Command Timeout For EF
Default: false
Enforces the command timeout of EFMySqlCommand
, which is set to the value provided by the DefaultCommandTimeout
property.
UseOldSyntax
, Old Syntax
, OldSyntax
, Use Old Syntax
Default: false
This option was deprecated in Connector/NET 5.2.2 and removed in Connector/NET 6.10.2. All code should now be written using the '@' symbol as the parameter marker.
UsePerformanceMonitor
, Use Performance Monitor
, UserPerfmon
, Perfmon
Default: false
Indicates that performance counters should be updated during execution.
Currently not supported for .NET Core implementations.
UseProcedureBodies
, Use Procedure Bodies
, Procedure Bodies
Default: true
When set to true
, the default value, Connector/NET expects the body of the procedure to be viewable. This enables it to determine the parameter types and order. Set the option to false
when the user connecting to the database does not have the SELECT
privileges for the mysql.proc
(stored procedures) table or cannot view INFORMATION_SCHEMA.ROUTINES
, and then explicitly set the types of all the parameters before the call and add the parameters to the command in the same order as they appear in the procedure definition.
This option was deprecated in Connector/NET 6.3.7 and removed in Connector/NET 6.10.4; use the Check Parameters
option instead.
UserID
, User Id
, Username
, Uid
, User name
, User
The MySQL login account being used.
UseUsageAdvisor
, Use Usage Advisor
, Usage Advisor
Default: false
Logs inefficient database operations.
As of 6.10.6, this option is supported in .NET Core 2.0 implementations.
The following options are related to connection pooling within connection strings. For more information about connection pooling, see Section 5.3, “Using Connector/NET with Connection Pooling”.
CacheServerProperties
, Cache Server Properties
Default: false
Specifies whether server variable settings are updated by a SHOW VARIABLES
command each time a pooled connection is returned. Enabling this setting speeds up connections in a connection pool environment. Your application is not informed of any changes to configuration variables made by other connections. This option was introduced with the 6.3 connector.
ConnectionLifeTime
, Connection Lifetime
Default: 0
When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by Connection Lifetime
. This is useful in clustered configurations to force load balancing between a running server and a server just brought online. A value of zero (0) causes pooled connections to have the maximum connection timeout.
ConnectionReset
, Connection Reset
Default: false
If true
, the connection state is reset when it is retrieved from the pool. The default value of false avoids making an additional server round trip when obtaining a connection, but the connection state is not reset.
MaximumPoolsize
, Maximum Pool Size
, Max Pool Size
, MaxPoolSize
Default: 100
The maximum number of connections allowed in the pool. This option applies to Connector/NET 6.7 and higher.
MinimumPoolSize
, Minimum Pool Size
, Min Pool Size
, MinPoolSize
Default: 0
The minimum number of connections allowed in the pool. This option applies to Connector/NET 6.7 and higher.
Pooling
Default: true
When true
, the MySqlConnection
object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool. Recognized values are true
, false
, yes
, and no
.