Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: MYSQl Problems

  1. #11
    Join Date
    Nov 2008
    Location
    Boston MetroWest
    Beans
    16,326

    Re: MYSQl Problems

    If the problem is that it takes too long to retrieve query results, you probably haven't built the right indexes. Use the mysql client program to run the queries in the webapp from the command line and see which take excessively long to complete.

    SQL performance problems usually indicate a problem with the database logic more than a problem with the hardware or server software.

    I don't use MySQL enough to know if it has an equivalent to PostgreSQL's ANALYZE command, but if so, that might provide some insights.

  2. #12
    Join Date
    Jan 2010
    Beans
    31

    Re: MYSQl Problems

    Hi, I still haven't fixed this. Are there any more suggestions?

  3. #13
    Join Date
    Jul 2010
    Location
    Michigan, USA
    Beans
    2,136
    Distro
    Ubuntu 18.04 Bionic Beaver

    Re: MYSQl Problems

    Try to use MySQL's EXPLAIN command to see what's slowing your query down. This will be a good way to see if you have all of your foreign keys indexed (assuming it's a normalized database).

  4. #14
    Join Date
    Jan 2010
    Beans
    31

    Re: MYSQl Problems

    I'm locked out of Mysql though. Also, I have changed the password but it reverts straight back to error 1042.

  5. #15
    Join Date
    Jul 2010
    Location
    Michigan, USA
    Beans
    2,136
    Distro
    Ubuntu 18.04 Bionic Beaver

    Re: MYSQl Problems

    The only way to correct that is to reset the root user's password is I mentioned earlier in the thread. If you're not able to get that to work, maybe you'll need to do a re-install (although, resetting the password works on all versions of Debian / Ubuntu that I've ever tried, so you should be able to get it working).

Page 2 of 2 FirstFirst 12

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •