At 11:50 PM 5/1/2004, you wrote:
Hi all,
I have a db that is connection heavy running on FreeBSD 4.9. The server
was compiled with Linux Threads enabled.
I am searching for performance tuning information. Outside of enabling
Linux Threads I haven't been able to find much else. I am under the
Hi Peter,
- Original Message -
From: Peter Thomas
Sent: Saturday, May 01, 2004 11:24 PM
Subject: Delayed insert record visibility
I'm trying to understand the delayed insert process to see whether I
can use
it to reduce the load on mysql, and have the following question.
Are
Hi John,
- Original Message -
From: John Mistler
Sent: Sunday, May 02, 2004 12:50 AM
Subject: Indexing
I know this is an elementary question, but I am getting two sets of
instructions from different MySQL manuals about setting an index on a
prefix
of a column of a table. One says to
Hi, Ivan and all!
Tanks, but create a symlink from... to?
Another question how can see the compatibility of authentification?
I'm not very experiency on Linux and Mysql.
Thanks,
Segismundo
|You can create a symlink.
|Have you tested compatibility between MySQL 5 and 4 concerning
Hi John,
What version do you use? In 4.0.18, they fixed some bugs that were
introduced in 4.0.17 related to trailing spaces on indexed TEXT-family
columns: http://dev.mysql.com/doc/mysql/en/News-4.0.18.html
I see 3 Bugs fixed entries with trailing spaces in them. If you're
not using 4.0.17,
John Mistler [EMAIL PROTECTED] wrote:
I know this is an elementary question, but I am getting two sets of
instructions from different MySQL manuals about setting an index on a prefix
of a column of a table. One says to use:
KEY indexName (colName(length))
and the other says to use
I am using 4.0.18. I also checked out the Bugs Fixed report--and it kind
of looks like #2295 applies, although I can't be certain. It definitely
returns rows without trailing spaces, even though the SELECT asks for rows
WITH trailing spaces.
Hmmm...
on 5/2/04 2:05 AM, Matt W at [EMAIL
Howdy --
What I want to do is use Xbasic as a frontend for MySQL. The problem is I'm
mainly a PHP(and a little Perl) person.
It looks like we should be able to make calls to the MySQL libs,dills headers
from Xbasic. My interest for the mement is with doing it on Windows.
Here's the Xbasic
As others have said, you can use 'IN'. You could also use UNION (although I
don't think I would, personally, for quite what you want!):
SELECT word FROM word_table WHERE id = 1
UNION
SELECT word FROM word_table WHERE id = 2
Etc. Assuming your version of MySQL supports the UNION operator!
To me, this is entirely a matter of personal choice - and the important
thing is to pick a standard and stick to it. :)
I usually end up with a table called 'People' for arguments sake, which will
have an abstract PK (auto increment int) called PeopleID (I always use the
table name). I also
I do something similar in my PHP applications - using an object wrapper to
the SQL connection. That way, when an error occurs, the object automatically
outputs the query, along with any error which was returned.
Cheers,
Matt
-Original Message-
From: Richard Bryson [mailto:[EMAIL
Hello all,
I have a query about distributing mySQL.
I am a student developer, but have very little experience with
databases, I develop in Cocoa for OS X (as well as a little bit of
Windows stuff).
An application I am writing stands to benefit a lot from having a
server application
We weekly rotate the mysqld log. I need to find a way to query the
server to see how many current connections with clients there are,
so I can wait to restart the server when the number of connections
is zero. mysqladmin doesn't seem to have this capability.
Is there any other way?
Todd
I'm glad you brought this up, because I am trying to figure out the same
thing. I have created an application for OS 10.3 which stores its data in a
MySQL database. I would like to be able to install the app on other
computers from a CD, without having to set up MySQL separately on each
In the last episode (May 02), Mailing List Receiver said:
We weekly rotate the mysqld log. I need to find a way to query the
server to see how many current connections with clients there are,
so I can wait to restart the server when the number of connections
is zero. mysqladmin doesn't seem
Hi,
I am writing a thread safe connection pool class. I want to connect to
MySQL through jdbc driver. In the initialization method, I write a
method that makes connections to the database and stores them in a
vector. When, I try making the 99th connection, MySQL throws an error
that says
Hello,
Trying to fix this problem mySQL error 1016
I found this at the InnoDB site.
Another symptom of an out-of-sync data dictionary is that MySQL prints an error
that it cannot open a file
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Deepak Vishwanathan wrote:
| Hi,
|
|
|
| I am writing a thread safe connection pool class. I want to connect to
| MySQL through jdbc driver. In the initialization method, I write a
| method that makes connections to the database and stores them in a
|
When I create a table with InnoDB there is a strange behaviour in it:
mysql CREATE TABLE prometeo_indirizzi_cliente (
- indirizzi_cliente_id int(10) unsigned NOT NULL auto_increment,
- denominazione_indirizzo_id int(10) unsigned default NULL,
- cliente_id int(10) unsigned default
At 23:13 +0200 5/2/04, Alessandro Sappia wrote:
When I create a table with InnoDB there is a strange behaviour in it:
mysql CREATE TABLE prometeo_indirizzi_cliente (
- indirizzi_cliente_id int(10) unsigned NOT NULL auto_increment,
- denominazione_indirizzo_id int(10) unsigned default
I am having a major issue with a bulletin board I run. We put the site up
and after a week or binaries just start segfaulting. The mysql database
also gets constantly corrupted. The longer the box is up the more
frequent the corruption is. It can be repaired with myisamchk.
We have been on
We just had another machine that this weird bug introduced itself onto.
However, I just noticed something interesting; they're both running
mysql-3.23.58. Most of our production servers are 3.23.57 or below. Also,
there was a specific change to 3.23.58 dealing with password handling:
Fixed
Hi everyone,
If a user 'x' has exhausted all his connections, is there a way to free
up those connections. What command do I use for that?
Deepak
23 matches
Mail list logo
