Gecko [ italicatiles.com ]

Name	Size	Permission
aria_chk	5.33 MB	-rwxr-xr-x
aria_dump_log	5.14 MB	-rwxr-xr-x
aria_ftdump	5.15 MB	-rwxr-xr-x
aria_pack	5.17 MB	-rwxr-xr-x
aria_read_log	5.29 MB	-rwxr-xr-x
innochecksum	4.51 MB	-rwxr-xr-x
mariabackup	25.97 MB	-rwxr-xr-x
mariadb	5.2 MB	-rwxr-xr-x
mariadb-access	109.59 KB	-rwxr-xr-x
mariadb-admin	4.76 MB	-rwxr-xr-x
mariadb-backup	25.97 MB	-rwxr-xr-x
mariadb-binlog	5.01 MB	-rwxr-xr-x
mariadb-check	4.76 MB	-rwxr-xr-x
mariadb-client-test	5.22 MB	-rwxr-xr-x
mariadb-config	14.58 KB	-rwxr-xr-x
mariadb-conv	4.5 MB	-rwxr-xr-x
mariadb-convert-table-format	4.28 KB	-rwxr-xr-x
mariadb-dump	4.85 MB	-rwxr-xr-x
mariadb-dumpslow	8.19 KB	-rwxr-xr-x
mariadb-find-rows	3.35 KB	-rwxr-xr-x
mariadb-fix-extensions	1.31 KB	-rwxr-xr-x
mariadb-hotcopy	34.65 KB	-rwxr-xr-x
mariadb-import	4.75 MB	-rwxr-xr-x
mariadb-install-db	22.17 KB	-rwxr-xr-x
mariadb-ldb	8.63 MB	-rwxr-xr-x
mariadb-plugin	4.48 MB	-rwxr-xr-x
mariadb-secure-installation	13.7 KB	-rwxr-xr-x
mariadb-setpermission	17.7 KB	-rwxr-xr-x
mariadb-show	4.75 MB	-rwxr-xr-x
mariadb-slap	4.77 MB	-rwxr-xr-x
mariadb-test	5.49 MB	-rwxr-xr-x
mariadb-tzinfo-to-sql	4.48 MB	-rwxr-xr-x
mariadb-upgrade	4.91 MB	-rwxr-xr-x
mariadb-waitpid	4.47 MB	-rwxr-xr-x
mariadb_config	14.58 KB	-rwxr-xr-x
mariadbd-multi	27.1 KB	-rwxr-xr-x
mariadbd-safe	30.66 KB	-rwxr-xr-x
mariadbd-safe-helper	4.44 MB	-rwxr-xr-x
mbstream	4.51 MB	-rwxr-xr-x
msql2mysql	1.43 KB	-rwxr-xr-x
my_print_defaults	4.47 MB	-rwxr-xr-x
myisam_ftdump	4.75 MB	-rwxr-xr-x
myisamchk	4.87 MB	-rwxr-xr-x
myisamlog	4.73 MB	-rwxr-xr-x
myisampack	4.77 MB	-rwxr-xr-x
myrocks_hotbackup	24.46 KB	-rwxr-xr-x
mysql	5.2 MB	-rwxr-xr-x
mysql_client_test	5.22 MB	-rwxr-xr-x
mysql_config	4.57 KB	-rwxr-xr-x
mysql_convert_table_format	4.28 KB	-rwxr-xr-x
mysql_find_rows	3.35 KB	-rwxr-xr-x
mysql_fix_extensions	1.31 KB	-rwxr-xr-x
mysql_install_db	22.17 KB	-rwxr-xr-x
mysql_ldb	8.63 MB	-rwxr-xr-x
mysql_plugin	4.48 MB	-rwxr-xr-x
mysql_secure_installation	13.7 KB	-rwxr-xr-x
mysql_setpermission	17.7 KB	-rwxr-xr-x
mysql_tzinfo_to_sql	4.48 MB	-rwxr-xr-x
mysql_upgrade	4.91 MB	-rwxr-xr-x
mysql_waitpid	4.47 MB	-rwxr-xr-x
mysqlaccess	109.59 KB	-rwxr-xr-x
mysqladmin	4.76 MB	-rwxr-xr-x
mysqlbinlog	5.01 MB	-rwxr-xr-x
mysqlcheck	4.76 MB	-rwxr-xr-x
mysqld_multi	27.1 KB	-rwxr-xr-x
mysqld_safe	30.66 KB	-rwxr-xr-x
mysqld_safe_helper	4.44 MB	-rwxr-xr-x
mysqldump	4.85 MB	-rwxr-xr-x
mysqldumpslow	8.19 KB	-rwxr-xr-x
mysqlhotcopy	34.65 KB	-rwxr-xr-x
mysqlimport	4.75 MB	-rwxr-xr-x
mysqlshow	4.75 MB	-rwxr-xr-x
mysqlslap	4.77 MB	-rwxr-xr-x
mysqltest	5.49 MB	-rwxr-xr-x
mytop	71.96 KB	-rwxr-xr-x
perror	4.67 MB	-rwxr-xr-x
replace	4.45 MB	-rwxr-xr-x
resolve_stack_dump	4.47 MB	-rwxr-xr-x
resolveip	4.47 MB	-rwxr-xr-x
sst_dump	4.2 MB	-rwxr-xr-x
wsrep_sst_backup	2.39 KB	-rwxr-xr-x
wsrep_sst_common	65.72 KB	-rw-r--r--
wsrep_sst_mariabackup	50.94 KB	-rwxr-xr-x
wsrep_sst_mysqldump	8.04 KB	-rwxr-xr-x
wsrep_sst_rsync	29.7 KB	-rwxr-xr-x
wsrep_sst_rsync_wan	29.7 KB	-rwxr-xr-x

Name

Size

Permission

Action

aria_chk

5.33 MB

-rwxr-xr-x

aria_dump_log

5.14 MB

-rwxr-xr-x

aria_ftdump

5.15 MB

-rwxr-xr-x

aria_pack

5.17 MB

-rwxr-xr-x

aria_read_log

5.29 MB

-rwxr-xr-x

innochecksum

4.51 MB

-rwxr-xr-x

mariabackup

25.97 MB

-rwxr-xr-x

mariadb

5.2 MB

-rwxr-xr-x

mariadb-access

109.59 KB

-rwxr-xr-x

mariadb-admin

4.76 MB

-rwxr-xr-x

mariadb-backup

25.97 MB

-rwxr-xr-x

mariadb-binlog

5.01 MB

-rwxr-xr-x

mariadb-check

4.76 MB

-rwxr-xr-x

mariadb-client-test

5.22 MB

-rwxr-xr-x

mariadb-config

14.58 KB

-rwxr-xr-x

mariadb-conv

4.5 MB

-rwxr-xr-x

mariadb-convert-table-format

4.28 KB

-rwxr-xr-x

mariadb-dump

4.85 MB

-rwxr-xr-x

mariadb-dumpslow

8.19 KB

-rwxr-xr-x

mariadb-find-rows

3.35 KB

-rwxr-xr-x

mariadb-fix-extensions

1.31 KB

-rwxr-xr-x

mariadb-hotcopy

34.65 KB

-rwxr-xr-x

mariadb-import

4.75 MB

-rwxr-xr-x

mariadb-install-db

22.17 KB

-rwxr-xr-x

mariadb-ldb

8.63 MB

-rwxr-xr-x

mariadb-plugin

4.48 MB

-rwxr-xr-x

mariadb-secure-installation

13.7 KB

-rwxr-xr-x

mariadb-setpermission

17.7 KB

-rwxr-xr-x

mariadb-show

4.75 MB

-rwxr-xr-x

mariadb-slap

4.77 MB

-rwxr-xr-x

mariadb-test

5.49 MB

-rwxr-xr-x

mariadb-tzinfo-to-sql

4.48 MB

-rwxr-xr-x

mariadb-upgrade

4.91 MB

-rwxr-xr-x

mariadb-waitpid

4.47 MB

-rwxr-xr-x

mariadb_config

14.58 KB

-rwxr-xr-x

mariadbd-multi

27.1 KB

-rwxr-xr-x

mariadbd-safe

30.66 KB

-rwxr-xr-x

mariadbd-safe-helper

4.44 MB

-rwxr-xr-x

mbstream

4.51 MB

-rwxr-xr-x

msql2mysql

1.43 KB

-rwxr-xr-x

my_print_defaults

4.47 MB

-rwxr-xr-x

myisam_ftdump

4.75 MB

-rwxr-xr-x

myisamchk

4.87 MB

-rwxr-xr-x

myisamlog

4.73 MB

-rwxr-xr-x

myisampack

4.77 MB

-rwxr-xr-x

myrocks_hotbackup

24.46 KB

-rwxr-xr-x

mysql

5.2 MB

-rwxr-xr-x

mysql_client_test

5.22 MB

-rwxr-xr-x

mysql_config

4.57 KB

-rwxr-xr-x

mysql_convert_table_format

4.28 KB

-rwxr-xr-x

mysql_find_rows

3.35 KB

-rwxr-xr-x

mysql_fix_extensions

1.31 KB

-rwxr-xr-x

mysql_install_db

22.17 KB

-rwxr-xr-x

mysql_ldb

8.63 MB

-rwxr-xr-x

mysql_plugin

4.48 MB

-rwxr-xr-x

mysql_secure_installation

13.7 KB

-rwxr-xr-x

mysql_setpermission

17.7 KB

-rwxr-xr-x

mysql_tzinfo_to_sql

4.48 MB

-rwxr-xr-x

mysql_upgrade

4.91 MB

-rwxr-xr-x

mysql_waitpid

4.47 MB

-rwxr-xr-x

mysqlaccess

109.59 KB

-rwxr-xr-x

mysqladmin

4.76 MB

-rwxr-xr-x

mysqlbinlog

5.01 MB

-rwxr-xr-x

mysqlcheck

4.76 MB

-rwxr-xr-x

mysqld_multi

27.1 KB

-rwxr-xr-x

mysqld_safe

30.66 KB

-rwxr-xr-x

mysqld_safe_helper

4.44 MB

-rwxr-xr-x

mysqldump

4.85 MB

-rwxr-xr-x

mysqldumpslow

8.19 KB

-rwxr-xr-x

mysqlhotcopy

34.65 KB

-rwxr-xr-x

mysqlimport

4.75 MB

-rwxr-xr-x

mysqlshow

4.75 MB

-rwxr-xr-x

mysqlslap

4.77 MB

-rwxr-xr-x

mysqltest

5.49 MB

-rwxr-xr-x

mytop

71.96 KB

-rwxr-xr-x

perror

4.67 MB

-rwxr-xr-x

replace

4.45 MB

-rwxr-xr-x

resolve_stack_dump

4.47 MB

-rwxr-xr-x

resolveip

4.47 MB

-rwxr-xr-x

sst_dump

4.2 MB

-rwxr-xr-x

wsrep_sst_backup

2.39 KB

-rwxr-xr-x

wsrep_sst_common

65.72 KB

-rw-r--r--

wsrep_sst_mariabackup

50.94 KB

-rwxr-xr-x

wsrep_sst_mysqldump

8.04 KB

-rwxr-xr-x

wsrep_sst_rsync

29.7 KB

-rwxr-xr-x

wsrep_sst_rsync_wan

29.7 KB

-rwxr-xr-x

Code Editor : mariadb-find-rows

#!/usr/bin/perl
# Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
# 
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
# 
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
# 
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1335  USA

$version="1.02";

use Getopt::Long;

warn "$0: Deprecated program name. It will be removed in a future release, use 'mariadb-find-rows' instead\n"
  if $0 =~ m/mysql_find_rows$/;

$opt_help=$opt_Information=$opt_skip_use_db=0;
$opt_regexp=$opt_dbregexp=".*";
$opt_start_row=1; $opt_rows=9999999999;

GetOptions("Information","help","regexp=s","start_row=i","rows=i",
	   "dbregexp=s", "skip-use-db")
  || usage();
usage() if ($opt_help || $opt_Information);

$query=$search=$database=$set=""; $eoq=0;
while (<>)
{
  next if (length($query) == 0 && /^\#/); # Skip comments
  $query.=search($_);
  if ($eoq)
  {
    if ($query =~ /^use /i || $query =~ /^SET / ||
	($query =~ /$opt_regexp/o && $database =~ /$opt_dbregexp/o))
    {
      if ($opt_skip_use_db && $query =~ /^use /i)
      {
	$query="";
	next;
      }
      if ($opt_start_row <= 1)
      {
	if ($database)
	{
	  print $database, $set;
	  $database=$set="";
	}
	print $query;
	last if (--$opt_rows == 0);
      }
      else
      {
	$opt_start_row--;
	if ($query =~ /^use /)
	{
	  $database=$query;
	  $set="";
	}
	elsif ($query =~ /^SET/)
	{
	  $set=$query;
	}
	else
	{
	  $set="";
	}
      }
    }
    $query=""; $search=""; $eoq=0;
  }
}

exit 0;

sub search
{
  my($row)=shift;
  my($i);

for ($i=0 ; $i < length($row) ; $i++)
  {
    if (length($search))
    {
      if (length($search) > 1)
      {				# Comment
	next if (substr($row,$i,length($search)) ne $search);
	$i+=length($search)-1;
	$search="";
      }
      elsif (substr($row,$i,1) eq '\\') # Escaped char in string
      {
	$i++;
      }
      elsif (substr($row,$i,1) eq $search)
      {
	if (substr($row,$i+1,1) eq $search)	# Double " or '
	{
	  $i++;
	}
	else
	{
	  $search="";
	}
      }
      next;	
    }
    if (substr($row,$i,2) eq '/*')	# Comment
    {
      $search="*/";
      $i++;
    }
    elsif (substr($row,$i,1) eq "'" || substr($row,$i,1) eq '"')
    {
      $search=substr($row,$i,1);
     }
  }
  $eoq=1 if (!length($search) && $row =~ /;\s*$/);
  return $row;
}

sub usage
{
    print <<EOF;
$0  Ver $version

Prints all SQL queries that matches a regexp or contains a 'use
database' or 'set ..' command to stdout.  A SQL query may contain
newlines.  This is useful to find things in a MariaDB update log.

$0 takes the following options:

--help or --Information
  Shows this help

--regexp=#
  Print queries that matches this.

--start_row=#
  Start output from this row (first row = 1)

--skip-use-db
  Don\'t include \'use database\' commands in the output.

--rows=#
  Quit after this many rows.

Example:

$0 --regexp "problem_table" < update.log

$0 --regexp "problem_table" update-log.1 update-log.2
EOF
  exit(0);
}

${this.title}

Code Editor : mariadb-find-rows