Reputation
Next tag badge:
385/400 score
208/80 answers
Badges
12 88 203
Newest
 Revival
Impact
~7.8m people reached

19m
comment Recover mysql using data folder
Questions : 1) Do you have anything in /var/lib/mysql right now ? 2) Do you have an existing /etc/my.cnf ?
20h
comment What's faster: two UPDATEs with WHERE (in / not in) or one UPDATE with CASE?
@ypercube That would be more readable and concise
21h
comment Modulo operator with nonintegers - unexpected results
This makes sense to me. +1 !!!
1d
comment Deleting bin logs in replication environment
@ninjabber Having a slave with binary logging enabled that will never be a Master merely slows down the WH from receiving writes because it already has disk I/O replicating through relay logs. Binary logging on the Slave creates double the disk I/O. Where I work now, all Slaves have binary logging enabled for the sole purpose of failing over applications to the Slave. You should setup a separate Slave for performing backups only. That way, you could take snapshots of the binary logs on that Slave as part of the backup process. You would want a WH to have the data written as fast as possible.
1d
comment MySQL Multi-Master Replication Topology
Yes. Those values are stored in a file called master.info. This is not a static file. It updates the log file and log position on the fly. As long as the file is present, mysqld will detect its presence and setup replication. It will start replication for you unless --skip-slave-start in embedded in my.cnf.
Jul
26
comment Is my import still committing?
Did the script contain any ALTER TABLE commands ?
Jul
24
comment Sudden MySQL freeze, with spike in dirty pages, but without obvious write queries
You said The system has 128GB of memory, with an allocated buffer pool of 112GB. MySQL is v5.6.24. but your buffer pool is only 24G. Is this a dedicated MySQL server or is there a full stack in the server (Nagios, Munin, Tomcat, Apache, PHP, things like these) ?
Jul
24
comment Mysql permissions help
You are so asking for security issues !!!
Jul
24
comment Delete trigger mysql on another table
Questions: 1) Are the person and ldap_entries tables using InnoDB ? 2) Is there a foreign key relationship between these two tables ? 3) Can you post the table structure of each table into your question ?
Jul
24
comment Sudden MySQL freeze, with spike in dirty pages, but without obvious write queries
Please post output of SHOW GLOBAL VARIABLES LIKE 'innodb%';
Jul
24
comment mysqldump error on common_schema
Here is the author's profile : dba.stackexchange.com/users/10090/shlomi-noach
Jul
24
comment mysqldump error on common_schema
What is interesting here is that the creator of common_schema is here in the DBA StackExchange. Hey, @ShlomiNoach. This is in your realm of expertise. Any ideas on how to properly mysqldump common_schema or is installation the only way ??? (I would wait for an answer from him)
Jul
24
comment mysqldump error on common_schema
That seems strange. The documentation says common_schema should have 27 views. You only have 19. (common-schema.googlecode.com/svn/trunk/common_schema/doc/html/…)
Jul
24
comment mysqldump error on common_schema
Run SELECT COUNT(1) table_count,engine FROM information_schema.tables WHERE table_schema='common_schema' GROUP BY engine; What is the output ???
Jul
24
comment mysqldump error on common_schema
Please connect to MySQL and run SELECT USER() AttemptedToLogin,CURRENT_USER() AllowedToLogin;. What is the output ??? I just want to make sure you have full privileges.
Jul
23
comment Mysql shutting down during a mysqldump of a specific database
Updated my answer ...
Jul
23
comment Mysql shutting down during a mysqldump of a specific database
Also, tell me, what is the name of the trouble table ???
Jul
23
comment Mysql shutting down during a mysqldump of a specific database
Is the entire database InnoDB or are there any MyISAM tables in the mix ???
Jul
23
comment Mysql shutting down during a mysqldump of a specific database
You will have to rm -f /var/lock/subsys/mysql. Then, start mysql
Jul
23
comment Mysql shutting down during a mysqldump of a specific database
Is it crashing on the same table ?