MySQL disadvantages:

Giro

JF-Expert Member

Feb 9, 2009

359

24

• May 8, 2010

• #1

By Rajmeet Ghai​

Qn1:What are the disadvantages of MySQL?

Answer:

1.MySQL does not support a very large database size as efficiently
2.MySQL does not support ROLE, COMMIT, and Stored procedures in versions less than 5.0
3.Transactions are not handled very efficiently.

Lets have your experience regarding MySQL.

Qn2:What are the security recommendations while using MySQL?

Answer:

1.Access to the user table should never be given to avoid SQL injection attacks.
2.Privileges such as GRANT and REVOKE must be made use of.
3.SHOW GRANTS can be used to see the list of users who have access
4.Never run the MySQL server as the Unix root user

 

Giro

JF-Expert Member

Feb 9, 2009

359

24

• May 8, 2010

• Thread starter
• #2

What is Query Cache in MySQL?

Query Cache in MySQL is used in scenarios when the same queries need to be executed on the same data set.

Query cache is most useful when there are tables that are not expected to change very often. It is important to note that the query cache does not return old data.

 

Giro

JF-Expert Member

Feb 9, 2009

359

24

• May 8, 2010

• Thread starter
• #3

What are the limitations of mysql in Comparison of Oracle?

1.Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available in Oracle and not in MySQL in versions less than 5.0
2.Large Database size is supported more in Oracle in contrast to MySql

MySQL vs. Oracle.

1.Unlike oracle, mysql data types can store invalid dates and don't support time zones.
2.Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available in Oracle and not in MySQL in versions less than 5.0
3.Large Database size is supported more in Oracle in contrast to MySql.
4.Replication in oracle is two way while one way in mysql.

 

Giro

JF-Expert Member

Feb 9, 2009

359

24

• May 8, 2010

• Thread starter
• #4

What is a Trigger in MySQL?​

A trigger is a set of code which is executed in response to some event.
E.g Update employee_perfomance table when a new task is inserted in task table. Here, the trigger is "update" and the event is "inserting a new row".

Therefore,A trigger in MySQL is a database object that is associated with a table. A trigger is fired, when a particular event occurs for the table. Triggers are used to perform validation checks on data values for insertion or to perform calculations on values for updatation.

They are 2 types of triggers – Before Trigger and After Trigger. Before Trigger fires before the execution of INSERT, DELETE and UPDATE commands. After trigger fires after the execution of INSERT, DELETE and UPDATE commands.

A trigger in MySQL is created using CREATE TRIGGER trigger_name. we need to specify the trigger type.

 

Ramthods

JF-Expert Member

Jun 2, 2009

515

187

• May 9, 2010

• #5

How long have you been developing database solutions?

You seems to have a purely theoretical background and a newbie in this arena.

 

Giro

JF-Expert Member

Feb 9, 2009

359

24

• May 9, 2010

• Thread starter
• #6

Ramthods said:

How long have you been developing database solutions?

You seems to have a purely theoretical background and a newbie in this arena.

Click to expand...

Lets have your experience regarding MySQL.

 

Mpogoro

JF-Expert Member

Dec 7, 2008

387

62

• May 9, 2010

• #7

Well,I think each and every technology out there is available to cater for some specific scenarios.We do not expect MYSQL to serve as a solution to each and every business need.And personally,I feel it's very wrong to try to compare Oracle and MYSQL.This is just my take,no hard feelings!~

 

Kang

JF-Expert Member

Jun 24, 2008

5,694

2,588

• May 10, 2010

• #8

Kijana uko aware kuwa Facebook, probably the largest website in the world(400 million users!) wanatumia MySQL? Sidhani kama utapata tatizo na "large" databases.