SQL log file parser

To add to @MaLiN223's answer, I think adding each line to lines is unnecessary and leads to weird looping behavior. You'll wind up looping over earlier lines multiple times. For example:

lines = []

lines.append('a')
for line in lines:
    print(line)

# a

lines.append('b')
for line in lines:
    print(line)

# a
# b

I'm not sure if that's the desired behavior or not, you might need to take another look at what you're trying to accomplish. I would say it's much better to keep it as a single for loop

str.strip()

You are using excess memory and losing readability by creating new objects from baris and calling them different things. You don't use the original baris past the re.sub part, so you carry around extra objects. I would keep the name baris, as it's clear what it is: it's your looping variable:

for baris in data:
    baris = baris.rstrip() 
    baris = re.sub(r'\t|\n|\r|\s{2,}',' ', baris)

re.compile

The benefit of re.compile is you cut way down on the overhead required to re-parse your regular expression, especially in a loop:

python -m timeit -s 'import re; x = "abc123"' 'for i in range(100000): re.match("\w\d", x)'
10 loops, best of 3: 64.1 msec per loop

python -m timeit -s 'import re; x = "abc123"; y = re.compile("\w\d")' 'for i in range(100000): y.match(x)'
10 loops, best of 3: 27.8 msec per loop

However, by compiling inside a loop, you lose that benefit entirely. I would move these regular expressions:

befSelect   = re.compile(r'^.+?(?=SELECT)')
date        = re.search(r"\b(\d{6})(?=\s\d{1,}:\d{2}:\d{2})\b", line)
select      = re.search(r'\b(SELECT)\b',line)
parentheses = re.compile('[(){}]')

Up to the top, outside of your with open statement. This way you aren't re-compiling during every line, even if you don't need to.

So your regex should look like:

def getSelectMySql(log):
    befSelect_re   = re.compile(r'^.+?(?=SELECT)')
    date_re        = re.compile(r"\b(\d{6})(?=\s\d{1,}:\d{2}:\d{2})\b")
    select_re      = re.compile(r'\b(SELECT)\b')
    parentheses_re = re.compile('[(){}]')

    with open....:
        ~snip~
        for baris in data:
            ~snip~
            # compiled regex supports search, sub, find, etc.
            date = date_re.search(baris)
            select = select_re.search(baris)

            ~snip~
                baris = befSelect_re.sub('', baris)
                baris = parentheses_re.sub('', baris)

Value of success

One of the big problems I see is that you are re-setting success = False during every iteration of the file handle. I would set that outside of the for loop:

success = False
with open...

However, this brings up a new logical flow question. In your if statement:

if baris.endswith("important") or baris.endswith("'%general_log%'") or baris.endswith("puro"):
    success = True if baris.endswith("important") else False

It seems odd to check for all of them if you are going to re-check again. I'd break this into multiple statements:

if baris.endswith("important"):
    success = True
elif baris.endswith("'%general_log%'") or baris.endswith("puro"):
    success = False
else:
    # put this in one line. The ternary operator will evaluate early
    # if success is False, avoiding the rest of the boolean checks
    if success and select and not baris.endswith("SELECT"):
        ...

Overall, keeping things as a single loop will keep memory overhead down for large files, allow you to iterate over the lines once and only once, and keep your variables relatively easy to track:

def getSelectMySql(log):
    befSelect_re   = re.compile(r'^.+?(?=SELECT)')
    date_re        = re.compile(r"\b(\d{6})(?=\s\d{1,}:\d{2}:\d{2})\b")# (\d{1,}:\d{2}:\d{2})
    select_re      = re.compile(r'\b(SELECT)\b')
    parentheses_re = re.compile('[(){}]')
    spacing = re.compile(r'\t|\n|\r|\s{2,}')
    success = False

    with open(log,'r', encoding='utf-8', errors='ignore') as data:
        for baris in data:
            baris      = baris.rstrip()
            baris      = spacing.sub(' ', baris)
            result, buffer = [], []
            date        = date_re.search(baris)
            select      = select_re.search(baris)

            if date:
                dat = datetime.datetime.strptime(date.group(), '%y%m%d').strftime('%Y-%m-%d')
                if buffer:
                    result.append(tuple(buffer))
                    buffer.clear()
                buffer.append(dat)
            if baris.endswith("important"):
                success = True
            elif baris.endswith("'%general_log%'") or baris.endswith("puro"):
                success = False
            else:
                # this will terminate early if success is false
                # and won't evaluate the rest of the expression
                if success and select and not baris.endswith("SELECT"):
                    baris = befSelect_re.sub('', baris)
                    baris = parentheses_re.sub('', baris)
                    buffer.append(baris)
            result.append(tuple(buffer))
        print('Done\n')
        return result
```