#!ipxe
set fog-ip 192.168.10.238
set fog-webroot fog
set boot-url http://${fog-ip}/${fog-webroot}
kernel http://10.21.40.39/fog/service/ipxe/bzImage32 loglevel=4 initrd=init_32.xz root=/dev/ram0 rw ramdisk_size=127000 web=http://192.168.10.238/fog/ consoleblank=0 rootfstype=ext4 mac=c0:3f:d5:9d:e9:50 ftp=10.21.40.39 storage=10.21.40.39:/images/ storageip=10.21.40.39 osid=9 irqpoll hostname=PC3181 chkdsk=0 img=Win10x64-1703-R1 imgType=n imgPartitionType=all imgid=124 imgFormat=0 PIGZ_COMP=-6 adon=1 addomain="MTSTRANS.COM" adou="" aduser="Administrator" adpass="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" isdebug=yes type=down
imgfetch http://10.21.40.39/fog/service/ipxe/init_32.xz
boot
Posts
-
RE: DHCP problems on storage nodesposted in FOG Problems
-
RE: DHCP problems on storage nodesposted in FOG Problems
#!ipxe set fog-ip 192.168.10.238 set fog-webroot fog set boot-url http://${fog-ip}/${fog-webroot} cpuid --ext 29 && set arch x86_64 || set arch i386 goto get_console :console_set colour --rgb 0x00567a 1 || colour --rgb 0x00567a 2 || colour --rgb 0x00567a 4 || cpair --foreground 7 --background 2 2 || goto MENU :alt_console cpair --background 0 1 || cpair --background 1 2 || goto MENU :get_console console --picture http://10.21.40.39/fog/service/ipxe/bg.png --left 100 --right 80 && goto console_set || goto alt_console :MENU menu colour --rgb 0x00567a 0 || cpair --foreground 1 1 || cpair --foreground 0 3 || cpair --foreground 4 4 || item --gap Host is registered as PC3181! item --gap -- ------------------------------------- item fog.local Boot from hard disk item fog.memtest Run Memtest86+ item fog.keyreg Update Product Key item fog.deployimage Deploy Image item fog.multijoin Join Multicast Session item fog.quickdel Quick Host Deletion item fog.sysinfo Client System Information (Compatibility) item fog.iso Boot from ISO CD item fog.Nuke Fast wipe Hard Disk choose --default fog.local --timeout 5000 target && goto ${target} :fog.local chain -ar ${boot-url}/service/ipxe/grub.exe --config-file="rootnoverify (hd0);chainloader +1" || goto MENU :fog.memtest kernel http://10.21.40.39/fog/service/ipxe/memdisk initrd=http://10.21.40.39/fog/service/ipxe/memtest.bin iso raw initrd http://10.21.40.39/fog/service/ipxe/memtest.bin boot || goto MENU :fog.keyreg login params param mac0 ${net0/mac} param arch ${arch} param username ${username} param password ${password} param keyreg 1 isset ${net1/mac} && param mac1 ${net1/mac} || goto bootme isset ${net2/mac} && param mac2 ${net2/mac} || goto bootme param sysuuid ${uuid} :fog.deployimage login params param mac0 ${net0/mac} param arch ${arch} param username ${username} param password ${password} param qihost 1 isset ${net1/mac} && param mac1 ${net1/mac} || goto bootme isset ${net2/mac} && param mac2 ${net2/mac} || goto bootme param sysuuid ${uuid} :fog.multijoin login params param mac0 ${net0/mac} param arch ${arch} param username ${username} param password ${password} param sessionJoin 1 isset ${net1/mac} && param mac1 ${net1/mac} || goto bootme isset ${net2/mac} && param mac2 ${net2/mac} || goto bootme param sysuuid ${uuid} :fog.quickdel login params param mac0 ${net0/mac} param arch ${arch} param username ${username} param password ${password} param delhost 1 isset ${net1/mac} && param mac1 ${net1/mac} || goto bootme isset ${net2/mac} && param mac2 ${net2/mac} || goto bootme param sysuuid ${uuid} :fog.sysinfo kernel http://10.21.40.39/fog/service/ipxe/bzImage32 loglevel=4 initrd=init_32.xz root=/dev/ram0 rw ramdisk_size=127000 web=http://192.168.10.238/fog/ consoleblank=0 rootfstype=ext4 storage=10.21.40.39:/images/ storageip=10.21.40.39 loglevel=4 mode=sysinfo imgfetch http://10.21.40.39/fog/service/ipxe/init_32.xz boot || goto MENU :fog.iso menu passwd 707376 :MENU menu item --gap -- ---------------- iPXE boot menu ---------------- item CENTOS6532 CentOS-6.5 Net Install 32BIT item CENTOS6564 CentOS-6.5 Net Install 64BIT item CENTOS7MIN64 CentOS-7.0 Minimal 64BIT item CENTOS7NET64 CentOS-7.0 Net Install 64BIT item KaliLinux Kali Linux 2016 64BIT item RocksCluster Rocks Cluster 64BIT item SpinRite6 SprinRite 6 item return return to previous menu choose --default return --timeout 5000 target && goto ${target} :CENTOS6532 initrd http://${fog-ip}/ISO/CentOS-6.5-i386-netinstall.iso chain memdisk iso raw || goto MENU :CENTOS6564 initrd http://${fog-ip}/ISO/CentOS-6.5-x86_64-netinstall.iso chain memdisk iso raw || goto MENU :CENTOS7MIN64 initrd http://${fog-ip}/ISO/CentOS-7.0-1406-x86_64-Minimal.iso chain memdisk iso raw || goto MENU :CENTOS7NET64 initrd http://${fog-ip}/ISO/CentOS-7.0-1406-x86_64-NetInstall.iso chain memdisk iso raw || goto MENU :KaliLinux initrd http://${fog-ip}/ISO/kali-linux-2016.2-amd64.iso chain memdisk iso raw || goto MENU :RocksCluster initrd http://${fog-ip}/ISO/RocksCluster.iso chain memdisk iso raw || goto MENU :SpinRite6 initrd http://${fog-ip}/ISO/SpinRite6.iso chain memdisk iso raw || goto MENU :return chain http://${fog-ip}/${fog-webroot}/service/ipxe/boot.php?mac=${net0/mac} || prompt goto MENU autoboot param sysuuid ${uuid} :fog.Nuke kernel http://10.21.40.39/fog/service/ipxe/bzImage32 loglevel=4 initrd=init_32.xz root=/dev/ram0 rw ramdisk_size=127000 web=http://192.168.10.238/fog/ consoleblank=0 rootfstype=ext4 storage=10.21.40.39:/images/ storageip=10.21.40.39 loglevel=4 capone=1 mode=wipe wipemode=fast mac=00:00:00:00:00:00 imgfetch http://10.21.40.39/fog/service/ipxe/init_32.xz boot || goto MENU :bootme chain -ar http://10.21.40.39/fog/service/ipxe/boot.php##params || goto MENU autoboot``` -
RE: DHCP problems on storage nodesposted in FOG Problems
@george1421
run it from the client i am trying to image? or from any workstation? -
RE: DHCP problems on storage nodesposted in FOG Problems
10.21.40.39 is the storage node for that location.
192.168.10.238 is the main fog server that is the management interface. -
RE: DHCP problems on storage nodesposted in FOG Problems
Just a heads up… I wasn’t having this issue until I recently updated, but I cannot remember what build I was on.
-
RE: DHCP problems on storage nodesposted in FOG Problems
@george1421
I checked the storage node and its looks correct:#!ipxe cpuid --ext 29 && set arch x86_64 || set arch i386 params param mac0 ${net0/mac} param arch ${arch} param platform ${platform} param product ${product} param manufacturer ${product} param ipxever ${version} param filename ${filename} isset ${net1/mac} && param mac1 ${net1/mac} || goto bootme isset ${net2/mac} && param mac2 ${net2/mac} || goto bootme :bootme chain http://10.21.40.39/fog/service/ipxe/boot.php##paramsthe fogserver was installed with this IP.
-
RE: DHCP problems on storage nodesposted in FOG Problems
@george1421
What files do i need to check and make sure they are pointing to the proper IP or hostname? -
RE: Organizations Using FOGposted in General
Organization Name: Martin Transportation Systems, Inc
Location (Optional) Byron Center, MI
30 Remote Locations
Approximate Number of systems: 500+How long:5+ years
-
Fogproject Discord Channelposted in General
I think it would be great if we had a Fogroject discord channel for people to discuss issues and get help what do you all think?
-
DHCP problems on storage nodesposted in FOG Problems
Fog version 1.5.0-RC-10 / Centos 7
Storage node 1.5.0-RC-10 / Centos 7When trying to deploy an image to a host from a storage node I get this error on the client PC.
It looks like its getting 2 different IP addresses for some reason. First IP is 10.21.100.120 and then it drops it and get 10.21.100.115…
First screen:
Second Screen:
I have verified that the port is set for:
spanning-tree portfast
spanning-tree bpduguard enableThanks!
-
RE: Upgrade Problems with .crtposted in FOG Problems
I think it is generating a new .crt on upgrade. permissions are all the same.
-
Upgrade Problems with .crtposted in FOG Problems
Everytime I upgrade fog I have to replace the /var/www/html/fog/management/other/ssl/srvpublic.crt from a backup or my clients wont work. Is there something I need to change in /opt/fog/.fogsettings?
-
RE: Login takes 5minutes+posted in FOG Problems
@george1421
I would love to optimize our FOG install if you have the time to tell me what to do.Thanks!
-
RE: Login takes 5minutes+posted in FOG Problems
Ok, I found the issue I was having with logging in. I had about 5 storage nodes enabled on the home screens graph, Once i disabled those I was able to login immediately. The submit a task still takes about 1 minutes or 2 but its allot better!
Thanks
-
RE: Login takes 5minutes+posted in FOG Problems
@george1421
Ok, I removed the CDROM device. I don’t know how long it takes for the changes to speed things up but I haven’t seen any noticeable differences yet. -
RE: Login takes 5minutes+posted in FOG Problems
I forgot to mention that the Fogserver is also handleing dhcp for 4 subnets.
-
RE: Login takes 5minutes+posted in FOG Problems
@george1421 I changed the CPU cout from 8 to 4 like you suggested.
Initial load:
Then it calmed down after a bit:
The Centos CDROM is already disconnected:
I am going to change the check-in time to 300 as suggested.I ran these commands against the DB
# No password: mysql -D fog #Password: mysql --user=UsernameHere --password=PasswordHere -D fog DELETE FROM `hosts` WHERE `hostID` = '0'; DELETE FROM `hostMAC` WHERE hmID = '0' OR `hmHostID` = '0'; DELETE FROM `groupMembers` WHERE `gmID` = '0' OR `gmHostID` = '0' OR `gmGroupID` = '0'; DELETE FROM `snapinGroupAssoc` WHERE `sgaID` = '0' OR `sgaSnapinID` = '0' OR `sgaStorageGroupID` = '0'; DELETE from `snapinAssoc` WHERE `saID` = '0' OR `saHostID` = '0' OR `saSnapinID` = '0'; DELETE FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmHostID` FROM `hostMAC` WHERE `hmPrimary` = '1'); DELETE FROM `hosts` WHERE `hostID` NOT IN (SELECT `hmHostID` FROM `hostMAC`); DELETE FROM `hostMAC` WHERE `hmhostID` NOT IN (SELECT `hostID` FROM `hosts`); DELETE FROM `snapinAssoc` WHERE `saHostID` NOT IN (SELECT `hostID` FROM `hosts`); DELETE FROM `groupMembers` WHERE `gmHostID` NOT IN (SELECT `hostID` FROM `hosts`); DELETE FROM `tasks` WHERE `taskStateID` IN ("1","2","3"); DELETE FROM `snapinTasks` WHERE `stState` in ("1","2","3"); quitI will report back with results later.
Thanks for your help. -
RE: Login takes 5minutes+posted in FOG Problems
@george1421 We have about 300-350 devices that have the fog client on them. The check-in time is set to 60
top - 09:07:59 up 7 days, 19:33, 1 user, load average: 1.17, 1.31, 1.43 Tasks: 252 total, 1 running, 219 sleeping, 0 stopped, 32 zombie %Cpu(s): 8.9 us, 7.3 sy, 0.0 ni, 83.6 id, 0.0 wa, 0.0 hi, 0.3 si, 0.0 st KiB Mem : 32781540 total, 19782616 free, 1078612 used, 11920312 buff/cache KiB Swap: 2113532 total, 2113532 free, 0 used. 30939180 avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 6113 mysql 20 0 4836488 318604 9824 S 17.9 1.0 16:12.44 mysqld 26475 apache 20 0 511360 18684 5876 S 11.0 0.1 4:04.53 httpd 23587 apache 20 0 511376 18644 5828 S 10.0 0.1 0:18.85 httpd 2359 root 20 0 600128 144776 3372 S 9.3 0.4 316:39.16 FOGMulticastMan 23833 apache 20 0 405724 16412 5692 S 9.0 0.1 0:17.46 httpd 3517 apache 20 0 509312 16592 5840 S 7.6 0.1 3:31.70 httpd 15452 apache 20 0 509312 16572 5820 S 7.3 0.1 0:28.50 httpd 1596 apache 20 0 405724 16432 5704 S 7.0 0.1 1:41.93 httpd 20671 apache 20 0 491256 21800 8332 S 7.0 0.1 0:27.31 httpd 1693 apache 20 0 594856 19916 8444 S 6.3 0.1 3:46.10 httpd 19659 apache 20 0 405724 16432 5704 S 6.3 0.1 0:32.84 httpd 3532 apache 20 0 509312 16584 5820 S 3.0 0.1 3:11.70 httpd 2363 root 20 0 337980 12456 4068 S 1.0 0.0 202:29.76 FOGSnapinReplic 951 zerotie+ 20 0 8464 5868 1148 S 0.7 0.0 17:47.85 zerotier-one 2358 root 20 0 340028 13744 3380 S 0.7 0.0 18:23.66 FOGPingHosts 9 root 20 0 0 0 0 S 0.3 0.0 40:21.65 rcu_sched 460 root 20 0 0 0 0 S 0.3 0.0 6:03.11 xfsaild/dm-1 1198 dhcpd 20 0 127524 28084 3908 S 0.3 0.1 35:55.33 dhcpd 2362 root 20 0 337980 11652 3392 S 0.3 0.0 77:21.13 FOGSnapinHash 22067 root 20 0 0 0 0 S 0.3 0.0 0:01.76 kworker/3:2
The fogserver is hosted by vmware ESXI 6.0 but its the only VM on the host.
The Disks are 3 3Gig backplane 500Gig 7.2k drive in a raid 5 configuration.
Its been slow for some time I cant really think of anything that triggered it.MariaDB [(none)]> SHOW STATUS WHERE `variable_name` = 'Threads_connected'; +-------------------+-------+ | Variable_name | Value | +-------------------+-------+ | Threads_connected | 133 | +-------------------+-------+MariaDB [(none)]> show session status; +------------------------------------------+-------------+ | Variable_name | Value | +------------------------------------------+-------------+ | Aborted_clients | 0 | | Aborted_connects | 0 | | Access_denied_errors | 0 | | Aria_pagecache_blocks_not_flushed | 0 | | Aria_pagecache_blocks_unused | 15737 | | Aria_pagecache_blocks_used | 15737 | | Aria_pagecache_read_requests | 2845483 | | Aria_pagecache_reads | 390002 | | Aria_pagecache_write_requests | 350074 | | Aria_pagecache_writes | 153860 | | Aria_transaction_log_syncs | 6 | | Binlog_commits | 0 | | Binlog_group_commits | 0 | | Binlog_snapshot_file | | | Binlog_snapshot_position | 0 | | Binlog_bytes_written | 0 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Binlog_stmt_cache_disk_use | 0 | | Binlog_stmt_cache_use | 0 | | Busy_time | 0.000000 | | Bytes_received | 725 | | Bytes_sent | 2242 | | Com_admin_commands | 0 | | Com_alter_db | 0 | | Com_alter_db_upgrade | 0 | | Com_alter_event | 0 | | Com_alter_function | 0 | | Com_alter_procedure | 0 | | Com_alter_server | 0 | | Com_alter_table | 0 | | Com_alter_tablespace | 0 | | Com_analyze | 0 | | Com_assign_to_keycache | 0 | | Com_begin | 0 | | Com_binlog | 0 | | Com_call_procedure | 0 | | Com_change_db | 0 | | Com_change_master | 0 | | Com_check | 0 | | Com_checksum | 0 | | Com_commit | 0 | | Com_create_db | 0 | | Com_create_event | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_procedure | 0 | | Com_create_server | 0 | | Com_create_table | 0 | | Com_create_trigger | 0 | | Com_create_udf | 0 | | Com_create_user | 0 | | Com_create_view | 0 | | Com_dealloc_sql | 0 | | Com_delete | 0 | | Com_delete_multi | 0 | | Com_do | 0 | | Com_drop_db | 0 | | Com_drop_event | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_procedure | 0 | | Com_drop_server | 0 | | Com_drop_table | 0 | | Com_drop_trigger | 0 | | Com_drop_user | 0 | | Com_drop_view | 0 | | Com_empty_query | 0 | | Com_execute_sql | 0 | | Com_flush | 0 | | Com_grant | 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 0 | | Com_insert | 0 | | Com_insert_select | 0 | | Com_install_plugin | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_preload_keys | 0 | | Com_prepare_sql | 0 | | Com_purge | 0 | | Com_purge_before_date | 0 | | Com_release_savepoint | 0 | | Com_rename_table | 0 | | Com_rename_user | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_resignal | 0 | | Com_revoke | 0 | | Com_revoke_all | 0 | | Com_rollback | 0 | | Com_rollback_to_savepoint | 0 | | Com_savepoint | 0 | | Com_select | 1 | | Com_set_option | 0 | | Com_show_authors | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_charsets | 0 | | Com_show_client_statistics | 0 | | Com_show_collations | 0 | | Com_show_contributors | 0 | | Com_show_create_db | 0 | | Com_show_create_event | 0 | | Com_show_create_func | 0 | | Com_show_create_proc | 0 | | Com_show_create_table | 0 | | Com_show_create_trigger | 0 | | Com_show_databases | 0 | | Com_show_engine_logs | 0 | | Com_show_engine_mutex | 0 | | Com_show_engine_status | 0 | | Com_show_errors | 0 | | Com_show_events | 0 | | Com_show_fields | 0 | | Com_show_function_status | 0 | | Com_show_grants | 0 | | Com_show_index_statistics | 0 | | Com_show_keys | 0 | | Com_show_master_status | 0 | | Com_show_open_tables | 0 | | Com_show_plugins | 0 | | Com_show_privileges | 0 | | Com_show_procedure_status | 0 | | Com_show_processlist | 0 | | Com_show_profile | 0 | | Com_show_profiles | 0 | | Com_show_relaylog_events | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 0 | | Com_show_status | 11 | | Com_show_storage_engines | 0 | | Com_show_table_statistics | 0 | | Com_show_table_status | 0 | | Com_show_tables | 0 | | Com_show_triggers | 0 | | Com_show_user_statistics | 0 | | Com_show_variables | 0 | | Com_show_warnings | 0 | | Com_signal | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_stmt_close | 0 | | Com_stmt_execute | 0 | | Com_stmt_fetch | 0 | | Com_stmt_prepare | 0 | | Com_stmt_reprepare | 0 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 0 | | Com_truncate | 0 | | Com_uninstall_plugin | 0 | | Com_unlock_tables | 0 | | Com_update | 0 | | Com_update_multi | 0 | | Com_xa_commit | 0 | | Com_xa_end | 0 | | Com_xa_prepare | 0 | | Com_xa_recover | 0 | | Com_xa_rollback | 0 | | Com_xa_start | 0 | | Compression | OFF | | Connections | 190057 | | Cpu_time | 0.000000 | | Created_tmp_disk_tables | 0 | | Created_tmp_files | 18 | | Created_tmp_tables | 0 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Empty_queries | 0 | | Executed_events | 0 | | Executed_triggers | 0 | | Feature_dynamic_columns | 0 | | Feature_fulltext | 0 | | Feature_gis | 0 | | Feature_locale | 0 | | Feature_subquery | 0 | | Feature_timezone | 0 | | Feature_trigger | 0 | | Feature_xml | 0 | | Flush_commands | 2 | | Handler_commit | 0 | | Handler_delete | 0 | | Handler_discover | 0 | | Handler_icp_attempts | 0 | | Handler_icp_match | 0 | | Handler_mrr_init | 0 | | Handler_mrr_key_refills | 0 | | Handler_mrr_rowid_refills | 0 | | Handler_prepare | 0 | | Handler_read_first | 0 | | Handler_read_key | 0 | | Handler_read_last | 0 | | Handler_read_next | 0 | | Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_deleted | 0 | | Handler_read_rnd_next | 0 | | Handler_rollback | 0 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_tmp_update | 0 | | Handler_tmp_write | 0 | | Handler_update | 0 | | Handler_write | 0 | | Innodb_adaptive_hash_cells | 276671 | | Innodb_adaptive_hash_hash_searches | 0 | | Innodb_adaptive_hash_heap_buffers | 0 | | Innodb_adaptive_hash_non_hash_searches | 19 | | Innodb_background_log_sync | 1 | | Innodb_buffer_pool_bytes_data | 2359296 | | Innodb_buffer_pool_bytes_dirty | 0 | | Innodb_buffer_pool_pages_data | 144 | | Innodb_buffer_pool_pages_dirty | 0 | | Innodb_buffer_pool_pages_flushed | 0 | | Innodb_buffer_pool_pages_free | 8047 | | Innodb_buffer_pool_pages_LRU_flushed | 0 | | Innodb_buffer_pool_pages_made_not_young | 0 | | Innodb_buffer_pool_pages_made_young | 0 | | Innodb_buffer_pool_pages_misc | 0 | | Innodb_buffer_pool_pages_old | 0 | | Innodb_buffer_pool_pages_total | 8191 | | Innodb_buffer_pool_read_ahead | 0 | | Innodb_buffer_pool_read_ahead_evicted | 0 | | Innodb_buffer_pool_read_ahead_rnd | 0 | | Innodb_buffer_pool_read_requests | 464 | | Innodb_buffer_pool_reads | 145 | | Innodb_buffer_pool_wait_free | 0 | | Innodb_buffer_pool_write_requests | 0 | | Innodb_checkpoint_age | 0 | | Innodb_checkpoint_max_age | 7782360 | | Innodb_checkpoint_target_age | 7539162 | | Innodb_current_row_locks | 0 | | Innodb_data_fsyncs | 3 | | Innodb_data_pending_fsyncs | 0 | | Innodb_data_pending_reads | 0 | | Innodb_data_pending_writes | 0 | | Innodb_data_read | 4559360 | | Innodb_data_reads | 156 | | Innodb_data_writes | 3 | | Innodb_data_written | 1536 | | Innodb_dblwr_pages_written | 0 | | Innodb_dblwr_writes | 0 | | Innodb_deadlocks | 0 | | Innodb_descriptors_memory | 8000 | | Innodb_dict_tables | 8 | | Innodb_have_atomic_builtins | ON | | Innodb_history_list_length | 1 | | Innodb_ibuf_discarded_delete_marks | 0 | | Innodb_ibuf_discarded_deletes | 0 | | Innodb_ibuf_discarded_inserts | 0 | | Innodb_ibuf_free_list | 0 | | Innodb_ibuf_merged_delete_marks | 0 | | Innodb_ibuf_merged_deletes | 0 | | Innodb_ibuf_merged_inserts | 0 | | Innodb_ibuf_merges | 0 | | Innodb_ibuf_segment_size | 2 | | Innodb_ibuf_size | 1 | | Innodb_log_waits | 0 | | Innodb_log_write_requests | 0 | | Innodb_log_writes | 1 | | Innodb_lsn_current | 1604920 | | Innodb_lsn_flushed | 1604920 | | Innodb_lsn_last_checkpoint | 1604920 | | Innodb_master_thread_1_second_loops | 1 | | Innodb_master_thread_10_second_loops | 0 | | Innodb_master_thread_background_loops | 1 | | Innodb_master_thread_main_flush_loops | 1 | | Innodb_master_thread_sleeps | 1 | | Innodb_max_trx_id | 2816 | | Innodb_mem_adaptive_hash | 2217584 | | Innodb_mem_dictionary | 593780 | | Innodb_mem_total | 137756672 | | Innodb_mutex_os_waits | 0 | | Innodb_mutex_spin_rounds | 74 | | Innodb_mutex_spin_waits | 3 | | Innodb_oldest_view_low_limit_trx_id | 2816 | | Innodb_os_log_fsyncs | 3 | | Innodb_os_log_pending_fsyncs | 0 | | Innodb_os_log_pending_writes | 0 | | Innodb_os_log_written | 512 | | Innodb_page_size | 16384 | | Innodb_pages_created | 0 | | Innodb_pages_read | 144 | | Innodb_pages_written | 0 | | Innodb_purge_trx_id | 0 | | Innodb_purge_undo_no | 0 | | Innodb_read_views_memory | 88 | | Innodb_row_lock_current_waits | 0 | | Innodb_row_lock_time | 0 | | Innodb_row_lock_time_avg | 0 | | Innodb_row_lock_time_max | 0 | | Innodb_row_lock_waits | 0 | | Innodb_rows_deleted | 0 | | Innodb_rows_inserted | 0 | | Innodb_rows_read | 0 | | Innodb_rows_updated | 0 | | Innodb_s_lock_os_waits | 2 | | Innodb_s_lock_spin_rounds | 60 | | Innodb_s_lock_spin_waits | 2 | | Innodb_truncated_status_writes | 0 | | Innodb_x_lock_os_waits | 0 | | Innodb_x_lock_spin_rounds | 0 | | Innodb_x_lock_spin_waits | 0 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 104134 | | Key_blocks_used | 3037 | | Key_blocks_warm | 440 | | Key_read_requests | 89289782 | | Key_reads | 2993 | | Key_write_requests | 42576 | | Key_writes | 3217 | | Last_query_cost | 0.000000 | | Max_used_connections | 182 | | Not_flushed_delayed_rows | 0 | | Open_files | 241 | | Open_streams | 0 | | Open_table_definitions | 89 | | Open_tables | 190 | | Opened_files | 400301 | | Opened_table_definitions | 0 | | Opened_tables | 0 | | Opened_views | 0 | | Performance_schema_cond_classes_lost | 0 | | Performance_schema_cond_instances_lost | 0 | | Performance_schema_file_classes_lost | 0 | | Performance_schema_file_handles_lost | 0 | | Performance_schema_file_instances_lost | 0 | | Performance_schema_locker_lost | 0 | | Performance_schema_mutex_classes_lost | 0 | | Performance_schema_mutex_instances_lost | 0 | | Performance_schema_rwlock_classes_lost | 0 | | Performance_schema_rwlock_instances_lost | 0 | | Performance_schema_table_handles_lost | 0 | | Performance_schema_table_instances_lost | 0 | | Performance_schema_thread_classes_lost | 0 | | Performance_schema_thread_instances_lost | 0 | | Prepared_stmt_count | 0 | | Qcache_free_blocks | 0 | | Qcache_free_memory | 0 | | Qcache_hits | 0 | | Qcache_inserts | 0 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 0 | | Qcache_queries_in_cache | 0 | | Qcache_total_blocks | 0 | | Queries | 7008184 | | Questions | 12 | | Rows_read | 0 | | Rows_sent | 1 | | Rows_tmp_read | 10 | | Rpl_status | AUTH_MASTER | | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 0 | | Select_range_check | 0 | | Select_scan | 0 | | Slave_heartbeat_period | 0.000 | | Slave_open_temp_tables | 0 | | Slave_received_heartbeats | 0 | | Slave_retried_transactions | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 0 | | Sort_merge_passes | 0 | | Sort_range | 0 | | Sort_rows | 0 | | Sort_scan | 0 | | Ssl_accept_renegotiates | 0 | | Ssl_accepts | 0 | | Ssl_callback_cache_hits | 0 | | Ssl_cipher | | | Ssl_cipher_list | | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_ctx_verify_depth | 0 | | Ssl_ctx_verify_mode | 0 | | Ssl_default_timeout | 0 | | Ssl_finished_accepts | 0 | | Ssl_finished_connects | 0 | | Ssl_session_cache_hits | 0 | | Ssl_session_cache_misses | 0 | | Ssl_session_cache_mode | NONE | | Ssl_session_cache_overflows | 0 | | Ssl_session_cache_size | 0 | | Ssl_session_cache_timeouts | 0 | | Ssl_sessions_reused | 0 | | Ssl_used_session_cache_entries | 0 | | Ssl_verify_depth | 0 | | Ssl_verify_mode | 0 | | Ssl_version | | | Subquery_cache_hit | 0 | | Subquery_cache_miss | 0 | | Syncs | 12 | | Table_locks_immediate | 10617136 | | Table_locks_waited | 557 | | Tc_log_max_pages_used | 0 | | Tc_log_page_size | 0 | | Tc_log_page_waits | 0 | | Threadpool_idle_threads | 0 | | Threadpool_threads | 0 | | Threads_cached | 0 | | Threads_connected | 132 | | Threads_created | 190056 | | Threads_running | 1 | | Uptime | 8349 | | Uptime_since_flush_status | 8349 | +------------------------------------------+-------------+ -
RE: Login takes 5minutes+posted in FOG Problems
@sebastian-roth my max_connections is set to 500 I dont know the command to check current connections.