Top Articles

3 Ways to Speed Up MySQL

gr8gonzo07/27/2009, 12:00 AM

There are ONLY 3 ways to speed up MySQL, and everything else is simply a finer point of one of these 3 ways. Here they are, in order of importance: 1. Optimize queries 2. Tune the MySQL configuration 3. Add more hardware ...

Topic: MySQL ServerTags: mysql, database, performance, optimization, indexes, queries, slow, caching

Views: 14377Comments: 59

MySQL Workbench Remote Administration using SSH to Windows Server

rcombis12/08/2010, 12:00 AM

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m

Topic: MySQL ServerTags: MySQL Workbench, SSH, Windows Server, MySQL Remote Administration

Views: 5854Comments: 3
Loading Advertisement...

Top MySQL Server Experts

  1. johanntagle

    286,814

    Guru

    6,000 points yesterday

    Profile
    Rank: Sage

  2. Ray_Paseur

    216,557

    Guru

    0 points yesterday

    Profile
    Rank: Savant

  3. DaveBaldwin

    119,595

    Master

    1,400 points yesterday

    Profile
    Rank: Genius

  4. angelIII

    61,340

    Master

    0 points yesterday

    Profile
    Rank: Elite

  5. mwvisa1

    57,185

    Master

    30 points yesterday

    Profile
    Rank: Genius

  6. HainKurt

    41,850

    0 points yesterday

    Profile
    Rank: Genius

  7. ralmada

    39,250

    0 points yesterday

    Profile
    Rank: Genius

  8. Roads_Roads

    33,080

    0 points yesterday

    Profile
    Rank: Genius

  9. arnold

    29,812

    0 points yesterday

    Profile
    Rank: Genius

  10. theGhost_k8

    29,785

    0 points yesterday

    Profile
    Rank: Sage

  11. Kdo

    29,682

    0 points yesterday

    Profile
    Rank: Genius

  12. bportlock

    26,604

    0 points yesterday

    Profile
    Rank: Genius

  13. jason1178

    23,574

    0 points yesterday

    Profile
    Rank: Genius

  14. maeltar

    23,236

    0 points yesterday

    Profile
    Rank: Guru

  15. StingRaY

    21,500

    0 points yesterday

    Profile
    Rank: Wizard

  16. smadeira

    19,968

    0 points yesterday

    Profile
    Rank: Wizard

  17. fundacionrts

    18,200

    0 points yesterday

    Profile
    Rank: Master

  18. gr8gonzo

    17,019

    0 points yesterday

    Profile
    Rank: Sage

  19. ChrisStanyon

    16,964

    0 points yesterday

    Profile
    Rank: Sage

  20. pratima_mcs

    16,614

    0 points yesterday

    Profile
    Rank: Genius

  21. TempDBA

    16,400

    0 points yesterday

    Profile
    Rank: Sage

  22. Sharath_123

    16,268

    0 points yesterday

    Profile
    Rank: Genius

  23. for_yan

    16,000

    0 points yesterday

    Profile
    Rank: Genius

  24. matthewspatrick

    15,800

    0 points yesterday

    Profile
    Rank: Savant

  25. AielloJ

    13,732

    0 points yesterday

    Profile
    Rank: Wizard

Hall Of Fame