Plesk Expand Optimizations

Discussion in 'Plesk Expand 2.3 Troubleshooting Issues' started by DimiterN, Nov 1, 2010.

  1. DimiterN

    DimiterN New Member

    Messages:
    4
    Hello all,
    I'm trying to implement some database optimizations for mysqld (which is used by Expand) and I have noticed some facts:
    - We (in our company) haves two Expand servers : on first all Expand's tables uses MyISAM storage engine (SE), but on second - a lot of tables uses InnoDB SE. Is this normal? Or is caused by some database optimizations by Expand itself?
    - Both machines where Expand is installed haves a high load (1.70 - 2.10 for InnoDB's Expand and 1.10 - 1.20 for MyISAM's). Is this normal for mysqld to take 100% CPU load of one core/process all the time?
    - It is normal that expandom causes high load time to time (I think this is derived by 30 seconds update checks of expandom) and could be this period adjusted?
    - It is possible some SQL queries to be optimized. E.g. queries like this:
    Is there some optimization tutorial/manual or something like this?
    Where I can find more detailed information about Expand's database structure like EER diagrams and so on?

    Every help in Expand optimization will be very appreciated.

    Sincerely yours: Nikov, Dimiter

    P.S. Excuse me for my bad English
  2. DimiterN

    DimiterN New Member

    Messages:
    4
    Seems that nobody in Paralles Team is not concerned about optimizing their crappy software.
    Shame on you guys...

Share This Page