meta user
network profile
| bio | website | |
|---|---|---|
| location | Hyderabad/chennai | |
| age | ||
| visits | member for | 1 year, 3 months |
| seen | Mar 29 at 22:13 | |
| stats | profile views | 9 |
I am working as a DBA and deal with MYSQL. I have my hands in performance testing with NEO LOAD previously.
|
Mar 18 |
comment |
Slave SQL thread got hanged We tried to find what the query being executed during this time. But the thread is always showing "Reading event from the relay log" state only which means it is ready to execute the even that it has read.... so we stuck up. |
|
Mar 18 |
asked | Slave SQL thread got hanged |
|
Mar 9 |
comment |
How to Add Federated engine after installing Mysql Manaf, I missed to inform one more detail. When I hit "SHOW ENGINES", I saw "NO" for federated engine which means the binary is not compiled with the support for that engine. How to proceed in this scenario... |
|
Mar 2 |
comment |
How to Add Federated engine after installing Mysql Is this applicable for mysql installed from binary distribution rather than source ??? |
|
Mar 2 |
comment |
How to Add Federated engine after installing Mysql Abdul, If i installed mysql from compiled binaries, then how should i get federated engine active... I think i should resintall from source or is there any other option.... |
|
Feb 14 |
awarded | Notable Question |
|
Nov 18 |
awarded | Scholar |
|
Nov 18 |
comment |
How to know the current log sequence number in 5.0.X Hi Ronals, Thanks you for your explanation. I have seen this variable "innodb_os_log_written", this is introduced in 5.0.2, so i can see this on my machine. I got what I actually lokked for..... |
|
Nov 18 |
accepted | How to know the current log sequence number in 5.0.X |
|
Nov 11 |
asked | How to know the current log sequence number in 5.0.X |
|
Nov 8 |
answered | innobackupex is failing while exporting backup |
|
Oct 18 |
awarded | Supporter |
|
Oct 18 |
comment |
What exactly are iblog files in mysql My previous comment is about ib_log files.... |
|
Oct 18 |
comment |
What exactly are iblog files in mysql How the space will be retained in these log files... ? I mean to ask... "for new innodb transactions how the same log files be used if these are filled up completely...." |
|
Oct 17 |
asked | What exactly are iblog files in mysql |
|
Oct 15 |
awarded | Popular Question |
|
Apr 13 |
comment |
Mysql: Insert performance INNODB vs MYISAM Yes this is true. But when I have the innodb_flush_log_at_trx_commit = 1, I observed 40% on the server. more over changing the innodb_flush_method to O_DIRECT or O_DSYNC improved the performance by 5 times. can you say anything about this 40% IO with innodb_flush_log_at_trx_commit = 1 ..? |
|
Apr 13 |
awarded | Commentator |
|
Apr 13 |
comment |
Mysql: Insert performance INNODB vs MYISAM changing the innodb_flush_method from default to O_DSYNC or O_DIRECT has improved the performance 5 times better. |
|
Apr 12 |
comment |
Mysql: Insert performance INNODB vs MYISAM Thanq mahesh. Its working fine with innodb_flush_log_at_trx_commit = 2. But i am expecting better performance than this with innodb_flsuh_log_at_trx_commit = 1. I will run a test with ur suggested configs and see.. |
