Dismiss Notice
You are browsing this site as a guest. It takes 2 minutes to CREATE AN ACCOUNT and less than 1 minute to LOGIN

MySQL disadvantages:

Discussion in 'Tech, Gadgets & Science Forum' started by Giro, May 8, 2010.

  1. Giro

    Giro JF-Expert Member

    #1
    May 8, 2010
    Joined: Feb 9, 2009
    Messages: 359
    Likes Received: 9
    Trophy Points: 35
    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
     
  2. Giro

    Giro JF-Expert Member

    #2
    May 8, 2010
    Joined: Feb 9, 2009
    Messages: 359
    Likes Received: 9
    Trophy Points: 35
    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.
     
  3. Giro

    Giro JF-Expert Member

    #3
    May 8, 2010
    Joined: Feb 9, 2009
    Messages: 359
    Likes Received: 9
    Trophy Points: 35
    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.
     
  4. Giro

    Giro JF-Expert Member

    #4
    May 8, 2010
    Joined: Feb 9, 2009
    Messages: 359
    Likes Received: 9
    Trophy Points: 35
    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.
     
  5. Ramthods

    Ramthods JF-Expert Member

    #5
    May 9, 2010
    Joined: Jun 2, 2009
    Messages: 496
    Likes Received: 25
    Trophy Points: 45
    How long have you been developing database solutions?

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

    Giro JF-Expert Member

    #6
    May 9, 2010
    Joined: Feb 9, 2009
    Messages: 359
    Likes Received: 9
    Trophy Points: 35
    Lets have your experience regarding MySQL.
     
  7. Mpogoro

    Mpogoro JF-Expert Member

    #7
    May 9, 2010
    Joined: Dec 7, 2008
    Messages: 361
    Likes Received: 2
    Trophy Points: 35
    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!~
     
  8. Kang

    Kang JF-Expert Member

    #8
    May 10, 2010
    Joined: Jun 24, 2008
    Messages: 4,699
    Likes Received: 204
    Trophy Points: 160
    Kijana uko aware kuwa Facebook, probably the largest website in the world(400 million users!) wanatumia MySQL? Sidhani kama utapata tatizo na "large" databases.
     
Loading...