Skip to content

SYN, SYN-ACK, ACK

Henrik Damgaard

Categories

  • Active Directory (1)
  • MySQL (1)
  • Other (2)
  • PHP (1)
  • Scripting (8)
    • PowerShell (8)
  • System Center Operations Manager (4)
  • Ubuntu (1)
    • GNOME (1)
  • Windows (11)
    • Client (6)
      • Internet Explorer (1)
    • Server (4)
  • WordPress (2)

Anything in here will be replaced on browsers that support the canvas element

  • PowerShell
  • Windows Client
  • Scripting
  • Windows Server
  • EventLog
  • 2007 R2
  • SCOM
  • System Center Operations Manager
  • OpsMgr
  • Windows
  • Command line
  • WordPress
  • database
  • remote
  • COM
  • Attribute
  • PHP
  • Install
  • Virtual Machine
  • FTP
  • Internet Explorer 9
  • Windows Explorer
  • ValidateCount
  • ValidateLength
  • ValidatePattern
  • ValidateRange
  • ValidateSet
  • ValidateScript
  • Events
  • IE9

Visitors

RECENT POSTS

  • How to Change File Properties (ReadOnly, CreationTime etc.) Using PowerShell
  • Hyper-V on Windows 8 (Pro or Enterprise)
  • PDF Search missing in Windows 7 (64-Bit)
  • Running a headless VirtualBox
  • Atheros AR5007 failed to connect (WiFi/Internet)

QR Code

RSS SYN, SYN-ACK, ACK

  • How to Change File Properties (ReadOnly, CreationTime etc.) Using PowerShell 11/04/2013
    Changing file properties is quite easy with PowerShell.   Remove ReadOnly attribute: Set-ItemProperty -Path 'C:\Program Files\desktop.ini' -Name IsReadOnly -Value $false   Change CreationTime (90 days back in time): Set-ItemProperty -Path 'C:\Program Files\desktop.ini' -Name CreationTime -Value ((Get-Date).AddDays(-90))      
    Henrik Damgaard
  • Hyper-V on Windows 8 (Pro or Enterprise) 24/03/2013
    Looking for a hypervisor on Windows 8? Look no further. If your Windows 8 is Pro or Enterprise Hyper-V is available as a feature, and can be enabled easily as long as your system complies with there requirements: Windows 8 Pro or Windows 8 Enterprise (64-bit Operating System) Minimum of 4GB of RAM Hardware Assisted Virtualization […]
    Henrik Damgaard
  • PDF Search missing in Windows 7 (64-Bit) 02/03/2013
    For some reason the 64-bit versions of Windows has a problem indexing PDF files. Windows Search uses IFilter to help it index files, and the PDF IFilter for 64-bit Windows is missing. (This probably applies to 64-bit Vista and 64-bit XP as well). To detect whether a computer has the IFilter installed or not open […]
    Henrik Damgaard
  • Running a headless VirtualBox 05/02/2013
      Use this command to start headless VirtualBox named NameOfVirtualBox: Start /b 'C:\Program Files\Oracle\VirtualBox\VBoxHeadless.exe' -s "NameOfVirtualBox" Or using PowerShell: Start-Process -FilePath 'C:\Program Files\Oracle\VirtualBox\VBoxHeadless.exe' -ArgumentList @("-s","NameOfVirtualBox") -NoNewWindow   Note: If you close your command prompt the processes with your headless VirtualBox will get killed.   Link to VirtualBox manual : http://www.virtualbox.org/manual/ch07.html#vboxheadless
    Henrik Damgaard
  • Atheros AR5007 failed to connect (WiFi/Internet) 10/01/2013
    Problem: This behaviour is seen when connecting a Vista computer with Atheros AR5007 Wireless LAN adapter installed to a new wireless accesspoint. (In this case a HP laptop computer with preinstalled Vista Home Premium connecting to Cisco Linksys EA6500). When inspecting network configuration you will find DHCP-address is assigned correctly – BUT no traffic is recieved […]
    Henrik Damgaard
  • Easy validating parameter input using ValidateCount, ValidateLength, ValidatePattern, ValidateRange, ValidateSet and ValidateScript in PowerShell 14/08/2012
    Windows PowerShell introduced parameter validation which drastically reduces lines of validation code – and replaces it with a couple of markup tags:   ValidateCount (int minLength, int maxlength) How many arguments are allowed for a parameter. [ValidateCount(1,3)] [String[]] $Collection ValidateLength (int minLength, int maxlength) Length (in characters) of a parameter argument. [ValidateLength(1,8)] [String[]] $Phone ValidatePattern (string regexString, Named Parameters) Valid patterns […]
    Henrik Damgaard
  • SCOM Health Service Events when troubleshooting certificate authentication 11/08/2012
    These Events are common when troubleshooting problems related to Health Service certificates i System Center Operations Manager 2007:   21021 – Could not load Certificate Check if certificate exists and the Health Service has permissions to read it.   20052 – Certificate not loaded (name does not match) Make sure Issued To match the actual […]
    Henrik Damgaard
  • Browse FTP site in Windows Explorer (triggered from Internet Explorer 9) 08/08/2012
    By default the option to view FTP site in Windows Explorer is hidden in Internet Explorer 9 (IE9). To enable it you have to go to Internet Options -> Advanced -> Enable FTP Folder View as shown below: Once this option is enabled you should see Open FTP Site in Windows Explorer in the View-menu. (Keep in mind […]
    Henrik Damgaard
  • Blue Screen of Death (BSoD) when putting Windows 7 to sleep 30/07/2012
    All of a sudden my Windows 7 ended up crashing with Blue Screen of Death when put to sleep, and I started investigating this behavior. After a couple of crashes a pattern started to emerge: Blue Screen of Death was only an issue when the laptop was running on batteries – and NOT when AC was […]
    Henrik Damgaard
  • Write Event to Windows Event Log using PowerShell 27/06/2012
      Creating an EventLog entry using PowerShell is shown below: Write-EventLog -LogName 'Application' -Source 'MyEventSource' -EventID 1000 -EntryType Warning -Message "This is a test of writing to the Event Log using PowerShell."   Note: The Event Source needs to be created before writing entries to the Event Log. (See this post for further info: Create […]
    Henrik Damgaard

Tags

  • 2007 R2
  • Adobe
  • AR5007
  • Atheros
  • Attribute
  • Certificates
  • COM
  • Command line
  • database
  • Driver
  • Enterprise
  • EventLog
  • Events
  • Feature
  • FTP
  • Health Service
  • HP
  • Hypervisor
  • iFilter
  • Install
  • Laptop
  • Network
  • OpsMgr
  • PHP
  • PowerShell
  • Pro
  • remote
  • SCOM
  • Scripting
  • System Center Operations Manager
  • ValidateCount
  • ValidateLength
  • ValidatePattern
  • ValidateRange
  • ValidateScript
  • ValidateSet
  • Virtual Machine
  • Vista
  • WiFi
  • Windows
  • Windows 8
  • Windows Client
  • Windows Server
  • Wireless
  • WordPress

Category: MySQL

Get size of MySQL database using SELECT statement

Use this MySQL to get size of database:

 

SELECT table_schema "DatabaseName", SUM(index_length+data_length)/1024/1024 "DatabaseSizeMB" FROM information_schema.TABLES GROUP BY table_schema;

 

 

Posted on 27/01/201229/02/2012Author Henrik DamgaardCategories MySQLTags database, MySQL, Select, SizeLeave a comment on Get size of MySQL database using SELECT statement
Proudly powered by WordPress