Tag Archives: mysql

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

MySQL problem writing to database during cron backup

If you receive the error “!!!Error Writing To Database!!!” during a cron backup, this can be related to Find the my.ini file which is normally located in the MySql folder under program files (C:\Program Files\MySQL\MySQL Server 5.1).  Edit it by adding … Continue reading

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