Re: Keeping MySQL from listening to ports to connections

2001-02-22 Thread Quickling
Sorry, this post is not information, but I need to echo this question. We've got a firewall, but even if we wanted to open it up we can't because MySQL opens a whole slew of listening ports: why??? Why doesn't it just open one, well-defined port to listen on, i.e. 3306 or something? It makes it

Re: Suggestion For List Management

2001-02-22 Thread Quickling
Hey - >Since a lot messages have undescriptive subjects ("Help", "Check This", >"What's This?", etc...) I think it would be a good idea to set up the >majordomo to add a tag to each subject line like the PHP list does. "[MYSQL] Help" is hardly more descriptive than "Help". My solution is to fi

MySQL Direct-to-disk?

2001-02-09 Thread Quickling
Hello, In an earlier post I complained of performance problems with ODBC+MySQL when running a server which makes many 'small' queries and writes. What is the overhead? The benchmarks indicate that MySQL via ODBC is perhaps only 2x slower than MySQL alone, yet the performance we are experienc

MySQL vs Access; you'd *think* the choice is obvious...

2001-02-08 Thread Quickling
Hi, Question 1: --- We've got a server app that does a lot of 'small' database reads and writes. We were originally using MS Access via DAO (Jet Engine) and we wanted to tighten up DB performance, so we've written a general ODBC database wrapper object, but mainly just to connect