Should this worry me:
060331 10:34:24 [Warning] Aborted connection 244161 to db: 'cyrus'
user: 'cyrus' host: `debpro' (Got an error reading communication
packets)
/Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
From: Gabriel PREDA [EMAIL PROTECTED]
You ought to use the *Boolean Full-Text Searches.*
You would then do a:
SELECT title, Comment FROM table_name WHERE MATCH (Comment) AGAINST ('+foo
+bar' IN BOOLEAN MODE);
This way the rows that contain both words have higher relevance... those
that have
ALTER TABLE requires a table name for the current database.
You can specify:
ALTER TABLE db_name.tbl_name MODIFY col_name ...
or
mysql alter table test1.t1 modify test1.t1.set1 varchar(30);
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0
but you cannot modify a
Rich [EMAIL PROTECTED] wrote on 03/30/2006 09:11:56 PM:
Hi there. Any quick way of killing duplicate records?
Cheers
Yes. Some ways involve subqueries, others temporary tables. What version
are you on? What are your table definition(s) (use SHOW CREATE TABLE to
dump the defs)? How do
Are the other fields in the update statement actually changing the
data? I don't know for sure, but if the data on disk is the same as
the update statement, mysql won't actually update the record, and
therefore might not update the last_updated field also. Just a
thought.
--
MySQL General
Hank wrote:
Are the other fields in the update statement actually changing the
data? I don't know for sure, but if the data on disk is the same as
the update statement, mysql won't actually update the record, and
therefore might not update the last_updated field also. Just a
thought.
It's
I have been reading the definitive guide to MySQL5, and I am not finding
a answer to a question.
I am designing a project in which I am going to have primary keys, and
foreign keys. In order to keep things proper, I am going to have delete
on cascades on my foreign keys, so when the primary
Hi Scott,
Indeed, only the BDB and InnoDB storage engines support referential
integrity. If you accidentally create the table as MyISAM, there is
no error, though -- the constraints serve as a comment.
Replication is storage-engine independent, so you shouldn't have a
problem with that.
As I have been reading, it appears that the InnoDB Storage Engine
supports PK/FK relationships. And that the MyISAM does not. But I cannot
verify that.
That is correct.
Martijn Tonies
Database Workbench - development tool for MySQL and more!
Upscene Productions
http://www.upscene.com
My
Hello Sheeri,
Indeed, only the BDB and InnoDB storage engines support referential
integrity. If you accidentally create the table as MyISAM, there is
no error, though -- the constraints serve as a comment.
No error? A comment? What use is that?
If you want FKs, having the FKs as a comment
I didn't write the codebase for MySQL, so it's pointless to tell me
that it's useless to be able to create a foreign key on a MyISAM
table. I agree that it's useless, however, it's possible, which is
why I put it in there -- as a caveat.
The use is that apparently in future versions MyISAM will
Are your logs and data on the same partition? That's a bad idea for
recovering from a blown part of the disk, but we also saw that one of
our databases would crash when there were lots of
inserts/updates/replaces -- other databases, which had the same
version of MySQL and operating system, had
I recently migrated all of our mysql databases from 4.1.X to 5.0.X.
Everything is working properly except my backups. Here is the command
that I am using:
mysqldump -u user -ppassword --opt -A -F --delete-master-logs | gzip
$BACKUPFILE`date +%m%d%y`.sql.gz
This worked on the old database
So, in theory this should be pretty straight forward to do right? Well
I'm new to UDF's, so how mysql is passing the data to the UDF is a bit of
a mystery. I'm hoping someone can help me understand this.
I'm selecting data from a BLOB field like this:
SELECT
Just checking if this user has RELOAD PRIVILEGES, as it is needed for the
--master-data option which is automatically enabled with
--delete-master-logs , does the error duplicate on subsequent attempts ??
Kishore Jalleda
http://kjalleda.googlepages.com/projects
On 3/31/06, Cody Holland [EMAIL
As others have suggested , turn your slow query log on in my.cnf , and set
your long-query_time, and you can view your slow queries in the *.log file
in your data dir, and then try to optimize them, you could also try mytop (
http://jeremy.zawodny.com/mysql/mytop/) , and check your queries in real
Folks,
I have a mysql 5.0 db with the following char sets:
mysql show variables like '%char%';
+--+--+
| Variable_name| Value|
+--+--+
| character_set_client |
From the 5.0.18 manual:
The FOREIGN KEY and REFERENCES clauses are supported by the
InnoDB storage engine, which implements ADD [CONSTRAINT
[symbol]] FOREIGN KEY (...) REFERENCES ... (...). See
Section 14.2.6.4, FOREIGN KEY Constraints.
For other storage engines, the clauses are parsed but
Never mind, I was being dumb. I wasn't using the args-lengths array for
binary data, so it was dying on a strlen(args-args[0]) which makes sense.
Thanks anyway.
David Godsey
So, in theory this should be pretty straight forward to do right? Well
I'm new to UDF's, so how mysql is passing the
Please help, I can't start my server!!
I was running a query, and it seemed to be hanging. After waiting about 15
minutes, I finally did a 'CTRL+BREAK' to abort the process. This happened
about 3 times, and finally I decided to restart the MySQL service to see if
that would help. Well, when I
Hello everyone,
What I'm after is trying to figure out a way to centrally and remotely
managing (e.g. on server1) our MySQL servers (server2 is an example) on
different machines. Right now, these MySQL servers are all set up to only
accept logons from localhost. My questions:
1. server1 has to
In Windows, you have 3 alternatives:
1 - wait untill it stops the service (can take very long time).
2 - restart the server (your users might cry a bit).
3 - Try to kill the task using Task Manager (this might not work,
depending on the service).
/Johan
Sara Woglom wrote:
Please help, I
Hi,
I hope this is the right forum for this question. If not, I'm happy to
get some tip on where to post this.
My problem:
I have like 20 tables of data and need to merge these, making a
selection, (and dump it into a text file) to import into a reporting
tool. The tables is like salesrep,
Sorry, I should have been more specific. I tried 'mysqladmin -u root
shutdown -p' and that did not work.
The service is hung up in a pending state and I cannot control it. It is
Net Error 2189: 'The service could not be controlled in its present state.'
There has to be some way I can fix this
Bing Du wrote:
Hello everyone,
What I'm after is trying to figure out a way to centrally and remotely
managing (e.g. on server1) our MySQL servers (server2 is an example) on
different machines. Right now, these MySQL servers are all set up to only
accept logons from localhost. My questions:
Do you have a table that has *all* your employees ids (empl_id)?
Shaunak Kashyap
Senior Web Developer
WPT Enterprises, Inc.
5700 Wilshire Blvd., Suite 350
Los Angeles, CA 90036
Direct: 323.330.9870
Main: 323.330.9900
www.worldpokertour.com
Confidentiality Notice: This e-mail transmission
No, I don't have that. There's about 5-10% change in employees ids from
every year, and no one took any interest in this system before I got it
in my lap...
Would it help to have one??
Shaunak Kashyap wrote:
Do you have a table that has *all* your employees ids (empl_id)?
Shaunak Kashyap
Are your logs and data on the same partition? That's a bad idea for
recovering from a blown part of the disk, but we also saw that one of
our databases would crash when there were lots of
inserts/updates/replaces -- other databases, which had the same
version of MySQL and operating system,
OK. No problem. We can hopefully still make this work with a temporary
table.
The SQL will look something like this:
CREATE TEMPORARY TABLE tmp_sales_rep
SELECT empl_id FROM Table_1998
UNION
SELECT empl_id FROM Table_1999
UNION
SELECT empl_id FROM Table_2000
SELECT t.empl_id, t98.sales98,
I LOVE YOU!!!
Great way of doing it. Never thought of creating that extra table and
match against it... You really saved my day!!
Now I just have to get rid of those rows containing nothing but NULL
values (if I select years 2000 ... 2003 empl_id 1002 generates a row
with all columns =
I have a really simple two-column database:
domain_name (primary key)
timestamp
I'm trying to keep track of the referrer of every visit to a web
site, and I'm looking for a single SQL statement (since my ISP limits
the total number of calls I can make in a day) that will either
insert a
On 3/31/06, Brian Dunning [EMAIL PROTECTED] wrote:
I have a really simple two-column database:
domain_name (primary key)
timestamp
I'm trying to keep track of the referrer of every visit to a web
site, and I'm looking for a single SQL statement (since my ISP limits
the total number of
Or the more standard INSERT... ON DUPLICATE KEY UPDATE
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
Shaunak Kashyap
Senior Web Developer
WPT Enterprises, Inc.
5700 Wilshire Blvd., Suite 350
Los Angeles, CA 90036
Direct: 323.330.9870
Main: 323.330.9900
Hank wrote:
Are the other fields in the update statement actually changing the
data? I don't know for sure, but if the data on disk is the same as
the update statement, mysql won't actually update the record, and
therefore might not update the last_updated field also. Just a
thought.
Yes, I
Ferindo Middleton Jr wrote:
Hank wrote:
Are the other fields in the update statement actually changing the
data? I don't know for sure, but if the data on disk is the same as
the update statement, mysql won't actually update the record, and
therefore might not update the last_updated field
I have been offering free database hosting for over 4 years and I've
been doing it on a shoestring.My last MySQL server was a generic
1GHz system with 256MB RAM running Redhat 9. The performance was
surprisingly good because the query loads were not typically high. One
persistent
At 09:27 PM 3/31/2006, you wrote:
I have been offering free database hosting for over 4 years and I've been
doing it on a shoestring.My last MySQL server was a generic 1GHz
system with 256MB RAM running Redhat 9. The performance was surprisingly
good because the query loads were not
At 04:14 PM 3/31/2006, Chris Kantarjiev wrote:
Are your logs and data on the same partition? That's a bad idea for
recovering from a blown part of the disk, but we also saw that one of
our databases would crash when there were lots of
inserts/updates/replaces -- other databases, which had
Quote
If you use ALTER TABLE on a MyISAM table, all non-unique
indexes are created in a separate batch (as for REPAIR
TABLE). This should make ALTER TABLE much faster when you
have many indexes.
This feature can be activated explicitly. ALTER TABLE ...
DISABLE KEYS tells MySQL to stop
mos wrote:
At 09:27 PM 3/31/2006, you wrote:
I have been offering free database hosting for over 4 years and I've
been doing it on a shoestring.My last MySQL server was a generic
1GHz system with 256MB RAM running Redhat 9. The performance was
surprisingly good because the query loads
Mohammed,
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html
If your last data file was defined with the keyword autoextend, the
procedure for reconfiguring the tablespace must take into account the size
to which the last data file has grown. Obtain the size of the data file,
41 matches
Mail list logo