Hi
Actually I don't get any idle processes listed.. but have came across such
mails..
On which platform you are running mysql?
I guess this might be:
If Windows, the server will drop the connection probably because of
'wait_timeout' expired.
For others, the mysql gets reconnected with
Linux Redhat ASEL 4.0
On 11/8/06, Visolve DB Team [EMAIL PROTECTED] wrote:
Hi
Actually I don't get any idle processes listed.. but have came across such
mails..
On which platform you are running mysql?
I guess this might be:
If Windows, the server will drop the connection probably because
I am having an issue with MySQL running on Mac OS X. Currently the version
as stated 5.0.18 on a dual G4 Xserve with 1gb of ram. MySQL is mainly the
only thing running on this server. I am trying to track down an issue in
which MySQL is being overloaded and it consistently damages the same one or
We have an intense data process that runs every few minutes, clearing
and then loading a database with thousands of records of data, which are
then queried on from a website. The periodic load takes about 20
seconds. Some of the front end select queries take a second or two.
This is all
Hello,
Depending on the characteristics of the data and baring dependencies on
specific features like FKs or complex JOINs, you may want to take a look at
MySQL Cluster.
MySQL Cluster supports in-memory and disk-based databases. So, it may give
you the high-performance characteristics you are
Maybe I should just be looking at using a HEAP table?
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
As a note: mSQL has an attach function that will allow you to
take those files and recreate the database by only giving it the database name
and the file names. It's a way to put back a backup made of the physical
database if you backup directly from the SQL data directory and
Good morning, Steffan -
Can you post some details about what you mean when you say the tables
are damaged? What makes you say that / what are the signs/symptoms?
Does the server process crash, or stop responding? Do you see
anything in the error logs? Do you have enough disk space for temp
I suppose you mySQL - not mSQL (there was a lite RDBMS once named mSQL - I
don't know whether it exists any more...).
On 11/8/06, scott [EMAIL PROTECTED] wrote:
As a note: mSQL has an attach function that will allow you to take those
files and recreate the database by only giving it the
Sorry, Microsoft SQL!
From: Panos Tsapralis [EMAIL PROTECTED]
Sent: Wednesday, November 08, 2006 6:48 AM
To: [EMAIL PROTECTED]
Subject: Re: Undelete a droped table
I suppose you mySQL - not mSQL (there
Depends on the value of your data, and what you might want to invest
in cluster setup (time, money) to get this done.
Another simple option from a hardware perspective might be the use of
a PCI card with RAM that serves as a Serial ATA disk. They're
relatively new on the market but they're out
I must have understood something wrong in the regexps docs:
SELECT
login
FROM
orolixMain.Usersu
WHERE
u.login REGEXP
'^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*'
;
[EMAIL PROTECTED](none) \. usr/src/oro/qry/phshr.sql
On 2006-11-08 Leandro Guimarães Faria Corcete DUTRA wrote:
u.login REGEXP
'^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*'
...
But I get, among otherss, a string beginning with 'walt' (several, in fact).
Probably MySQL don't know about this [.period.] thing and
Em Qua, 2006-11-08 às 19:16 +0100, Christian Hammers escreveu:
On 2006-11-08 Leandro Guimarães Faria Corcete DUTRA wrote:
u.login REGEXP
'^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*'
...
But I get, among otherss, a string beginning with 'walt' (several, in
In the last episode (Nov 08), Leandro Guimar~aes Faria Corcete DUTRA said:
Em Qua, 2006-11-08 às 19:16 +0100, Christian Hammers escreveu:
On 2006-11-08 Leandro Guimar~aes Faria Corcete DUTRA wrote:
u.login REGEXP
According to the documentation, [.period.] should match but so should [...]
(if I read it right).
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Christian Hammers
On 2006-11-08 Leandro Guimarães Faria Corcete DUTRA wrote:
u.login REGEXP
'^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*...
But I get, among otherss, a string beginning with 'walt' (several, in
fact).
Probably MySQL don't know about this [.period.]
Em Qua, 2006-11-08 às 12:53 -0600, Dan Nelson escreveu:
. within brackets is treated literally anyway, so there's no need to
use [.period.].
OK, I had taken the effects of - as being the effects of .
REGEXP BINARY '^wa[bhkl][-_.acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*'
It
I'm curious to know why simply having a UNIQUE constraint on the
column is inadequate...
-JF
On Nov 7, 2006, at 6:47 PM, Michael Fischer wrote:
Any thoughts on using BINARY(N) or CHAR(N) as a primary key?
Performance issues? In mysql, in general?
Yes, in the context of the application,
Hi list,
I have a table with about 17 millons of records. This table
contain log of web for one month and I have an other table but with only
1 day of log.
If I do a select to get the log for this date 2006-01-01 :
Select * from mytable where mydate = '2006-01-01' and mydate =
This problem is driving me crazy. Please help.
127:~ mariuszlenk$ cd /usr/local/mysql
127:/usr/local/mysql mariuszlenk$ sudo ./bin/mysqld_safe
Password:
./bin/mysqld_safe: line 1: ./bin/my_print_defaults: cannot execute binary file
./bin/mysqld_safe: line 1: ./bin/my_print_defaults: cannot
Does anyone know if/when InnoDB will support FULLTEXT indexes? I have a
project that I'm working on now that really needs support for both.
Thanks!
Tim Gustafson
FalconSoft, Inc
[EMAIL PROTECTED]
http://falconsoft.com/
(831) 425-4522
(831) 621-6299 (Fax)
--
MySQL General Mailing List
For
On Wed, Nov 08, Jon Frisby wrote:
On Nov 7, 2006, at 6:47 PM, Michael Fischer wrote:
Any thoughts on using BINARY(N) or CHAR(N) as a primary key?
Performance issues? In mysql, in general?
Yes, in the context of the application, there is a very good
reason for doing this, and not
It's my understanding that a PK in MySQL is basically the same as a
unique index -- for MyISAM tables at least. For InnoDB it's a bit
different with InnoDB storing rows within the PK index (and inserting
a hidden PK if none is provided).
In short: I don't think you'll see any better
Hi, I constantly keep receiving this kind of error:
mariuszlenks-ibook-g4:~ mariuszlenk$ cd /usr/local/mysql
mariuszlenks-ibook-g4:/usr/local/mysql mariuszlenk$ sudo ./bin/mysqld_safe
Password:
./bin/mysqld_safe: line 1: ./bin/my_print_defaults: cannot execute binary file
./bin/mysqld_safe: line
Hi,
Is it possible to access the Full-Text Index structures from SQL?
Thanks a lot,
Ray
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Till MySQL 5.0 there was no support for FULLTEXT by InnoDB. More info on:
www.innodb.com/innodbtalkUC2005.pdf
Thanks
ViSolve DB Team.
- Original Message -
From: FalconSoft, Inc [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, November 09, 2006 6:28 AM
Subject: InnoDB
So, based on this article, they were looking for a coder in April of this
past year. Did anyone start working on it? Does anyone know the status of
the project?
Tim Gustafson
FalconSoft, Inc
[EMAIL PROTECTED]
http://falconsoft.com/
(831) 425-4522
(831) 621-6299 (Fax)
- Original Message
28 matches
Mail list logo