Reputation
12,010
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 13 35
Newest
 Revival
Impact
~758k people reached

Dec
20
comment Similar hardware, Same DBconfiguration and Database but different status variables result between Windows and Linux server
qcache_free_blocks is a count of contiguous blocks and tells you nothing about the block size; a totally empty query cache on a newly started server has exactly 1 free block. dba.stackexchange.com/questions/33811/…
Dec
20
reviewed Close Similar hardware, Same DBconfiguration and Database but different status variables result between Windows and Linux server
Dec
20
reviewed Close GROUP BY Returning Different Totals
Dec
20
reviewed Close Companies and addresses MySQL
Dec
19
answered Processlist show most of the queries are sending data for select query
Dec
19
comment Can we protect data form Database Administrator by encrypting the data?
If you have a concern that the database administrator will steal your data, then you have a problem that cannot be solved with technology.
Dec
19
answered storing query results in a variable in mysql and using it in another query
Dec
18
revised MySQL audit storing application user ID
typos, add docs link
Dec
18
answered MySQL audit storing application user ID
Dec
17
comment After mysql server restarts I cannot see my own database
Why did you rename my.cnf?
Dec
14
comment ERROR 2013 (HY000) When long string data managed
"nothing seems to work" is a somewhat vague description of what you tried and didn't work. Where, specifically, did you change the setting for max_allowed_packet? There are separate settings for server and client, and Lost connection to MySQL server during query (I assume is the error message you see, you didn't include the actual text) suggests a client setting that's too small.
Dec
14
comment Could not start mysql or MariaDB. Permissions were ok, but mysql-bin.index permission error
What about the directory permissions on /var/lib/mysql itself? Error 13 on Linux is "Permission denied." (Use $perror 13 from the shell prompt to check error code 13)
Dec
13
comment Should tables with very large records quantities be split into multiple tables
It's most certainly not "absolutely true." Splitting tables can cause problems of its own, as queries should (arguably) never have to blur the line between object identifiers and data... the name of the table where a given row will be found should not typically be something you ever have to construct (e.g. a "transactions_2014" table, for transactions in a particular year, 2014).
Dec
12
reviewed Leave Open How To Strip Hebrew Accent Marks
Dec
12
reviewed Close MySQL Multi Count
Dec
12
reviewed Close Determine the name of the column with a null value nearest the last column
Dec
12
answered MySQL unique index only if column has specific value
Dec
11
answered Use of IN clause within a DELETE command - MySQL
Dec
11
comment Is there a SELECT statement to subtract rows of the same column?
Subtract them from what?
Dec
9
answered What's the approach to figure out reason for mysql crash?