~drizzle-trunk/drizzle/development

.. option:: --plugin-load arg (=version,uuid_function,user_function,transaction_log,syslog,substr_functions,sleep,show_schema_proto,rot13,reverse_function,rand_function,multi_thread,md5,logging_stats,length,hex_functions,hello_world,filtered_replicator,errmsg_stderr,default_replicator,database_function,crc32,connection_id,compression,charlength,benchmark,ascii,)

Optional comma separated list of plugins to load at starup instead of

the default plugin load list. This completely replaces the whole list.

Kernel Options

--------------

.. option:: --auto-increment-increment arg (=1)

Auto-increment columns are incremented by this

.. option:: --auto-increment-offset arg (=1)

Offset added to Auto-increment columns.

Used when auto-increment-increment != 1

.. option:: -b,--basedir arg

Path to installation directory.

All paths are usually resolved relative to this.

.. option:: -r,--chroot arg

Chroot drizzled daemon during startup.

.. option:: --collation-server arg

Set the default collation.

.. option:: --completion-type arg (=0)

Default completion type.

.. option:: --core-file

Write core on errors.

.. option:: --datadir arg

Path to the database root.

.. option:: --default-storage-engine arg

Set the default storage engine for tables.

.. option:: --default-time-zone arg

Set the default time zone.

.. We should really remove --exit-info as an option

.. option:: -T,--exit-info arg

Used for debugging; Use at your own risk!

100

101

.. option:: --gdb

102

103

Set up signals usable for debugging

104

105

.. option:: --lc-time-name arg

106

107

Set the language used for the month names and the days of the week.

108

109

.. option:: -W [ --log-warnings ] arg

110

111

Log some not critical warnings to the log file.

112

113

.. Why is this a core argument?

114

.. option:: --port-open-timeout arg (=0)

115

116

Maximum time in seconds to wait for the port to become free.

117

A value of 0 means not to wait.

118

119

.. option:: --secure-file-priv arg

120

121

Limit LOAD DATA, SELECT ... OUTFILE, and LOAD_FILE() to files within

122

specified directory

123

124

.. Why is this still here?

125

.. option:: --server-id arg (=0)

126

127

Uniquely identifies the server instance in the community of replication

128

partners.

129

130

.. option:: --skip-stack-trace

131

132

Don't print a stack trace on failure.

133

134

.. option:: -s,--symbolic-links

135

136

Enable symbolic link support.

137

138

.. option:: --timed-mutexes

139

140

Specify whether to time mutexes (only InnoDB mutexes are currently supported)

141

142

.. option:: -t,--tmpdir arg

143

144

Path for temporary files.

145

146

.. option:: --transaction-isolation arg

147

148

Default transaction isolation level.

149

150

.. option:: -u,--user arg

151

152

Run drizzled daemon as user.

153

154

.. option:: -V,--version

155

156

Output version information and exit.

157

158

.. option:: --back-log arg (=50)

159

160

The number of outstanding connection requests Drizzle can have. This comes

161

into play when the main Drizzle thread gets very many connection requests in

162

a very short time.

163

164

.. option:: --bulk-insert-buffer-size arg (=8388608)

165

166

Size of tree cache used in bulk insert optimization. Note that this is a limit

167

per thread!

168

169

.. option:: --div-precision-increment arg (=4)

170

171

Precision of the result of '/' operator will be increased on that value.

172

173

.. option:: --group-concat-max-len arg (=1024)

174

175

The maximum length of the result of function group_concat.

176

177

.. option:: --join-buffer-size arg (=131072)

178

179

The size of the buffer that is used for full joins.

180

181

.. option:: --join-buffer-constraint arg (=0)

182

183

A global constraint for join-buffer-size for all clients, cannot be set lower

184

than --join-buffer-size. Setting to 0 means unlimited.

185

186

.. Why is this a core arg?

187

.. option:: --max-allowed-packet arg (=64M)

188

189

Max packetlength to send/receive from to server.

190

191

.. option:: --max-connect-errors arg (=10)

192

193

If there is more than this number of interrupted connections from a host

194

this host will be blocked from further connections.

195

196

.. option:: --max-error-count arg (=64)

197

198

Max number of errors/warnings to store for a statement.

199

200

.. option:: --max-heap-table-size arg (=16M)

201

202

Don't allow creation of heap tables bigger than this.

203

204

.. option:: --max-join-size arg (=2147483647)

205

206

Joins that are probably going to read more than max_join_size records return

207

an error.

208

209

.. option:: --max-length-for-sort-data arg (=1024)

210

211

Max number of bytes in sorted records.

212

213

.. option:: --max-seeks-for-key arg (=18446744073709551615)

214

215

Limit assumed max number of seeks when looking up rows based on a key

216

217

.. option:: --max-sort-length arg (=1024)

218

219

The number of bytes to use when sorting BLOB or TEXT values (only the first

220

max_sort_length bytes of each value are used; the rest are ignored).

221

222

.. option:: --max-write-lock-count arg (=18446744073709551615)

223

224

After this many write locks, allow some read locks to run in between.

225

226

.. option:: --min-examined-row-limit arg (=0)

227

228

Don't log queries which examine less than min_examined_row_limit rows to file.

229

230

.. option:: --disable-optimizer-prune

231

232

Do not apply any heuristic(s) during query optimization to prune, thus

233

perform an exhaustive search from the optimizer search space.

234

235

.. option:: --optimizer-search-depth arg (=0)

236

237

Maximum depth of search performed by the query optimizer. Values larger than

238

the number of relations in a query result in better query plans, but take

239

longer to compile a query. Smaller values than the number of tables in a

240

relation result in faster optimization, but may produce very bad query plans.

241

If set to 0, the system will automatically pick a reasonable value; if set to

242

MAX_TABLES+2, the optimizer will switch to the original find_best (used for

243

testing/comparison).

244

245

.. option:: --preload-buffer-size arg (=32768)

246

247

The size of the buffer that is allocated when preloading indexes

248

249

.. option:: --query-alloc-block-size arg (=8192)

250

251

Allocation block size for query parsing and execution

252

253

.. option:: --query-prealloc-size arg (=8192)

254

255

Persistent buffer for query parsing and execution

256

257

.. option:: --range-alloc-block-size arg (=4096)

258

259

Allocation block size for storing ranges during optimization

260

261

.. option:: --read-buffer-size arg (=131072)

262

263

Each thread that does a sequential scan allocates a buffer of this size for

264

each table it scans. If you do many sequential scans, you may want to

265

increase this value. Note that this only affect MyISAM.

266

267

.. option:: --read-buffer-constraint arg (=0)

268

269

A global constraint for read-buffer-size for all clients, cannot be set lower

270

than --read-buffer-size. Setting to 0 means unlimited.

271

272

.. option:: --read-rnd-buffer-size arg (=262144)

273

274

When reading rows in sorted order after a sort, the rows are read through

275

this buffer to avoid a disk seeks. If not set, then it's set to the value of

276

record_buffer.

277

278

.. option:: --read-rnd-constraint arg (=0)

279

280

A global constraint for read-rnd-buffer-size for all clients, cannot be set

281

lower than --read-rnd-buffer-size. Setting to 0 means unlimited.

282

283

.. option:: --scheduler arg (=multi-thread)

284

285

Select scheduler to be used.

286

287

.. option:: --sort-buffer-size arg (=2097144)

288

289

Each thread that needs to do a sort allocates a buffer of this size.

290

291

.. option:: --sort-buffer-constraint arg (=0)

292

293

A global constraint for sort-buffer-size for all clients, cannot be set lower

294

than --sort-buffer-size. Setting to 0 means unlimited.

295

296

.. option:: --table-definition-cache arg (=128)

297

298

The number of cached table definitions.

299

300

.. option:: --table-open-cache arg (=1024)

301

302

The number of cached open tables.

303

304

.. option:: --table-lock-wait-timeout arg (=50)

305

306

Timeout in seconds to wait for a table level lock before returning an error.

307

Used only if the connection has active cursors.

308

309

.. option:: --thread-stack arg (=0)

310

311

The stack size for each thread. 0 means use OS default.

312

313

.. option:: --tmp-table-size arg (=16M)

314

315

If an internal in-memory temporary table exceeds this size, Drizzle will

316

automatically convert it to an on-disk MyISAM table.

317

Older »