1,252 reputation
718
bio website blog.9minutesnooze.com
location New York, United States
age
visits member for 5 years, 1 month
seen Jun 18 at 22:17

Dec
6
comment flush tables in the Locked state
What does the entire SHOW FULL PROCESSLIST look like while the locks are occurring? What you have shown above only shows SELECT statements, which, unless they are FOR UPDATE, won't lock anything and don't provide any insight. You have 128MB query cache but only a 100MB key buffer. How much memory is available on this server? What is the ratio of reads to writes? The query cache is almost never valuable. The biggest thing you can tune on a MyISAM workload is the key_buffer_size and you should make it as large as you can.
Dec
3
comment flush tables in the Locked state
What does the rest of the process list show? If tables are locked, there is something locking them, likely a long running insert, update, delete, insert select, or select for update. Also, please post your my.cnf settings. attack the cause (queries that are causing locking), not the symptom ( locked tables)
Nov
25
comment flush tables in the Locked state
You say you can't switch to InnoDB -- why?
Nov
15
comment Is EBS naturally CPU-hungry?
what does iostat -x 1 say while you are running the cpu intensive process. It sounds like you might just have high iowait time.
Nov
10
comment How do I quickly create new instances of complex MySQL database?
Fair enough. Legacy architecture is a pain.
Nov
9
comment How do I quickly create new instances of complex MySQL database?
This doesn't sound scalable at all. Every user gets their own database? How large could your user base potentially get?
Nov
9
comment Tuning MySQL and Linux to reduce maximum response time specifically
Your question lacks detail so it's impossible to provide any reasonable answers. What are your queries like? What is the read/write ratio? What hardware are you running on? Are the outliers similar queries? What does your my.cnf currently look like? What version of MySQL? One thing I can guarantee you is that you will have better and more consistent performance running Percona Server than running community MySQL.
Nov
2
answered What's the mean time between failure for EC2?
Oct
23
comment InnoDB recovery
Did MySQL stay up after recovery? Did you try what I mentioned? Specifically, did you try dumping & loading theSYS_IBUF_TABLE_0? Did you try lower recovery levels first as I mentioned?
Oct
23
comment msyql replication time
I don't understand your question. Do you want to enforce a delay in replication between the master and the slave? Are you looking to configure the reconnect time? I think you might be misunderstanding MySQL replication - the slave I/O thread maintains a persistent connection to the master. It doesn't poll it periodically.
Oct
23
answered InnoDB recovery
Oct
23
comment InnoDB recovery
It would be helpful if you posted the crash itself. Usually it contains information about what page was a problem.
Oct
12
answered moving a mysql slave to a new host : Failed to open the relay log
Oct
12
comment MySQL 5.1 Replication Topologies: Multi-Master
Are you looking to run active/active multi-master? If so, why?
Oct
12
comment How to scale out mySQL with many Database Server (say 20 database servers)
Might want to read this before you start down the MMM route: xaprb.com/blog/2011/05/04/whats-wrong-with-mmm ...and in the comments, the author of MMM (Alexey Kovyrin) wrote: "I’m the original author of MMM and I completely agree with you. Every time I try to add HA to my clusters I remember MMM and want to stab myself because I simply could not trust my data to the tool and there is nothing else available on the market to do the job reliably."
Oct
12
comment MySQL multi level replication breaks constantly
+1 on checking that the server_id is globally unique across the cluster.
Oct
12
comment MySQL multi level replication breaks constantly
also check the mysql error log. There might be something valuable in there.
Oct
12
answered MySQL multi level replication breaks constantly
Oct
12
answered MySQL: How to backup and restore using different schema name using xtrabackup
Sep
19
comment Pacemaker complex resource colocation
No responses? What can I do to improve this question?