redguy

371 reputation

bio	website
	location
	age
visits	member for	5 months
	seen	May 19 at 14:27
stats	profile views	5

	371 reputation	bio	website		visits	member for	5 months
7 badges		location			seen	May 19 at 14:27

summary answers questions tags badges favorites bounties reputation activity

34 Actions

suggestions reviews revisions comments badges posts accepts all

Feb 18	awarded	Analytical
Feb 18	answered	Adding a user to MySQL with 'name'@'%' fails with ERROR 1396
Feb 4	awarded	Custodian
Feb 4	reviewed	Satisfactory mariadb ignoring force index
Feb 1	comment	compare the same table I can't see the two parts you're mentioning. Please fix your formatting and also show us what the shell script is doing.
Jan 31	answered	How to Perform Two Simple Queries using Select Value from First Query
Jan 31	comment	MySQL cannot start Well, the initcript didn't pass the innodb_force_recovery option to mysqld. Try putting it in [mysqld] section of /etc/mysql/my.cnf and then start mysqld
Jan 29	answered	MySQL Cluster - partitions on disk
Jan 29	answered	Mysql not closing connections
Jan 22	answered	Computer restarted and Postgres 9.2 service cannot be started?
Jan 14	awarded	Commentator
Jan 14	comment	MAX function and group by usage - postgresql If there are multiple values for a column within a group which value do you want to select? If you are certain that the columns you want to select have the same values when grouped by id add them to the group by clause
Dec 31	comment	Master - master replication not working Seems like a network connection problem. Perhaps firewall is blocking connections? Are you able to connect to MySQL from one server to another?
Dec 28	comment	MySQL Stalls and stops all queries fromdual.com/mysql-performance-tuning-key - another worthy link. It would be nice if you posted details if you come to some conclusions.
Dec 22	comment	MySQL Stalls and stops all queries At this point I would try to debug what is happening when the stall happens. On Linux you could use pt-stalk from Percona toolkit. Perhaps you can use it with recent Cygwin, ActiveStat perl with MySQL DBD module on Windows as well? It seems that you could use Maatkit on Windows, so perhaps pt-stalk will work.
Dec 22	answered	MySQL replication - some values are not being replicated
Dec 21	comment	MySQL Stalls and stops all queries Elaborate on "shut the INNODB down to not process anything then pick up and catch up". Can you connect to MySQL and query it? If so, are you seeing "too many connections" in mysql error log at some moment? Do you see any errors in the client application? Can you eliminate the client application and test how many connections your mysql can handle by some other means? Are the clients run from the same machine? How many open tcp porst does the machine running clients have?
Dec 21	comment	MySQL Stalls and stops all queries the user with SUPER privilege should be able to connect to MySQL even if you hit the too many connections MySQL error. Please provide SHOW VARIABLES and/or my.cnf. MySQL error log might also help.
Dec 21	comment	MySQL Stalls and stops all queries If flushing has been dealt with you might be hitting some platform limitation. Perhaps your architecture and/or environment is to blame? According to MySQL docs there is a limitation in open ports on some windows versions. Do you have any performance data during the stall and normal operation?
Dec 21	comment	MySQL replication - some values are not being replicated Slaves can be modified. There is a read_only system variable, but this won't prevent users with SUPER privilege from modifying the database.