How MySQL auto log can help performance related troubleshooting?

mysql
We are heavily dependent on ORM (Object Relational Mapping ) frameworks for application development. Hibernate is a popular ORM in the Java realm where as ActiveRecords in Ruby in Rails support inbuilt ORM capability.  Many times developer depends only on ORM and use it for all purposes, without trying to understand the advantages and its disadvantages, where to use  and where not to use etc. Many times developers who are addicted to ORM also believes that it is not necessary to know SQL as it... more →
Posted in: Database, Programming

MySql tables containing keyword behaving weird!!!

mysql
Here are some queries that will behave weird Consider the following table. [code] mysql> desc person; +———-+————-+——+—–+———+—————-+ | Field | Type | Null | Key | Default | Extra | +———-+————-+——+—–+———+—————-+ | id | int(11) | NO | PRI | NULL | auto_increment | | name |... more →
Posted in: Database, Programming