210 reputation
29
bio website
location
age
visits member for 2 years, 5 months
seen Apr 17 at 3:57

Apr
24
awarded  Tumbleweed
Apr
17
comment What is the best way to manage user access to MySQL via PHP?
As Leonard has said, you should limit the types of queries different users can make. Don't give write access, or ALTER TABLE access, to users that only need to read data.
Apr
17
asked MySQL - How to grant read access to all tables, write access to a few, to one user for multiple databases?
Feb
11
comment Preordering the table by a specified column
I couldn't figure out why my InnoDB table was not ordered by its primary key until I saw this answer. I thought it was called a "composite index" rather than "clustered index," but either way I now see that the table is ordered by my 2nd column, which is part of such an index (along with column 3).
Jan
30
awarded  Yearling
Jan
9
awarded  Popular Question
Jul
23
comment How can I speed up “show columns” on MySQL?
+1 for putting [mysqld] there. It might be obvious to many that this setting would go under mysqld, but may not be obvious for those who would ask this question. By the way, this sped up SELECT COUNT(*) on one of my information_schema tables to 6 seconds from over a minute. Still slow, but a huge improvement.
Jul
3
comment Mysql Innodb: InnoDB: ERROR: the age of the last checkpoint is InnoDB: which exceeds the log group capacity
Wouldn't it be advisable to copy the ib_logfile* to another location for backup before deleting them?
Jun
5
revised Why would increase in innodb_buffer_pool_size slow down MySQL?
added results of shell commands while mysql process is running
Jun
4
comment Why would increase in innodb_buffer_pool_size slow down MySQL?
@RolandoMySQLDBA I added the query results to the question. I can rerun the shell commands during the process tonight.
Jun
4
revised Why would increase in innodb_buffer_pool_size slow down MySQL?
added results of suggested queries
Jun
4
comment Why would increase in innodb_buffer_pool_size slow down MySQL?
@RolandoMySQLDBA I added them but those were run NOT during the process in question. I can give you the output while the process is running if you want.
Jun
4
revised Why would increase in innodb_buffer_pool_size slow down MySQL?
added details on the queries being performed and some shell command output
Jun
4
revised Why would increase in innodb_buffer_pool_size slow down MySQL?
added details on the queries being performed and some shell command output
Jun
4
comment Why would increase in innodb_buffer_pool_size slow down MySQL?
@ShlomiNoach the database has been in use for months and the server is never off (just occasionally rebooted). I will add some information about the operations the db is performing to my question.
Jun
4
revised Why would increase in innodb_buffer_pool_size slow down MySQL?
added system RAM, and added OS
Jun
4
awarded  Commentator
Jun
4
comment Why would increase in innodb_buffer_pool_size slow down MySQL?
Very good point but I should probably have mentioned that the system has 32GB RAM and nothing else intensive running on it. So this is probably not the right answer.
Jun
4
asked Why would increase in innodb_buffer_pool_size slow down MySQL?
Jun
4
awarded  Notable Question