Viewing posts for the category MySQL

Incorrect key file for table

Posted by: scoopseven in MySQL 17 years, 7 months ago

Incorrect key file for table '/tmp/#sql_18ed_O.MYI' ; try to repair it.

read more / 0 comments

Connecting MySQL ODBC 3.51 to CFMX

Posted by: scoopseven in ColdFusion MySQL 17 years, 7 months ago

The MySQL ODBC 3.51 driver doesn't like CFMX because CFMX uses the odl MySQL password convention. So, to setup a datasource in CFMX that uses the MySQL 3.51 driver you have to setup a user in MySQL for ColdFusion, then run the following commands (I do it in MySQL Front).

read more / 0 comments

Installing MySQL JDBC driver for ColdFusion MX 6.1

Posted by: scoopseven in ColdFusion MySQL 17 years, 7 months ago

download latest version of mySQL JDBC driver from MySQL website (mysql-connector-java-3.2.0-alpha-bin.jar) currently running on FADWEB

read more / 0 comments

MySQL: Windows v Linux

Posted by: scoopseven in MySQL 18 years, 1 month ago

I beat my head against my desk once already, and I'm sure it'll happen at least once more finding out about the differences between MySQL running on a Windows 2003 Enterprise server and a Mindrake Linux 1o.o server. In one of my applications I'm setting a default variable, thisMonth, to a null string. The target column is defined as an integer. When I do the insert into my table i use single quotes around my variable, even though it's an int. Although this may not be a best practice it works fine when my variable isn't defined and I want to insert a null value into thisMonth... on the linux server anyway.

read more / 0 comments

MySQL Madness

Posted by: scoopseven in MySQL 18 years, 1 month ago

Spent a good deal of time today learning about MySQL's limits when it comes to non-indexed tables. I had 4 column table which included a date, IP address and 2 integers. The CFMX server started going bananas, taking a long time to finish requests. I lowered the timeout, so long running requests would die and I increased the number of simultaneous requests in the ColdFusion administrator from 8 to 100! the server would eventually use all 100 connections and then start queuing requests, then die. Finally I decided to check out our MySQL database server, which is never the problem, and found tons of locked queries trying to select/insert/update into my 4 column table.

read more / 0 comments