Scott Purcell [EMAIL PROTECTED] wrote:
I am trying to create some tables that I can use the delete on cascade =
function for. This would help me code the project and ensure data =
integrity. I am on the docs @ =
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html but I am =
not
Hi!
I always get OperationalError: 2013 ( 'Lost connection to MySQL server
during query' ) while running a query using mysql front end on localhost,
after 30 seconds.
This doesn't happen, when i connect from remote hosts - using any front end
.
All timeout parameters are set to default.
Any idea?
Mysql version: 4.1.1
Platform: Linux, pre-compiled RPMs from mysql.com
Table 1:
CREATE TABLE `notifications` (
`recid` int(11) NOT NULL auto_increment,
`recdate` datetime NOT NULL default '-00-00 00:00:00',
`expiry` datetime default NULL,
`notify_title` varchar(150) default NULL,
Hi.
How fast or what about time different between master and slave suppose
when I insert row into master and then select from slave in replication
environment. both machine have all the same specification
Thank.
Kittiphum Worachat.
--
MySQL General Mailing List
For list archives:
Hi all, I'm currently experiencing some very strange behaviour at my MySQL server.
Our production server is a Sun-E4500 (8x400 MHz 4 GB Ram running Solaris 8 and
Solstice Disksuite...) and a single A5000 Storedge with 127 GB disk space (12x9.1GB
@ 10K RPM) array connected over a single FC-AL
Dear Ladies and Sirs,
is ist possible to set a default for SQL_SELECT_LIMIT ?
I tried to put this in my.cnf but it didn't work (server didn't start).
It's MySQL 4.017 on LINUX.
thank you
Klaus
Topaktuelle Consumer-Adressen anmieten www.consumeradressen.de
Diese Mail ist von:
Hi, all.
I've a table with a varchar column, and I need replace a character on
the column, but this character may be on someplace on the field.
Is it possible to change or delete it? What will be the sintax?
Thanks,
Segismundo
--
MySQL General Mailing List
For list archives:
Segismundo [EMAIL PROTECTED] wrote:
Hi, all.
I've a table with a varchar column, and I need replace a character on
the column, but this character may be on someplace on the field.
Is it possible to change or delete it? What will be the sintax?
If you want to replace all occurrences of
FOUND !
After many days to search the solution we found it ! The problem is solved
in the computer runnig microsoft jet 3.5.
You must change to 0 then values in the registry key
hkey_local\machine\software\microsoft\jet\3.5\engines\odbc; se the dword
ConnectionTimeout. The default is 600
Hi, all.
Another question: IS it possible to produce on a sql consult a new
column that enumerate the results with order or not on the other columns?
What is the syntax?
Thanks,
Segismundo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Colleen Dick [EMAIL PROTECTED] wrote:
Is it possible to JOIN the results of a DESCRIBE TABLE to some other
query? The semantics of what I would like to do is the following:
SELECT d_fldcomment from desc LEFT JOIN DESCRIBE footable ON
desc.d_table = 'footable' AND desc.d_field = Field;
The command you're looking for that drops and recreates in one go is
TRUNCATE (http://www.mysql.com/doc/en/TRUNCATE.html). This is
the same as:
DROP TABLE table;
CREATE TABLE table (...);
For MyISAM tables, this is likely to be much faster as MySQL can just
delete the MYI and MYD
Hello Segismundo,
Friday, February 20, 2004, 2:45:20 PM, you wrote:
S Hi, all.
S Another question: IS it possible to produce on a sql consult a new
S column that enumerate the results with order or not on the other columns?
S What is the syntax?
S Thanks,
S Segismundo
SET @a=0
SELECT
Hi List,
I'm having quite a large data file ibdata1 in \mysql\data. The file
occupies over 500 MB, while all of my databases at the moment
are fairly small (recently, i deleted some old databases).
I wonder how it is possible that this file gets so large, compared to
the space the rest of my
Hello!
I´m using MySQL 4, VB6 and ODBC 3.51 and my connection is going down for some reason.
Do not know why.
Do I need to change the Connection Pooling at MyODBC 3.51 Driver?
I saw two options and I don´t know exactly what it means.
- Don´t pool connections to this driver
- Pool
I have been struggling with one way replication for weeks, still
can't make it work.
I used windows, MySql 4.0.17 version on both. I have set bin-log option
in my.cfg in master computer, in slave computer, set master-host,
master-user=repl,master-password, replicate-do-db=test and
We are using XSLT and XSL:FOP for our reports. We generate a simple XML
file then transform it into a nicely laid out PDF. You can layout the
pdf's easily with a nice product called XSLFast www.xslfast.com.
Joe
On Thursday, February 19, 2004, at 07:33 PM, Matt Silva wrote:
I'm looking for a
Franz, Fa. PostDirekt MA [EMAIL PROTECTED] wrote:
Dear Ladies and Sirs,
is ist possible to set a default for SQL_SELECT_LIMIT ?
I tried to put this in my.cnf but it didn't work (server didn't start).
It's MySQL 4.017 on LINUX.
Default value for the global SQL_SELECT_LIMIT is the maximum
Duncan Hill [EMAIL PROTECTED] wrote:
Mysql version: 4.1.1
Platform: Linux, pre-compiled RPMs from mysql.com
[skip]
My problem:
Right now, I use a routine that selects the IDs that haven't been seen, and
promptly does an insert into notifications_seen to flag that it has been
seen.
hi all
I am facing a problem in fetching the data from two different tables
I have tables called A and B.
Thro PHP code i am trying to connect to MySQL to fetch the desired datas frm both A B
My code Goes like this
select ename,exp,salary from A Union select ename,exp,sal from B LIMIT 0, 30
Achuthan [EMAIL PROTECTED] wrote:
[-- text/plain, encoding 7bit, charset: us-ascii, 31 lines --]
hi all
I am facing a problem in fetching the data from two different tables
I have tables called A and B.
Thro PHP code i am trying to connect to MySQL to fetch the desired datas frm both A
Currently I am working under a win32 environment developing applications to
work with mysql. I have found some inconsistencies with the newer version of
libmysql.dll versus older files that are supplied with your current package
I have found that there is no version information tied to the
Hi All,
I have a query problem here. Say I have a table with
employee records of three different departments. If
each department manager wants to see employee info of
their own department. Three different queries will be
needed. Is there a way that I can write one single
query and let SQL decide
On Friday 20 February 2004 15:19, Claire Lee wrote:
Hi All,
I have a query problem here. Say I have a table with
employee records of three different departments. If
each department manager wants to see employee info of
their own department. Three different queries will be
needed. Is there a
I'm interested in trying to tune MySQL's memory usage variables in my
/etc/my.cnf file.
I'm currently using the default settings (except for max_allowed_packet,
which I've had to increase to support some large queries that I make), they
work well. Here is what I've got:
key_buffer_size
Seems to be the binary log saves all INSERT statements, even if it is
a duplicate error. How could I restore my table using mysqlbinlog if
there
are duplicates in the log file.
Please help
Thanks,
George Mathew.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
hello, everyone
I am having problem using the operator OR. when I test for condition A OR
B in a query, the query becomes extensively slow or even fails, even
though a test on condition A or B alone gives result right away.
If you happened to know what the problem it or have any suggestion,
I have a large email database that has been translated into a CSV, simply
like this:
[EMAIL PROTECTED];[EMAIL PROTECTED]; (etc.)
I need to get this into SOME format. I have tried Access, which said it was
too large - so I am trying my mysql. I created a table with fields ID, and
email. I just
On 20 Feb 2004 at 10:57, Yun Li wrote:
I am having problem using the operator OR. when I test for condition A
OR B in a query, the query becomes extensively slow or even fails,
even though a test on condition A or B alone gives result right away.
See
Ronan Lucio wrote:
Hi All,
I´m trying to do some customization in a MySQL-Server-4.0.17
to gain a better performance.
We have a Intel P4-2.4 Ghz with 1 Gb RAM and 40 Gb HD
on a FreeBSD-5.2.1 box dedicated for MySQL.
The diagnostic error messages are a fairly strong indication that you could have
I am having problem using the operator OR. when I test for condition A
OR B in a query, the query becomes extensively slow or even fails,
even though a test on condition A or B alone gives result right away.
I learned recently that you can often use a UNION to solve problems like this.
It's
heh, sometimes the obvious is right in front of you...
I still can't get the full dataset to load with indexes on the table,
but I _can_ apply indexes after the load. the indexes apply cleanly, so
it doesn't seem to have been a data issue. in any case, I can continue
prototyping.
it remains
David Griffiths wrote:
I was wondering what the bottleneck was. I'm adding a dozen indexes to
the same large-ish InnoDB table. Each successive index takes a bit
longer (45 seconds or so on a dual P3-933 with 2 gig of RAM).
Every time you add a new index or do any non-trivial modification to the
sorry, I don't know that one. Never have used any version of mysql lower
than 4.04. a suggestion might be to call your 4.0 column an unsigned
bigint, or if possible an unsigned int if the numbers can fit in 32
bits. unsigned means its always positive.
jeff
ps. you may want top reply all so
Fabbro Alberto wrote:
Network configuration:
- Firewall connected to Internet, with two ports: LAN (protected) and DMZ
- Web server on the DMZ segment
- Internal Servers on the LAN segment.
We would like to introduce a web database application on the Web server,
using a Slave replication of a
Egor Egorov wrote:
Colleen Dick [EMAIL PROTECTED] wrote:
Is it possible to JOIN the results of a DESCRIBE TABLE to some other
query? The semantics of what I would like to do is the following:
SELECT d_fldcomment from desc LEFT JOIN DESCRIBE footable ON
desc.d_table = 'footable' AND
Hello,
I'm having problems with a 4.0.18 MySQL Server. Since this afternoon I
get the error Can't create a new thread (errno 11) when MySQL has
forked about 200-300 threads.
What does it mean? I'm not running out of RAM or disk space.
Best Regards,
Christof
--
MySQL General Mailing List
For
Hiya peeps...
If i have a table like this:
+++
| id | uid|
+++
| 1 | 26 |
| 2 | 26 |
| 3 | 267|
| 4 | 267|
| 5 | 269|
| 6 | 269|
| 7 | 271|
| 8 | 271|
| 9 | 271|
| 10 | 424|
+++
I could do this to get the
No one has any ideas?
Hi,
I've got a sorting question that I can't figure out. The page in
question is here:
http://toolstudios.com/intera/careers/index.php
I'd like it to show up like this:
Accounting
job 1
job 2
Engineer
job 1
job 2
IT
job 1
David Scott wrote:
Hiya peeps...
If i have a table like this:
+++
| id | uid|
+++
| 1 | 26 |
| 2 | 26 |
| 3 | 267|
| 4 | 267|
| 5 | 269|
| 6 | 269|
| 7 | 271|
| 8 | 271|
| 9 | 271|
| 10 | 424|
+++
I could
That is SPOT on, takes 2seconds to process but thats still better than 5 :)
--
Dave
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: David Scott [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 20, 2004 5:30 PM
Subject: Re: SUM() the results of a COUNT()
But how would i get something like this?
+++
| A | B |
+++
| 5 | 10 |
+++
Where A = the number of unique UID's (the number of rows from table 2)
and B = the SUM of C (derived from
SELECT count(*) as C from table GROUP BY uid)
SELECT SUM( C )
carreraSC wrote:
No one has any ideas?
Hi,
I've got a sorting question that I can't figure out. The page in
question is here:
http://toolstudios.com/intera/careers/index.php
I'd like it to show up like this:
Accounting
job 1
job 2
Engineer
job 1
job 2
IT
job 1
job 2
Quick question. I just did an upgrade from source from 3.23.x to
4.0.18. A few things came up.
1. chown -R mysql var causes my RedHat 7.3 to complain.
chown: getting attributes of `var': No such file or directory
2. Stopped mysql by typing
shell service mysql stop
3. Tried to
I have the following query where the user will put in a date. They will
put it in like '01/01/04'. I use this date in my WHERE clause but MySQL
needs the date like '2004/01/01'. I tried using Date_Format('04/01/01',
'%Y-%m-%d') to change the way it is formatted but I don't get the
correct data
Looking around in the docs, I found this regarding thread_concurrency:
thread_concurrency
On Solaris, mysqld will call thr_setconcurrency() with this value.
thr_setconcurrency() permits the application to give the threads system a
hint for the desired number of threads that should be run at the
Check the max_connections variable
Mysql show variables liks '%connection%';
-James
-Original Message-
From: Christof Egner [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 9:03 AM
To: [EMAIL PROTECTED]
Subject: Can't create a new thread (errno 11)
Hello,
I'm having
If you need the date like, '2004/01/01', then shouldn't it be '%Y/%m/%d'?
You still ahve the dashes (the '-' character) in your date-format, and you
need a forward-slash (the '/' character) instead.
Here's what I ran on MySQL:
mysql select date_format(NOW(), '%Y/%m/%d');
In the last episode (Feb 20), Bill Marrs said:
Looking around in the docs, I found this regarding thread_concurrency:
thread_concurrency
On Solaris, mysqld will call thr_setconcurrency() with this value.
thr_setconcurrency() permits the application to give the threads
system a hint for the
Sasha,
Thanks for the reply. It's actually during index creation (while creating a
database). I am creating the tables, loading the data, then applying the
indexes and foreign keys.
There are five or six indexes on some tables, the first taking 5 minutes,
the second taking 5:45, etc.
In this
What is the best way to deal with white space in a mysql database?
What I'm talking about is trailing spaces in larger fields. We receive data
in fixed width format, so when you import it, you get a bunch of trailing
white spaces that take up space. Multiply these white spaces by 120million
In the last episode (Feb 20), Chris Fossenier said:
What is the best way to deal with white space in a mysql database?
What I'm talking about is trailing spaces in larger fields. We
receive data in fixed width format, so when you import it, you get a
bunch of trailing white spaces that take
Chris,
Another option is to use | instead of commas. Unless you have pipes in your
file. :)
Donny
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 2:55 PM
To: Chris Fossenier
Cc: [EMAIL PROTECTED]
Subject: Re: White Space
In the last
On 20 Feb 2004 at 14:55, Dan Nelson wrote:
If you need leading and trailing space stripped, you can postprocess
the field with the TRIM() function.
But note that, unlike similar functions in some languages, the MySQL
TRIM() function removes spaces (ASCII 32 characters), not whitespace
(which
Hi Ronan,
Did you perhaps set MAXDSIZ is your kernel configuration above
(2047UL*1024*1024) ?
Ken
- Original Message -
From: Ronan Lucio [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 3:06 PM
Subject: my.cnf in MySQL-Server-4.0.17
Hi All,
I´m trying to
Just use something else beside commas to delimit your file. I have a
file that I need to regularly import that has commas, tabs and returns
in the data. I delimit the fields with ^^ and the records with ~~.
You can tell MySQL what the delimiters are when you import the data.
On Feb 20, 2004, at
Chris,
The good news is that MySQL 5.0 can finally use multiple indexes per
table. I just noticed this page in the manual a few days ago:
http://www.mysql.com/doc/en/OR_optimizations.html
:-)
Matt
- Original Message -
From: Chris Nolan
Sent: Monday, February 16, 2004 7:13 AM
Hi Eve,
That error is because the LOCAL part of LOAD DATA is disabled. See
here: http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html
Since your file is probably on the same system as the MySQL server, it
should work if you remove the LOCAL word.
Hope that helps.
Matt
- Original Message
Thanks for the posts folks. Right after I posted I re-wrote my parser to use
~ for commas and ^ for quotes. It seems to be working. I didn't want to say
I was doing that because it seemed kinda hack :).
I'm not in favor of running TRIM() functions due to the overhead with so
many records.
We'll
Liying Huang wrote:
I have been struggling with one way replication for weeks, still
can't make it work.
I used windows, MySql 4.0.17 version on both. I have set bin-log option
in my.cfg in master computer, in slave computer, set master-host,
master-user=repl,master-password, replicate-do-db=test
SELECT TABLE_NAME FROM USER_TABLES.
I found the error message on Oracle's web site, but their description of
the error doesn't help me much:
*Cause: * The buffer length was less than the minimum required or
greater than its length at bind time minus two bytes.
I don't know what buffer this is
António Fernandes wrote:
Hello,
I'm am trying to make MySQL Server to log connections (attempts, successes,
failures) to a Syslog. I know that it's possible to log all queries but I
just want the connections. Has anyone already done this? Is there a patch
file that I can use?
Wanring - I've never
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems programming', by
which I mean implementing anything with complex data structures and lots of
Kittiphum Worachat wrote:
Hi.
How fast or what about time different between master and slave suppose
when I insert row into master and then select from slave in replication
environment. both machine have all the same specification
If your slave is able to keep up with the load, and your
[EMAIL PROTECTED] wrote:
Hi all, I'm currently experiencing some very strange behaviour at my MySQL server.
Our production server is a Sun-E4500 (8x400 MHz 4 GB Ram running Solaris 8 and Solstice Disksuite...) and a single A5000 Storedge with 127 GB disk space (12x9.1GB @ 10K RPM) array connected
I am running a debian linux server and I need mysqlplus installed. There
isn't a package yet for debian (at least not to my knowledge) to install it.
So, I downloaded the mysql++ 1.7.9 source to install it. I am running
version 2.95.4 of gcc. Is there something I am doing wrong? Do I need to
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems programming', by
which I mean implementing anything with
Jeremy March wrote:
I think --with-extra-charsets=none means that no additional character
sets will be _compiled_ into the server. Complex character sets must be
compiled into MySQL, but simple ones can be loaded dynamically. I think
the character sets you are seeing are ones that can be
Jochem van Dieten wrote:
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems
programming', by
which I mean
Hi all,
Can anyone tell me whether or not some kind of RAID will improve the seek/access times
during lots of random reads from, say, MyISAM data files? I *do not care* about
improved [sequential] transfer rates; I want the fastest possible random access.
I'm thinking that RAID won't give an
Run everything off a ramdisk ;-)
Ted Gifford
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 5:21 PM
To: [EMAIL PROTECTED]
Subject: Improving seek/access times -- does RAID help?
Hi all,
Can anyone tell me whether or not some kind of RAID will
Hi Ted,
Heh. :-) This could be many GBs. There's no problem reading rows that
are in RAM (cached by the OS) -- can read over 10,000/second. If
there's enough RAM, the OS will take care of it (you could cat table.MYD
to /dev/null). No ramdisk necessary. :-)
BTW, this is for MySQL's full-text
Sasha Pachev wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems
programming', by
which I mean implementing anything with complex data
Sasha Pachev wrote:
Jochem van Dieten wrote:
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional
procedural
approaches and languages, like C, are the best for 'systems
Help!
Okay - so I've been working around on my indexing of a table. My table is
currently over 5M rows (close to 500Mb) and growing at a quick rate. In
order to handle different types of queries, I am forced to create multiple
indexes for the table. But by doing so, I end up with an MYI index
We have a job opening at MyPoints.com in San Francisco for a MySQL
database administrator/database developer.
We are building a new system from scratch with distributed and
replicated MySQL databases, Apache, Java, Linux.
Actual duties will depend on the particular skills and interests of the
Hmm...if there's lots of thrashing, it might be to do with
fragmentation. Have you tried running OPTIMIZE TABLE on the table in
question?
Does anyone on the list have anything to say about putting the MYD and
MYI files on seperate disks or using RAID MyISAM tables??
Regards,
Chris
Eric B.
In the last episode (Feb 20), Matt W said:
Can anyone tell me whether or not some kind of RAID will improve the
seek/access times during lots of random reads from, say, MyISAM data
files? I *do not care* about improved [sequential] transfer rates; I
want the fastest possible random access.
Sorry - forgot to mention it. I've already tried both an OPTIMIZE TABLE and
ANALYZE TABLE to try to improve performance, but with no result.
Any other ideas?
Thanks,
Eric
Chris Nolan [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hmm...if there's lots of thrashing, it might be to
Can you send us the CREATE TABLE statement for this troublesome table?
Regards,
Chris
Eric B. wrote:
Sorry - forgot to mention it. I've already tried both an OPTIMIZE TABLE and
ANALYZE TABLE to try to improve performance, but with no result.
Any other ideas?
Thanks,
Eric
Chris Nolan [EMAIL
Hello,
I'm trying to run an SQL update statement like:
UPDATE ControlTable SET @prevval := NextID, NextID = NextID
+ 1
I've tried using a range of different syntax, but nothing
seems to work. This is something that does work in another
SQL server I used to use.
Does anybody know if this is
Sure! Here it is:
CREATE TABLE `index2` (
`id` varchar(50) NOT NULL default '',
`recordid` varchar(20) NOT NULL default '',
`transid` varchar(20) NOT NULL default '',
`formid` varchar(20) NOT NULL default '',
`groupid` varchar(20) NOT NULL default '',
`clientid` varchar(20) NOT NULL default '',
When a select query is run on a mysql table with text and blob fields, the
text fields return the whole text but the blob fields return only the first
4 bytes of the blob data. I use MySQL 4.0.17 with VB6.0 on Windows 2000.
What should I do to retrieve complete data from the blob field?
Any help
Hi,
I have had problems reading BLOB fields using MyODBC (I can't see if this is
Your way of doing this).
I have solved reading/updating BLOB using the samples from
http://www.vbmysql.com/ -
http://www.vbmysql.com/articles/visual-basic_mysql/blobaccessvb.html
Best regards
Peter
-
84 matches
Mail list logo