1
1
/*****************************************************************************
3
Copyright (C) 1996, 2010, Innobase Oy. All Rights Reserved.
4
Copyright (C) 2008, Google Inc.
5
Copyright (C) 2009, Percona Inc.
3
Copyright (c) 1996, 2010, Innobase Oy. All Rights Reserved.
4
Copyright (c) 2008, Google Inc.
5
Copyright (c) 2009, Percona Inc.
7
7
Portions of this file contain modifications contributed and copyrighted by
8
8
Google, Inc. Those modifications are gratefully acknowledged and are described
126
123
/** Files comprising the system tablespace */
127
124
static os_file_t files[1000];
126
/** Mutex protecting the ios count */
127
static mutex_t ios_mutex;
128
/** Count of I/O operations in io_handler_thread() */
129
131
/** io_handler_thread parameters for thread identification */
130
132
static ulint n[SRV_MAX_N_IO_THREADS + 6];
131
133
/** io_handler_thread identifiers */
143
145
#define SRV_N_PENDING_IOS_PER_THREAD OS_AIO_N_PENDING_IOS_PER_THREAD
144
146
#define SRV_MAX_N_PENDING_SYNC_IOS 100
146
#ifdef UNIV_PFS_THREAD
147
/* Keys to register InnoDB threads with performance schema */
148
UNIV_INTERN mysql_pfs_key_t io_handler_thread_key;
149
UNIV_INTERN mysql_pfs_key_t srv_lock_timeout_thread_key;
150
UNIV_INTERN mysql_pfs_key_t srv_error_monitor_thread_key;
151
UNIV_INTERN mysql_pfs_key_t srv_monitor_thread_key;
152
UNIV_INTERN mysql_pfs_key_t srv_master_thread_key;
153
#endif /* UNIV_PFS_THREAD */
155
149
/*********************************************************************//**
156
150
Convert a numeric string that optionally ends in G or M, to a number
285
srv_data_file_names = static_cast<char **>(malloc(i * sizeof *srv_data_file_names));
286
srv_data_file_sizes = static_cast<ulint *>(malloc(i * sizeof *srv_data_file_sizes));
287
srv_data_file_is_raw_partition = static_cast<ulint *>(malloc(
288
i * sizeof *srv_data_file_is_raw_partition));
279
srv_data_file_names = malloc(i * sizeof *srv_data_file_names);
280
srv_data_file_sizes = malloc(i * sizeof *srv_data_file_sizes);
281
srv_data_file_is_raw_partition = malloc(
282
i * sizeof *srv_data_file_is_raw_partition);
290
284
srv_n_data_files = i;
483
473
fprintf(stderr, "Io handler thread %lu starts, id %lu\n", segment,
484
474
os_thread_pf(os_thread_get_curr_id()));
487
#ifdef UNIV_PFS_THREAD
488
pfs_register_thread(io_handler_thread_key);
489
#endif /* UNIV_PFS_THREAD */
491
476
while (srv_shutdown_state != SRV_SHUTDOWN_EXIT_THREADS) {
492
477
fil_aio_wait(segment);
479
mutex_enter(&ios_mutex);
481
mutex_exit(&ios_mutex);
484
thr_local_free(os_thread_get_curr_id());
495
486
/* We count the number of threads in os_thread_exit(). A created
496
487
thread should always use that to exit and not use return() to exit.
497
488
The thread actually never comes here because it is exited in an
593
584
sprintf(name + dirnamelen, "%s%lu", "ib_logfile", (ulong) i);
595
files[i] = os_file_create(innodb_file_log_key, name,
596
OS_FILE_CREATE, OS_FILE_NORMAL,
586
files[i] = os_file_create(name, OS_FILE_CREATE, OS_FILE_NORMAL,
597
587
OS_LOG_FILE, &ret);
598
588
if (ret == FALSE) {
599
589
if (os_file_get_last_error(FALSE) != OS_FILE_ALREADY_EXISTS
604
594
&& os_file_get_last_error(FALSE) != 100
607
drizzled::errmsg_printf(drizzled::error::ERROR,
608
"InnoDB: Error in creating or opening %s", name);
598
"InnoDB: Error in creating"
599
" or opening %s\n", name);
613
files[i] = os_file_create(innodb_file_log_key, name,
614
OS_FILE_OPEN, OS_FILE_AIO,
604
files[i] = os_file_create(name, OS_FILE_OPEN, OS_FILE_AIO,
615
605
OS_LOG_FILE, &ret);
617
drizzled::errmsg_printf(drizzled::error::ERROR,
618
"InnoDB: Error in opening %s.", name);
608
"InnoDB: Error in opening %s\n", name);
620
610
return(DB_ERROR);
626
616
if (size != srv_calc_low32(srv_log_file_size)
627
617
|| size_high != srv_calc_high32(srv_log_file_size)) {
629
drizzled::errmsg_printf(drizzled::error::ERROR,
630
"InnoDB: Error: log file %s is of different size %lu %lu bytes than specified in the .cnf"
631
" file %lu %lu bytes!",
632
name, (ulong) size_high, (ulong) size,
633
(ulong) srv_calc_high32(srv_log_file_size),
634
(ulong) srv_calc_low32(srv_log_file_size));
620
"InnoDB: Error: log file %s is"
621
" of different size %lu %lu bytes\n"
622
"InnoDB: than specified in the .cnf"
623
" file %lu %lu bytes!\n",
624
name, (ulong) size_high, (ulong) size,
625
(ulong) srv_calc_high32(srv_log_file_size),
626
(ulong) srv_calc_low32(srv_log_file_size));
636
628
return(DB_ERROR);
639
631
*log_file_created = TRUE;
641
drizzled::errmsg_printf(drizzled::error::INFO,
642
"InnoDB: Log file %s did not exist: new to be created",
633
ut_print_timestamp(stderr);
636
" InnoDB: Log file %s did not exist:"
637
" new to be created\n",
644
639
if (log_file_has_been_opened) {
646
641
return(DB_ERROR);
649
drizzled::errmsg_printf(drizzled::error::INFO,
650
"InnoDB: Setting log file %s size to %lu MB",
651
name, (ulong) srv_log_file_size
652
>> (20 - UNIV_PAGE_SIZE_SHIFT));
644
fprintf(stderr, "InnoDB: Setting log file %s size to %lu MB\n",
645
name, (ulong) srv_log_file_size
646
>> (20 - UNIV_PAGE_SIZE_SHIFT));
654
drizzled::errmsg_printf(drizzled::error::INFO,
655
"InnoDB: Database physically writes the file full: wait...\n");
649
"InnoDB: Database physically writes the file"
657
652
ret = os_file_set_size(name, files[i],
658
653
srv_calc_low32(srv_log_file_size),
659
654
srv_calc_high32(srv_log_file_size));
661
drizzled::errmsg_printf(drizzled::error::ERROR,
662
"InnoDB: Error in creating %s: probably out of disk space",
657
"InnoDB: Error in creating %s:"
658
" probably out of disk space\n",
665
661
return(DB_ERROR);
737
733
char name[10000];
739
735
if (srv_n_data_files >= 1000) {
740
drizzled::errmsg_printf(drizzled::error::ERROR,
741
"InnoDB: can only have < 1000 data files you have defined %lu",
742
(ulong) srv_n_data_files);
736
fprintf(stderr, "InnoDB: can only have < 1000 data files\n"
737
"InnoDB: you have defined %lu\n",
738
(ulong) srv_n_data_files);
743
739
return(DB_ERROR);
797
793
srv_start_raw_disk_in_use = TRUE;
798
794
srv_created_new_raw = TRUE;
800
files[i] = os_file_create(innodb_file_data_key,
801
name, OS_FILE_OPEN_RAW,
796
files[i] = os_file_create(name, OS_FILE_OPEN_RAW,
803
798
OS_DATA_FILE, &ret);
805
drizzled::errmsg_printf(drizzled::error::ERROR,
806
"InnoDB: Error in opening %s", name);
801
"InnoDB: Error in opening %s\n", name);
808
803
return(DB_ERROR);
819
814
/* We open the data file */
821
816
if (one_created) {
822
drizzled::errmsg_printf(drizzled::error::ERROR,
823
"InnoDB: Error: data files can only be added at the end of a tablespace, but"
824
" data file %s existed beforehand.",
818
"InnoDB: Error: data files can only"
819
" be added at the end\n");
821
"InnoDB: of a tablespace, but"
822
" data file %s existed beforehand.\n",
826
824
return(DB_ERROR);
829
827
if (srv_data_file_is_raw_partition[i] == SRV_OLD_RAW) {
830
828
files[i] = os_file_create(
831
innodb_file_data_key,
832
829
name, OS_FILE_OPEN_RAW,
833
830
OS_FILE_NORMAL, OS_DATA_FILE, &ret);
834
831
} else if (i == 0) {
835
832
files[i] = os_file_create(
836
innodb_file_data_key,
837
833
name, OS_FILE_OPEN_RETRY,
838
834
OS_FILE_NORMAL, OS_DATA_FILE, &ret);
840
836
files[i] = os_file_create(
841
innodb_file_data_key,
842
837
name, OS_FILE_OPEN, OS_FILE_NORMAL,
843
838
OS_DATA_FILE, &ret);
847
drizzled::errmsg_printf(drizzled::error::ERROR,
848
"InnoDB: Error in opening %s", name);
843
"InnoDB: Error in opening %s\n", name);
849
844
os_file_get_last_error(TRUE);
851
846
return(DB_ERROR);
872
867
&& srv_last_file_size_max
873
868
< rounded_size_pages)) {
875
drizzled::errmsg_printf(drizzled::error::ERROR,
876
"InnoDB: Error: auto-extending data file %s is of a different size. "
877
"%lu pages (rounded down to MB) than specified in the .cnf file: "
878
"initial %lu pages, max %lu (relevant if non-zero) pages!",
880
(ulong) rounded_size_pages,
881
(ulong) srv_data_file_sizes[i],
883
srv_last_file_size_max);
871
"InnoDB: Error: auto-extending"
873
" of a different size\n"
874
"InnoDB: %lu pages (rounded"
875
" down to MB) than specified"
876
" in the .cnf file:\n"
877
"InnoDB: initial %lu pages,"
878
" max %lu (relevant if"
879
" non-zero) pages!\n",
881
(ulong) rounded_size_pages,
882
(ulong) srv_data_file_sizes[i],
884
srv_last_file_size_max);
885
886
return(DB_ERROR);
891
892
if (rounded_size_pages != srv_data_file_sizes[i]) {
893
drizzled::errmsg_printf(drizzled::error::ERROR,
894
"InnoDB: Error: data file %s is of a different size. "
895
"%lu pages (rounded down to MB). "
896
"Than specified in the .cnf file %lu pages!",
895
"InnoDB: Error: data file %s"
896
" is of a different size\n"
898
" (rounded down to MB)\n"
899
"InnoDB: than specified"
900
" in the .cnf file %lu pages!\n",
898
902
(ulong) rounded_size_pages,
899
903
(ulong) srv_data_file_sizes[i]);
915
919
one_created = TRUE;
918
drizzled::errmsg_printf(drizzled::error::INFO,
919
" InnoDB: Data file %s did not exist: new to be created",
922
ut_print_timestamp(stderr);
924
" InnoDB: Data file %s did not"
925
" exist: new to be created\n",
922
drizzled::errmsg_printf(drizzled::error::INFO,
923
"InnoDB: The first specified data file %s did not exist. A new database to be created!", name);
929
"InnoDB: The first specified"
930
" data file %s did not exist:\n"
931
"InnoDB: a new database"
932
" to be created!\n", name);
924
933
*create_new_db = TRUE;
927
drizzled::errmsg_printf(drizzled::error::INFO,
928
" InnoDB: Setting file %s size to %lu MB",
929
name, (ulong) (srv_data_file_sizes[i]
930
>> (20 - UNIV_PAGE_SIZE_SHIFT)));
936
ut_print_timestamp(stderr);
938
" InnoDB: Setting file %s size to %lu MB\n",
940
(ulong) (srv_data_file_sizes[i]
941
>> (20 - UNIV_PAGE_SIZE_SHIFT)));
932
drizzled::errmsg_printf(drizzled::error::INFO,
933
"InnoDB: Database physically writes the file full: wait...");
944
"InnoDB: Database physically writes the"
945
" file full: wait...\n");
935
947
ret = os_file_set_size(
938
950
srv_calc_high32(srv_data_file_sizes[i]));
941
drizzled::errmsg_printf(drizzled::error::ERROR,
942
"InnoDB: Error in creating %s: probably out of disk space", name);
954
"InnoDB: Error in creating %s:"
955
" probably out of disk space\n", name);
944
957
return(DB_ERROR);
1003
1021
on Mac OS X 10.3 or later. */
1004
1022
struct utsname utsname;
1005
1023
if (uname(&utsname)) {
1006
fputs(_("InnoDB: cannot determine Mac OS X version!\n"), stderr);
1024
fputs("InnoDB: cannot determine Mac OS X version!\n", stderr);
1008
1026
srv_have_fullfsync = strcmp(utsname.release, "7.") >= 0;
1010
1028
if (!srv_have_fullfsync) {
1011
fputs(_("InnoDB: On Mac OS X, fsync() may be"
1012
" broken on internal drives,\n"
1013
"InnoDB: making transactions unsafe!\n"), stderr);
1029
fputs("InnoDB: On Mac OS X, fsync() may be"
1030
" broken on internal drives,\n"
1031
"InnoDB: making transactions unsafe!\n", stderr);
1015
1033
# endif /* F_FULLFSYNC */
1016
1034
#endif /* HAVE_DARWIN_THREADS */
1018
1036
if (sizeof(ulint) != sizeof(void*)) {
1019
drizzled::errmsg_printf(drizzled::error::WARN,
1020
_("InnoDB: Error: size of InnoDB's ulint is %lu, but size of void* is %lu. "
1021
"The sizes should be the same so that on a 64-bit platform you can. Allocate more than 4 GB of memory."),
1038
"InnoDB: Error: size of InnoDB's ulint is %lu,"
1039
" but size of void* is %lu.\n"
1040
"InnoDB: The sizes should be the same"
1041
" so that on a 64-bit platform you can\n"
1042
"InnoDB: allocate more than 4 GB of memory.",
1022
1043
(ulong)sizeof(ulint), (ulong)sizeof(void*));
1028
1049
innodb_file_per_table) until this function has returned. */
1029
1050
srv_file_per_table = FALSE;
1030
1051
#ifdef UNIV_DEBUG
1031
drizzled::errmsg_printf(drizzled::error::INFO,
1032
_("InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!\n"));
1053
"InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!\n");
1035
1056
#ifdef UNIV_IBUF_DEBUG
1036
drizzled::errmsg_printf(drizzled::error::INFO,
1037
_("InnoDB: !!!!!!!! UNIV_IBUF_DEBUG switched on !!!!!!!!!\n"
1058
"InnoDB: !!!!!!!! UNIV_IBUF_DEBUG switched on !!!!!!!!!\n"
1038
1059
# ifdef UNIV_IBUF_COUNT_DEBUG
1039
"InnoDB: !!!!!!!! UNIV_IBUF_COUNT_DEBUG switched on !!!!!!!!!\n"
1040
"InnoDB: Crash recovery will fail with UNIV_IBUF_COUNT_DEBUG\n"
1060
"InnoDB: !!!!!!!! UNIV_IBUF_COUNT_DEBUG switched on !!!!!!!!!\n"
1061
"InnoDB: Crash recovery will fail with UNIV_IBUF_COUNT_DEBUG\n"
1045
1066
#ifdef UNIV_SYNC_DEBUG
1046
drizzled::errmsg_printf(drizzled::error::INFO,
1047
_("InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!\n"));
1068
"InnoDB: !!!!!!!! UNIV_SYNC_DEBUG switched on !!!!!!!!!\n");
1050
1071
#ifdef UNIV_SEARCH_DEBUG
1051
drizzled::errmsg_printf(drizzled::error::INFO,
1052
_("InnoDB: !!!!!!!! UNIV_SEARCH_DEBUG switched on !!!!!!!!!\n"));
1073
"InnoDB: !!!!!!!! UNIV_SEARCH_DEBUG switched on !!!!!!!!!\n");
1055
1076
#ifdef UNIV_LOG_LSN_DEBUG
1056
drizzled::errmsg_printf(drizzled::error::INFO,
1057
_("InnoDB: !!!!!!!! UNIV_LOG_LSN_DEBUG switched on !!!!!!!!!\n"));
1078
"InnoDB: !!!!!!!! UNIV_LOG_LSN_DEBUG switched on !!!!!!!!!\n");
1058
1079
#endif /* UNIV_LOG_LSN_DEBUG */
1059
1080
#ifdef UNIV_MEM_DEBUG
1060
drizzled::errmsg_printf(drizzled::error::INFO,
1061
_("InnoDB: !!!!!!!! UNIV_MEM_DEBUG switched on !!!!!!!!!\n"));
1082
"InnoDB: !!!!!!!! UNIV_MEM_DEBUG switched on !!!!!!!!!\n");
1064
if (UNIV_LIKELY(srv_use_sys_malloc))
1066
drizzled::errmsg_printf(drizzled::error::INFO, _("InnoDB: The InnoDB memory heap is disabled\n"));
1085
if (UNIV_LIKELY(srv_use_sys_malloc)) {
1087
"InnoDB: The InnoDB memory heap is disabled\n");
1069
drizzled::errmsg_printf(drizzled::error::INFO, "InnoDB: " IB_ATOMICS_STARTUP_MSG
1070
"\nInnoDB: Compressed tables use zlib " ZLIB_VERSION
1090
fputs("InnoDB: " IB_ATOMICS_STARTUP_MSG
1091
"\nInnoDB: Compressed tables use zlib " ZLIB_VERSION
1071
1092
#ifdef UNIV_ZIP_DEBUG
1072
1093
" with validation"
1073
1094
#endif /* UNIV_ZIP_DEBUG */
1074
1095
#ifdef UNIV_ZIP_COPY
1075
1096
" and extra copying"
1076
1097
#endif /* UNIV_ZIP_COPY */
1080
1101
/* Since InnoDB does not currently clean up all its internal data
1083
1104
second time during the process lifetime. */
1085
1106
if (srv_start_has_been_called) {
1086
drizzled::errmsg_printf(drizzled::error::ERROR,
1087
"InnoDB: Error: startup called second time during the process lifetime.\n");
1108
"InnoDB: Error: startup called second time"
1109
" during the process lifetime.\n"
1110
"InnoDB: In the MySQL Embedded Server Library"
1111
" you cannot call server_init()\n"
1112
"InnoDB: more than once during"
1113
" the process lifetime.\n");
1090
1116
srv_start_has_been_called = TRUE;
1107
1134
but when run in conjunction with InnoDB Hot Backup, it seemed
1108
1135
to corrupt the data files. */
1110
srv_use_native_aio = FALSE;
1115
/* On 2000 and XP, async IO is available. */
1116
srv_use_native_aio = TRUE;
1137
os_aio_use_native_aio = FALSE;
1120
/* Vista and later have both async IO and condition variables */
1121
srv_use_native_aio = TRUE;
1122
srv_use_native_conditions = TRUE;
1140
/* On Win 2000 and XP use async i/o */
1141
os_aio_use_native_aio = TRUE;
1126
#elif defined(LINUX_NATIVE_AIO)
1128
if (srv_use_native_aio) {
1129
drizzled::errmsg_printf(drizzled::error::INFO,
1130
_("InnoDB: Using Linux native AIO"));
1133
/* Currently native AIO is supported only on windows and linux
1134
and that also when the support is compiled in. In all other
1135
cases, we ignore the setting of innodb_use_native_aio. */
1136
srv_use_native_aio = FALSE;
1140
1145
if (srv_file_flush_method_str == NULL) {
1141
1146
/* These are the default options */
1162
1167
} else if (0 == ut_strcmp(srv_file_flush_method_str, "normal")) {
1163
1168
srv_win_file_flush_method = SRV_WIN_IO_NORMAL;
1164
srv_use_native_aio = FALSE;
1169
os_aio_use_native_aio = FALSE;
1166
1171
} else if (0 == ut_strcmp(srv_file_flush_method_str, "unbuffered")) {
1167
1172
srv_win_file_flush_method = SRV_WIN_IO_UNBUFFERED;
1168
srv_use_native_aio = FALSE;
1173
os_aio_use_native_aio = FALSE;
1170
1175
} else if (0 == ut_strcmp(srv_file_flush_method_str,
1171
1176
"async_unbuffered")) {
1172
1177
srv_win_file_flush_method = SRV_WIN_IO_UNBUFFERED;
1175
drizzled::errmsg_printf(drizzled::error::ERROR,
1176
"InnoDB: Unrecognized value %s for innodb_flush_method",
1177
srv_file_flush_method_str);
1181
"InnoDB: Unrecognized value %s for"
1182
" innodb_flush_method\n",
1183
srv_file_flush_method_str);
1178
1184
return(DB_ERROR);
1186
1192
maximum number of threads that can wait in the 'srv_conc array' for
1187
1193
their time to enter InnoDB. */
1195
#if defined(__NETWARE__)
1197
/* Create less event semaphores because Win 98/ME had
1198
difficulty creating 40000 event semaphores. Comment from
1199
Novell, Inc.: also, these just take a lot of memory on
1201
srv_max_n_threads = 1000;
1189
1203
if (srv_buf_pool_size >= 1000 * 1024 * 1024) {
1190
1204
/* If buffer pool is less than 1000 MB,
1191
assume fewer threads. Also use only one
1192
buffer pool instance */
1205
assume fewer threads. */
1193
1206
srv_max_n_threads = 50000;
1195
1208
} else if (srv_buf_pool_size >= 8 * 1024 * 1024) {
1197
srv_buf_pool_instances = 1;
1198
1210
srv_max_n_threads = 10000;
1200
srv_buf_pool_instances = 1;
1201
1212
srv_max_n_threads = 1000; /* saves several MB of memory,
1202
1213
especially in 64-bit
1206
1217
err = srv_boot();
1208
1219
if (err != DB_SUCCESS) {
1210
1221
return((int) err);
1213
mutex_create(srv_monitor_file_mutex_key,
1214
&srv_monitor_file_mutex, SYNC_NO_ORDER_CHECK);
1224
mutex_create(&srv_monitor_file_mutex, SYNC_NO_ORDER_CHECK);
1216
1226
if (srv_innodb_status) {
1217
srv_monitor_file_name = static_cast<char *>(mem_alloc(
1227
srv_monitor_file_name = mem_alloc(
1218
1228
strlen(fil_path_to_mysql_datadir)
1219
+ 20 + sizeof "/innodb_status."));
1229
+ 20 + sizeof "/innodb_status.");
1220
1230
sprintf(srv_monitor_file_name, "%s/innodb_status.%lu",
1221
1231
fil_path_to_mysql_datadir, os_proc_get_number());
1222
1232
srv_monitor_file = fopen(srv_monitor_file_name, "w+");
1223
1233
if (!srv_monitor_file) {
1224
drizzled::errmsg_printf(drizzled::error::ERROR,
1225
"InnoDB: unable to create %s: %s\n", srv_monitor_file_name, strerror(errno));
1234
fprintf(stderr, "InnoDB: unable to create %s: %s\n",
1235
srv_monitor_file_name, strerror(errno));
1226
1236
return(DB_ERROR);
1236
mutex_create(srv_dict_tmpfile_mutex_key,
1237
&srv_dict_tmpfile_mutex, SYNC_DICT_OPERATION);
1246
mutex_create(&srv_dict_tmpfile_mutex, SYNC_DICT_OPERATION);
1239
1248
srv_dict_tmpfile = os_file_create_tmpfile();
1240
1249
if (!srv_dict_tmpfile) {
1241
1250
return(DB_ERROR);
1244
mutex_create(srv_misc_tmpfile_mutex_key,
1245
&srv_misc_tmpfile_mutex, SYNC_ANY_LATCH);
1253
mutex_create(&srv_misc_tmpfile_mutex, SYNC_ANY_LATCH);
1247
1255
srv_misc_tmpfile = os_file_create_tmpfile();
1248
1256
if (!srv_misc_tmpfile) {
1275
1283
fil_init(srv_file_per_table ? 50000 : 5000,
1276
1284
srv_max_n_open_files);
1278
/* Print time to initialize the buffer pool */
1280
if (srv_buf_pool_size >= 1024 * 1024 * 1024) {
1281
drizzled::errmsg_printf(drizzled::error::INFO, "InnoDB: Initializing buffer pool, size = %.1fG",
1282
((double) srv_buf_pool_size) / (1024 * 1024 * 1024));
1284
drizzled::errmsg_printf(drizzled::error::INFO, "InnoDB: Initializing buffer pool, size = %.1fM",
1285
((double) srv_buf_pool_size) / (1024 * 1024));
1288
err = buf_pool_init(srv_buf_pool_size, srv_buf_pool_instances);
1290
drizzled::errmsg_printf(drizzled::error::INFO, "InnoDB: Completed initialization of buffer pool");
1292
if (err != DB_SUCCESS) {
1293
drizzled::errmsg_printf(drizzled::error::ERROR, "InnoDB: Fatal error: cannot allocate the memory for the buffer pool");
1286
ret = buf_pool_init();
1290
"InnoDB: Fatal error: cannot allocate the memory"
1291
" for the buffer pool\n");
1298
1296
#ifdef UNIV_DEBUG
1302
1300
if (srv_buf_pool_size <= 5 * 1024 * 1024) {
1304
drizzled::errmsg_printf(drizzled::error::WARN, "InnoDB: Warning: Small buffer pool size "
1305
"(%luM), the flst_validate() debug function "
1306
"can cause a deadlock if the buffer pool fills up.\n",
1307
srv_buf_pool_size / 1024 / 1024);
1302
fprintf(stderr, "InnoDB: Warning: Small buffer pool size "
1303
"(%luM), the flst_validate() debug function "
1304
"can cause a deadlock if the buffer pool fills up.\n",
1305
srv_buf_pool_size / 1024 / 1024);
1324
1322
#ifdef UNIV_LOG_ARCHIVE
1325
1323
if (0 != ut_strcmp(srv_log_group_home_dirs[0], srv_arch_dir)) {
1326
drizzled::errmsg_printf(drizzled::error::ERROR,
1327
"InnoDB: Error: you must set the log group home dir in my.cnf the same as log arch dir.");
1325
"InnoDB: Error: you must set the log group"
1326
" home dir in my.cnf the\n"
1327
"InnoDB: same as log arch dir.\n");
1329
1329
return(DB_ERROR);
1331
1331
#endif /* UNIV_LOG_ARCHIVE */
1333
1333
if (srv_n_log_files * srv_log_file_size >= 262144) {
1334
drizzled::errmsg_printf(drizzled::error::ERROR,
1335
"InnoDB: Error: combined size of log files must be < 4 GB");
1335
"InnoDB: Error: combined size of log files"
1336
" must be < 4 GB\n");
1337
1338
return(DB_ERROR);
1342
1343
for (i = 0; i < srv_n_data_files; i++) {
1343
1344
#ifndef __WIN__
1344
1345
if (sizeof(off_t) < 5 && srv_data_file_sizes[i] >= 262144) {
1345
drizzled::errmsg_printf(drizzled::error::ERROR,
1346
"InnoDB: Error: file size must be < 4 GB with this MySQL binary and operating system combination,"
1347
" in some OS's < 2 GB\n");
1347
"InnoDB: Error: file size must be < 4 GB"
1348
" with this MySQL binary\n"
1349
"InnoDB: and operating system combination,"
1350
" in some OS's < 2 GB\n");
1349
1352
return(DB_ERROR);
1365
1370
&min_flushed_lsn, &max_flushed_lsn,
1366
1371
&sum_of_new_sizes);
1367
1372
if (err != DB_SUCCESS) {
1368
drizzled::errmsg_printf(drizzled::error::ERROR,
1369
"InnoDB: Could not open or create data files.\n"
1370
"InnoDB: If you tried to add new data files, and it failed here,\n"
1371
"InnoDB: you should now edit innodb_data_file_path in my.cnf back\n"
1372
"InnoDB: to what it was, and remove the new ibdata files InnoDB created\n"
1373
"InnoDB: in this failed attempt. InnoDB only wrote those files full of\n"
1374
"InnoDB: zeros, but did not yet use them in any way. But be careful: do not\n"
1375
"InnoDB: remove old data files which contain your precious data!\n");
1374
"InnoDB: Could not open or create data files.\n"
1375
"InnoDB: If you tried to add new data files,"
1376
" and it failed here,\n"
1377
"InnoDB: you should now edit innodb_data_file_path"
1379
"InnoDB: to what it was, and remove the"
1380
" new ibdata files InnoDB created\n"
1381
"InnoDB: in this failed attempt. InnoDB only wrote"
1382
" those files full of\n"
1383
"InnoDB: zeros, but did not yet use them in any way."
1384
" But be careful: do not\n"
1385
"InnoDB: remove old data files"
1386
" which contain your precious data!\n");
1377
1388
return((int) err);
1398
1409
if ((log_opened && create_new_db)
1399
1410
|| (log_opened && log_created)) {
1400
drizzled::errmsg_printf(drizzled::error::ERROR,
1401
"InnoDB: Error: all log files must be created at the same time.\n"
1402
"InnoDB: All log files must be created also in database creation.\n"
1403
"InnoDB: If you want bigger or smaller log files, shut down the\n"
1404
"InnoDB: database and make sure there were no errors in shutdown.\n"
1405
"InnoDB: Then delete the existing log files. Edit the .cnf file\n"
1412
"InnoDB: Error: all log files must be"
1413
" created at the same time.\n"
1414
"InnoDB: All log files must be"
1415
" created also in database creation.\n"
1416
"InnoDB: If you want bigger or smaller"
1417
" log files, shut down the\n"
1418
"InnoDB: database and make sure there"
1419
" were no errors in shutdown.\n"
1420
"InnoDB: Then delete the existing log files."
1421
" Edit the .cnf file\n"
1406
1422
"InnoDB: and start the database again.\n");
1408
1424
return(DB_ERROR);
1424
1440
|| max_arch_log_no != min_arch_log_no
1425
1441
#endif /* UNIV_LOG_ARCHIVE */
1427
drizzled::errmsg_printf(drizzled::error::ERROR,
1428
"InnoDB: Cannot initialize created log files because\n"
1429
"InnoDB: data files were not in sync with each other\n"
1444
"InnoDB: Cannot initialize created"
1445
" log files because\n"
1446
"InnoDB: data files were not in sync"
1447
" with each other\n"
1430
1448
"InnoDB: or the data files are corrupt.\n");
1432
1450
return(DB_ERROR);
1435
1453
if (max_flushed_lsn < (ib_uint64_t) 1000) {
1436
drizzled::errmsg_printf(drizzled::error::ERROR,
1437
"InnoDB: Cannot initialize created log files because\n"
1438
"InnoDB: data files are corrupt, or new data files were\n"
1439
"InnoDB: created when the database was started previous\n"
1440
"InnoDB: time but the database was not shut down\n"
1441
"InnoDB: normally after that.\n");
1455
"InnoDB: Cannot initialize created"
1456
" log files because\n"
1457
"InnoDB: data files are corrupt,"
1458
" or new data files were\n"
1459
"InnoDB: created when the database"
1460
" was started previous\n"
1461
"InnoDB: time but the database"
1462
" was not shut down\n"
1463
"InnoDB: normally after that.\n");
1443
1465
return(DB_ERROR);
1461
1483
if (create_new_db) {
1462
1484
mtr_start(&mtr);
1464
1485
fsp_header_init(0, sum_of_new_sizes, &mtr);
1466
1487
mtr_commit(&mtr);
1468
/* To maintain backward compatibility we create only
1469
the first rollback segment before the double write buffer.
1470
All the remaining rollback segments will be created later,
1471
after the double write buffer has been created. */
1472
1489
trx_sys_create();
1476
1491
srv_startup_is_before_trx_rollback_phase = FALSE;
1478
1493
#ifdef UNIV_LOG_ARCHIVE
1479
1494
} else if (srv_archive_recovery) {
1480
drizzled::errmsg_printf(drizzled::error::INFO,
1481
"InnoDB: Starting archive recovery from a backup...");
1496
"InnoDB: Starting archive"
1497
" recovery from a backup...\n");
1482
1498
err = recv_recovery_from_archive_start(
1483
1499
min_flushed_lsn, srv_archive_recovery_limit_lsn,
1484
1500
min_arch_log_no);
1629
1643
/* fprintf(stderr, "Max allowed record size %lu\n",
1630
1644
page_get_free_space_of_empty() / 2); */
1632
if (trx_doublewrite == NULL) {
1633
/* Create the doublewrite buffer to a new tablespace */
1635
trx_sys_create_doublewrite_buf();
1638
/* Here the double write buffer has already been created and so
1639
any new rollback segments will be allocated after the double
1640
write buffer. The default segment should already exist.
1641
We create the new segments only if it's a new database or
1642
the database was shutdown cleanly. */
1644
/* Note: When creating the extra rollback segments during an upgrade
1645
we violate the latching order, even if the change buffer is empty.
1646
We make an exception in sync0sync.c and check srv_is_being_started
1647
for that violation. It cannot create a deadlock because we are still
1648
running in single threaded mode essentially. Only the IO threads
1649
should be running at this stage. */
1651
trx_sys_create_rsegs(TRX_SYS_N_RSEGS - 1);
1653
1646
/* Create the thread which watches the timeouts for lock waits */
1654
1647
os_thread_create(&srv_lock_timeout_thread, NULL,
1655
1648
thread_ids + 2 + SRV_MAX_N_IO_THREADS);
1676
1675
os_thread_create(&srv_master_thread, NULL, thread_ids
1677
1676
+ (1 + SRV_MAX_N_IO_THREADS));
1679
/* Currently we allow only a single purge thread. */
1680
ut_a(srv_n_purge_threads == 0 || srv_n_purge_threads == 1);
1682
/* If the user has requested a separate purge thread then
1683
start the purge thread. */
1684
if (srv_n_purge_threads == 1) {
1685
os_thread_create(&srv_purge_thread, NULL, NULL);
1688
1677
#ifdef UNIV_DEBUG
1689
1678
/* buf_debug_prints = TRUE; */
1690
1679
#endif /* UNIV_DEBUG */
1699
1688
if (!srv_auto_extend_last_data_file
1700
1689
&& sum_of_data_file_sizes != tablespace_size_in_header) {
1702
drizzled::errmsg_printf(drizzled::error::ERROR,
1703
"InnoDB: Error: tablespace size stored in header is %lu pages, but the sum of data file sizes is %lu pages.",
1704
(ulong) tablespace_size_in_header,
1705
(ulong) sum_of_data_file_sizes);
1692
"InnoDB: Error: tablespace size"
1693
" stored in header is %lu pages, but\n"
1694
"InnoDB: the sum of data file sizes is %lu pages\n",
1695
(ulong) tablespace_size_in_header,
1696
(ulong) sum_of_data_file_sizes);
1707
1698
if (srv_force_recovery == 0
1708
1699
&& sum_of_data_file_sizes < tablespace_size_in_header) {
1709
1700
/* This is a fatal error, the tail of a tablespace is
1712
drizzled::errmsg_printf(drizzled::error::ERROR,
1713
"InnoDB: Cannot start InnoDB. The tail of the system tablespace is "
1714
"missing. Have you edited innodb_data_file_path in my.cnf in an "
1715
"inappropriate way, removing ibdata files from there? "
1716
"You can set innodb_force_recovery=1 in my.cnf to force "
1717
"a startup if you are trying to recover a badly corrupt database.");
1704
"InnoDB: Cannot start InnoDB."
1705
" The tail of the system tablespace is\n"
1706
"InnoDB: missing. Have you edited"
1707
" innodb_data_file_path in my.cnf in an\n"
1708
"InnoDB: inappropriate way, removing"
1709
" ibdata files from there?\n"
1710
"InnoDB: You can set innodb_force_recovery=1"
1711
" in my.cnf to force\n"
1712
"InnoDB: a startup if you are trying"
1713
" to recover a badly corrupt database.\n");
1719
1715
return(DB_ERROR);
1723
1719
if (srv_auto_extend_last_data_file
1724
1720
&& sum_of_data_file_sizes < tablespace_size_in_header) {
1726
drizzled::errmsg_printf(drizzled::error::ERROR,
1727
"InnoDB: Error: tablespace size stored in header is %lu pages, but the sum of data file sizes"
1728
" is only %lu pages\n",
1729
(ulong) tablespace_size_in_header,
1730
(ulong) sum_of_data_file_sizes);
1723
"InnoDB: Error: tablespace size stored in header"
1724
" is %lu pages, but\n"
1725
"InnoDB: the sum of data file sizes"
1726
" is only %lu pages\n",
1727
(ulong) tablespace_size_in_header,
1728
(ulong) sum_of_data_file_sizes);
1732
1730
if (srv_force_recovery == 0) {
1734
drizzled::errmsg_printf(drizzled::error::ERROR,
1735
"InnoDB: Cannot start InnoDB. The tail of the system tablespace is "
1736
"missing. Have you edited innodb_data_file_path in my.cnf in an "
1737
"inappropriate way, removing ibdata files from there? "
1738
"You can set innodb_force_recovery=1 in my.cnf to force "
1739
"a startup if you are trying to recover a badly corrupt database.\n");
1733
"InnoDB: Cannot start InnoDB. The tail of"
1734
" the system tablespace is\n"
1735
"InnoDB: missing. Have you edited"
1736
" innodb_data_file_path in my.cnf in an\n"
1737
"InnoDB: inappropriate way, removing"
1738
" ibdata files from there?\n"
1739
"InnoDB: You can set innodb_force_recovery=1"
1740
" in my.cnf to force\n"
1741
"InnoDB: a startup if you are trying to"
1742
" recover a badly corrupt database.\n");
1741
1744
return(DB_ERROR);
1746
1749
os_fast_mutex_init(&srv_os_test_mutex);
1748
1751
if (0 != os_fast_mutex_trylock(&srv_os_test_mutex)) {
1749
drizzled::errmsg_printf(drizzled::error::ERROR,
1750
"InnoDB: Error: pthread_mutex_trylock returns an unexpected value on success! Cannot continue.\n");
1753
"InnoDB: Error: pthread_mutex_trylock returns"
1754
" an unexpected value on\n"
1755
"InnoDB: success! Cannot continue.\n");
1760
1765
os_fast_mutex_free(&srv_os_test_mutex);
1762
1767
if (srv_print_verbose_log) {
1763
drizzled::errmsg_printf(drizzled::error::INFO,
1764
"InnoDB %s started; log sequence number %"PRIu64"\n",
1765
INNODB_VERSION_STR, srv_start_lsn);
1768
ut_print_timestamp(stderr);
1770
" InnoDB Plugin %s started; "
1771
"log sequence number %"PRIu64"\n",
1772
INNODB_VERSION_STR, srv_start_lsn);
1768
1775
if (srv_force_recovery > 0) {
1769
drizzled::errmsg_printf(drizzled::error::ERROR,
1770
"InnoDB: !!! innodb_force_recovery is set to %lu !!!\n",
1771
(ulong) srv_force_recovery);
1777
"InnoDB: !!! innodb_force_recovery"
1778
" is set to %lu !!!\n",
1779
(ulong) srv_force_recovery);
1774
1784
if (trx_doublewrite_must_reset_space_ids) {
1775
1785
/* Actually, we did not change the undo log format between
1776
1786
4.0 and 4.1.1, and we would not need to run purge to
1785
1795
4.1.1. It is essential that the insert buffer is emptied
1788
drizzled::errmsg_printf(drizzled::error::INFO,
1789
"InnoDB: You are upgrading to an InnoDB version which allows multiple. "
1790
"tablespaces. Wait that purge and insert buffer merge run to completion...");
1799
"InnoDB: You are upgrading to an"
1800
" InnoDB version which allows multiple\n"
1801
"InnoDB: tablespaces. Wait that purge"
1802
" and insert buffer merge run to\n"
1803
"InnoDB: completion...\n");
1792
1805
os_thread_sleep(1000000);
1802
drizzled::errmsg_printf(drizzled::error::INFO,
1803
"InnoDB: Full purge and insert buffer merge completed.");
1816
"InnoDB: Full purge and insert buffer merge"
1805
1819
trx_sys_mark_upgraded_to_multiple_tablespaces();
1807
drizzled::errmsg_printf(drizzled::error::INFO,
1808
"InnoDB: You have now successfully upgraded"
1809
" to the multiple tablespaces\n"
1810
"InnoDB: format. You should NOT DOWNGRADE"
1811
" to an earlier version of\n"
1812
"InnoDB: InnoDB! But if you absolutely need to"
1814
"InnoDB: " REFMAN "multiple-tablespaces.html\n"
1815
"InnoDB: for instructions.\n");
1822
"InnoDB: You have now successfully upgraded"
1823
" to the multiple tablespaces\n"
1824
"InnoDB: format. You should NOT DOWNGRADE"
1825
" to an earlier version of\n"
1826
"InnoDB: InnoDB! But if you absolutely need to"
1828
"InnoDB: " REFMAN "multiple-tablespaces.html\n"
1829
"InnoDB: for instructions.\n");
1818
1832
if (srv_force_recovery == 0) {
1840
1854
/*=============================*/
1858
extern ibool panic_shutdown;
1843
1860
if (!srv_was_started) {
1844
1861
if (srv_is_being_started) {
1845
drizzled::errmsg_printf(drizzled::error::ERROR,
1846
"InnoDB: Warning: shutting down a not properly started or created database!");
1862
ut_print_timestamp(stderr);
1864
" InnoDB: Warning: shutting down"
1865
" a not properly started\n"
1866
"InnoDB: or created database!\n");
1849
1869
return(DB_SUCCESS);
1858
1878
if (srv_fast_shutdown == 2) {
1859
drizzled::errmsg_printf(drizzled::error::INFO,
1860
"InnoDB: MySQL has requested a very fast shutdown without flushing "
1861
"the InnoDB buffer pool to data files. At the next mysqld startup "
1862
"InnoDB will do a crash recovery!");
1879
ut_print_timestamp(stderr);
1881
" InnoDB: MySQL has requested a very fast shutdown"
1882
" without flushing "
1883
"the InnoDB buffer pool to data files."
1884
" At the next mysqld startup "
1885
"InnoDB will do a crash recovery!\n");
1865
logs_empty_and_mark_files_at_shutdown();
1889
if (!panic_shutdown)
1891
logs_empty_and_mark_files_at_shutdown();
1867
1893
if (srv_conc_n_threads != 0) {
1868
drizzled::errmsg_printf(drizzled::error::WARN,
1869
"InnoDB: Warning: query counter shows %ld queries still InnoDB: inside InnoDB at shutdown.",
1870
srv_conc_n_threads);
1895
"InnoDB: Warning: query counter shows %ld queries"
1897
"InnoDB: inside InnoDB at shutdown\n",
1898
srv_conc_n_threads);
1873
1901
/* 2. Make all threads created by InnoDB to exit */
1932
1957
if (i == 1000) {
1933
drizzled::errmsg_printf(drizzled::error::WARN,
1934
"InnoDB: Warning: %lu threads created by InnoDB had not exited at shutdown!",
1959
"InnoDB: Warning: %lu threads created by InnoDB"
1960
" had not exited at shutdown!\n",
1935
1961
(ulong) os_thread_count);
1986
2012
pars_lexer_close();
1987
2013
log_mem_free();
1988
buf_pool_free(srv_buf_pool_instances);
1991
/* ut_free_all_mem() frees all allocated memory not freed yet
1992
in shutdown, and it will also free the ut_list_mutex, so it
1993
should be the last one for all operation */
1996
2018
if (os_thread_count != 0
1997
2019
|| os_event_count != 0
1998
2020
|| os_mutex_count != 0
1999
2021
|| os_fast_mutex_count != 0) {
2000
drizzled::errmsg_printf(drizzled::error::WARN,
2001
"InnoDB: Warning: some resources were not cleaned up in shutdown:\n"
2002
"InnoDB: threads %lu, events %lu, os_mutexes %lu, os_fast_mutexes %lu\n",
2003
(ulong) os_thread_count, (ulong) os_event_count,
2004
(ulong) os_mutex_count, (ulong) os_fast_mutex_count);
2023
"InnoDB: Warning: some resources were not"
2024
" cleaned up in shutdown:\n"
2025
"InnoDB: threads %lu, events %lu,"
2026
" os_mutexes %lu, os_fast_mutexes %lu\n",
2027
(ulong) os_thread_count, (ulong) os_event_count,
2028
(ulong) os_mutex_count, (ulong) os_fast_mutex_count);
2007
2031
if (dict_foreign_err_file) {
2014
2038
if (srv_print_verbose_log) {
2015
drizzled::errmsg_printf(drizzled::error::INFO,
2016
"InnoDB: Shutdown completed log sequence number %"PRIu64,
2039
ut_print_timestamp(stderr);
2041
" InnoDB: Shutdown completed;"
2042
" log sequence number %"PRIu64"\n",
2020
2046
srv_was_started = FALSE;
added
removed
plugin/innobase/srv/srv0start.c
