Reputation
79,398
Next tag badge:
93/100 score
51/20 answers
Badges
11 81 184
Newest
 Enlightened
Impact
~7.1m people reached

2d
comment SQL Error (2027): Malformed packet
I would also make sure you are using the latest version of HeidiSQL, especially using the latest libmysql.dll. You may need to rollback to previous version of HeidiSQL.
May
26
comment How to speed up query containing concat() in WHERE clause?
How much free RAM do you have ???
May
26
comment How to speed up query containing concat() in WHERE clause?
Run SELECT data_length,index_length FROM information_schema.tables WHERE table_schema = 'database_where_table2_resides' AND table_name = 'table2';. What is the output ?
May
26
comment How to speed up query containing concat() in WHERE clause?
I have two questions : 1) How much RAM does the DB Server have ? 2) What is your key_buffer_size ? Please run SHOW GLOBAL VARIABLES LIKE 'key_buffer_size'; to find out.
May
25
comment Do I need a database license for my application?
I'm voting to close this question as off-topic because it's about Licensing
May
23
comment Grouping based on the status, then count its product and the total based on its category ID
This answer is very correct based on how the question was posed. Hey YuanChen, if you have more tables that require joining, please post a separate question that mentions all involved tables, not just pieces of information. This answer gets a +1 !!!
May
22
comment Delete and Recreate Indexes in MySQL to reduce table size for copying the db to a new server?
If your .MYI is larger than your .MYD, you may want to make sure you don't have needless indexes. Please look into using pt-duplicate-key-checker (percona.com/doc/percona-toolkit/2.1/…)
May
18
comment How do you minimize downtime for an ALTER?
Please note that I changed timpstmp from DATETIME to TIMESTAMP
May
18
comment How do you minimize downtime for an ALTER?
If you want the change the BIGINTs into INTs, you do that in sp_DeviceLog_Create
May
18
comment How do you minimize downtime for an ALTER?
The event will kick off at 11:45 PM every night.
May
18
comment How do you minimize downtime for an ALTER?
Please test this on a Dev or Staging Server. Do everything but the swap.
May
18
comment How do you minimize downtime for an ALTER?
Question: What is the unixtime field ???
May
18
comment How do you minimize downtime for an ALTER?
If you wanted this partitioned, which datetime would you want to partition by, created or timestmp ?
May
18
comment How do you minimize downtime for an ALTER?
Please run the SHOW CREATE TABLE mytable\G. I hope it has a TIMESTAMP or DATETIME in it. I think I can help you on this one.
May
18
comment Delete and Recreate Indexes in MySQL to reduce table size for copying the db to a new server?
@RickJames Please look at the thrid line in Step 02. He has to copy the blank .MYI. That way, Step 03 rebuild indexes starting the index structure only. I have done this before.
May
15
comment Show sql statements from mysql binlog (GTID)
Although you cannot see the original SQL with real column names, at least you know what it should be because you own the actual schema. Thus, row replication is secure in this aspect.
May
13
comment Need for backing up MySQL databases information_schema, performance_schema, mysql and phpmyadmin?
Instead of editing the question, please submit a separate question if there are more details involving doing the backups themselves.
May
12
comment How do I change the MySQL data folder path in a Mac?
Go to command line, and run mysqld --help --verbose > mysqld.txt. Look inside mysqld.txt. Do you see --install as a parameter option ?
May
12
comment Any disadvantages to enabling federated storage engine?
@user34606 Please carefully at my answer. I addressed his comment by pointing the security flaw even with his suggestion.
May
12
comment Convert date in date list condition to list of date ranges
May I get the bounty, please ???