Tag Archives: mysql

GUI Maintenance Program for MySQL / MSSQL and Windows

Want an excellent program to manage your MySQL server from Windows?  With MySQL, you can download MySQL Workbench.  MySQL Workbench offers great graphics on your MySQL incident and an interface that offers features such as queries and status of your … Continue reading

Posted in Technology | Tagged , , , , , , , , | Leave a comment

Increase performance on MySQL with a SSD and modifying your my.ini or my.cnf file

Always backup your data along with the my.ini or my.cnf file To add to the performance of a MySQL database, there are many tweaks for the my.ini or my.cnf file.  Two things that you can do is first add a … Continue reading

Posted in Technology | Tagged , , , , | Leave a comment

Learn SQL Databasing

A few links to SQL tutorials – http://www.w3schools.com/sql/ http://www.sqlcourse.com/ http://www.1keydata.com/sql/sql.html http://sqlzoo.net/wiki/Main_Page

Posted in Technology | Tagged , , , | Leave a comment

Learn SQL with these Online Emulators

SQLCourse has been around for sometime.   With Microsoft’s DreamSpark, students can download SQL Server to build databases and to learn how to retrieve data by performing queries  (basically asking the database for specific data).   SQLCourse gives you step by step … Continue reading

Posted in Technology | Tagged , , , , , | Leave a comment

MySQL Wworkbench – manage your MySQL installation

If you are a beginner or an expert, MySQL Workbench is a must have if you have installed MySQL.  The community edition allows you to Start/Stop your MySQL instance, write queries, monitor performance and has dozens of other features. With … Continue reading

Posted in Computers, Education, freeware, Industry, Information Technology, Software, Windows | Tagged , , , | Leave a comment

MySQL Upgrade in Windows

Dawn and I faced a MySQL Upgrade for our Moodle LMS site and delayed as long as we could.   Unlike traditional upgrades of Microsoft SQL, we couldn’t simply click a setup file and the upgrade would replace files and … Continue reading

Posted in Computers, Education, Industry, Information Technology, Manufacturing, network, Networking, Software, Technology, Windows | Tagged , , , , | 1 Comment

Optimizing MySQL on Server 2008 R2

Server 2008 R2 install Wincache by Microsoft Optimizing IIS (http://msdn.microsoft.com/en-us/library/ee377050(v=bts.10).aspx) Edit the my.ini file found in the MySQL installation http://dev.mysql.com/doc/refman/5.0/en/optimization.html Set the innodb_buffer_pool_size=1G   Resource Set the Max_Allowed_Packet = 100M Set Key_Buffer_Size=512M Set query_cache_size = 128MB query_cache_limit = 4MB table_cache=512 tmp_table_size = … Continue reading

Posted in Computer hardware, Computers, Education, freeware, Information Technology, Linux, network, Networking, Software, Technology, Windows | Tagged , , , , | Leave a comment