--- Daevid Vincent <[EMAIL PROTECTED]> wrote:
> As my company and I understand it, if you intend on
> distributing mySQL on
> this appliance and the appliance is a sealed box
yes
> with your own proprietary
> code (like PHP or C or Java or whatever) that
> interfaces to the
> STOCK/Untouched RDBM
>maybe this is a silly question but how useful it is to create indexes on
columns containing only values 0 and 1 (true and false)?
Perhaps, instead of the index, you might revise your schema a bit.
Why do you have this boolean column? What are you trying to
achieve?
I use boolean columns as a fla
To have mysql to start at boot you need to inform the inetd (daemon) that
mysql should be launched at one of the 6 levels:
Use chkconfig to have mysql start in one of the level (2,3,4,5,6)
5 being X windows.
There are two ways to check that mysql will be loaded:
- 1 - by checking the file in /
Hi!
last night we try to upgrade from 4.0.15 to 4.0.24. We thought, that it
is possible without dumping data. We upgrade only server (clients were
still 4.0.15). In changelogs in versions higher than 4.0.15 there were
no info about some incompatible changes and those bound with InnoDB were
conn
Hi,
I'm working with JBoss and MySQL 4.0.22 (and 4.0.18 on Testsystem). But
under the load, I get sometimes Exceptions like this:
java.sql.SQLException: Deadlock found when trying to get lock; Try
restarting transaction message from server: "Lock wait timeout exceeded;
Try restarting transactio
> > > > Are there any standard MySQL tools available for doing that (I mean
> > > MySQL
> > > > Administrator/Query Browser etc.)
>
> Have you looked at mysqldump and mysqlhotcopy?
I know about standard mysqldump utility but I actually needed something with
GUI interface.
> > I assume that tha
Tom Crimmins wrote:
On Wednesday, March 30, 2005 23:26, Mark Sargent wrote:
Hi All,
below is my /etc/init.d/mysql content, but, mysql is not starting at
boot on Fedora3. Have I missed something fundamental.? I need mysql to
start at boot for snort to connect to it. Currently, snort gives an
erro
Tom Crimmins wrote:
>On Wednesday, March 30, 2005 22:25, Daniel Kasak wrote:
>
>
>
>>update
>>_cached_LinesNotTolling LNT inner join TelecomLinePosting TLP
>>on LNT.Line=TLP.Line
>>inner join TelecomAccountPosting TAP
>>on TLP.TelecomLinePostingID=TAP.DanPK
>>inner jo
Hi Folks,
Take a deep breath and see how much an Oracle license is for a Solaris
box with 4 cpus, AFAIK start looking in the thousands of dollars. Try
SQL server, Sybase or Informix. None of the above mentioned are
particularly cheap, some of these are costing over $595.00 per seat not
per unit.
Yeah. It's silly. The whole hardware x86 1U rack mount we use with 2.4Ghz
proc, 256MB, 40GB HD, dual Gbps NICs is only $500. I don't know what crack
the mySQL AB guys are smoking to think that they are competitive. We've
already started to wrap our product SQL calls in our own API so we can
migrate
On Wednesday, March 30, 2005 23:26, Mark Sargent wrote:
> Hi All,
>
> below is my /etc/init.d/mysql content, but, mysql is not starting at
> boot on Fedora3. Have I missed something fundamental.? I need mysql to
> start at boot for snort to connect to it. Currently, snort gives an
> error statin
MySql loses money from many vendors on this very point. Of which they do
not budge.
We have a Point of Sale software company who can distribute Oracle cheaper.
They only require a percentage of the final product price that their product
is packaged with. When the company explained they would rat
Hi All,
below is my /etc/init.d/mysql content, but, mysql is not starting at
boot on Fedora3. Have I missed something fundamental.? I need mysql to
start at boot for snort to connect to it. Currently, snort gives an
error stating it can't connect. Cheers.
Mark Sargent.
[EMAIL PROTECTED] ~]# cat
As my company and I understand it, if you intend on distributing mySQL on
this appliance and the appliance is a sealed box with your own proprietary
code (like PHP or C or Java or whatever) that interfaces to the
STOCK/Untouched RDBMS, you NEED a mySQL Commercial License.
This license is a ridicu
On Wednesday, March 30, 2005 22:25, Daniel Kasak wrote:
> update
> _cached_LinesNotTolling LNT inner join TelecomLinePosting TLP
> on LNT.Line=TLP.Line
> inner join TelecomAccountPosting TAP
> on TLP.TelecomLinePostingID=TAP.DanPK
> inner join PhoneTypes
> on T
>Description:
I installed MySQL-server-4.0.15-0 and am getting the following error
message:
050330 12:09:32 [ERROR] Character set information not found in
'/usr/share/mysql/english/errmsg.sys'. Please install the latest version of
this file.
050330 12:09:32 [ERROR] Aborting
>How-To-Repea
update
_cached_LinesNotTolling LNT inner join TelecomLinePosting TLP
on LNT.Line=TLP.Line
inner join TelecomAccountPosting TAP
on TLP.TelecomLinePostingID=TAP.DanPK
inner join PhoneTypes
on TLP.LineType=PhoneTypes.ID
set
AnnualService=sum(TLP.Service)
--- [EMAIL PROTECTED] wrote:
>
> I thought that was discussed before over and over on
> this mailinglist. I
> am surprised that many people have isues with that
> topic.
Well...
1. Licensing in general can be quite confusing for a
non-lawyer geek
2. I want to make 101% sure I don't take any wrong
Hi Pat,
I thought that was discussed before over and over on this mailinglist. I
am surprised that many people have isues with that topic. Basically it
boils down to 2 questions.
1) Will you include and ditsribute the source code and the changes (if
any) and the GPL license in your product ?
If
At 16:06 -0800 3/30/05, Hassan Schroeder wrote:
Luke Bowerman wrote:
With the column:
mySetCol SET ('cat','dog','mouse','giraffe','lion')
A row with the value "dog,mouse,lion" would return 3
A row with the value "cat,giraffe" would return 2
I've been able to get the MySQL server to give me a binary
Luke Bowerman wrote:
With the column:
mySetCol SET ('cat','dog','mouse','giraffe','lion')
A row with the value "dog,mouse,lion" would return 3
A row with the value "cat,giraffe" would return 2
I've been able to get the MySQL server to give me a binary version of
the data...
SELECT RPAD(BIN(mySetC
Suppose i distribute MySQL-4.1 with an appliance,
which is a sealed x86 machine running a Linux
distribution made by another entity (ok, it's Red
Hat). I don't write any code that's directly linked to
MySQL, I'm only using the existing php-mysql, etc.,
packages already provided by the distribution,
Dan,
My fault. I've drifted away from MS implementations; I wasn't aware of
the Win 2003 server designation.
Bob
- Original Message -
From: "Daniel Cummings" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 30, 2005 3:18 PM
Subject: RE: mysqlconnecernet not closing connections w/2003
Robert-
I apologize for not being clearer.
The operating system is Windows 2003 Server.
Dan
-Original Message-
From: Robert Dunlop [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 30, 2005 3:09 PM
To: Daniel Cummings; mysql@lists.mysql.com
Subject: Re: mysqlconnecernet not closing conne
Dan,
What is a "2003 server?" Do you mean Win2K? I'm not aware of any OS
that references 2003. Perhaps that is part of the reason for no response?
I don't have any MySQL systems running on Windows machines, so I can't
answer your question, but perhaps there are those out there who can
Okay so I'm stumped. What I want to do is run a query that can tell me
the average number of selected values in a set column.
With the column:
mySetCol SET ('cat','dog','mouse','giraffe','lion')
A row with the value "dog,mouse,lion" would return 3
A row with the value "cat,giraffe" would return 2
I posted this late last Friday. I'm hoping everyone missed it and that
someone has an answer. :-)
We have a quote server on both a 2003 server and an XP machine. The quote
server is an asp.net server.
The XP machine is closing the connections without a problem.
For some reason
If I try to read table 'b' after locking table 'a', I expect to get
the error message "Table 'b' was not locked with LOCK TABLES".
However, if my query that accesses table b is stored in the query
cache, I don't get the error. This causes a problem in the following
scenario:
User 1:
LOCK TABLES
Thanks Dan,
I ran myisamchk as you suggested. The detailed results are below, but
in summary there's no difference between the two indices. Perhaps
mysql doesn't want to pack the key for some reason? I'm running
FreeBSD 4.1.
Checking MyISAM file: /home/y/var/mysql/data/Test/Unpacked.MYI
Data reco
Just keep in mind that the ORDER BY will require MySQL to take the
full resultset and reorder it in a temporary table. MySQL has
extended the GROUP BY clause as of version 3.23.34 so that you can
also specify ASC and DESC after columns named in the clause.
On Wed, 30 Mar 2005 10:53:38 -0500 (EST)
Hi,
Anyone know how to find out what are the rows that are reported by
mysqlimport as "deleted"?
Thanks
HT
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
I need to move a database from a 4.0.20 MySQL server to a 4.0.17
server. I expect it will work fine when simply scp-ing the whole
/var/lib/mysql/MY-DATABASE to the other server's /var/lib/mysql
directory, with only a minor version difference.
Can anyone confirm this is going to work and
In the last episode (Mar 30), Julian Pellico said:
> I tried searching for this problem, but I couldn't find any reference
> to it, so here goes...
>
> using mysql 4.0.23, I created two tables, one of them whose key is
> packed. My goal is to see the effect on the size of the index file.
>
> for
If the power is "yanked" a journaled file system knows exactly what it
was doing at the time of failure, what didn't finish, and can recover
from any errors caused by the failure.
A non-journaled file system would need to run a check to see if
everything is ok. This could take a long time on a b
Sorry for the confusion. In this case I am using the * to denote a field
name instead of the wild card character.
- Asad
On Wed, 30 Mar 2005 [EMAIL PROTECTED] wrote:
> Asad Habib <[EMAIL PROTECTED]> wrote on 03/30/2005 10:53:38 AM:
>
> > Does MySQL 4.1 support the use of GROUP BY and ORDER BY u
Hi,
I tried searching for this problem, but I couldn't find any reference
to it, so here goes...
using mysql 4.0.23, I created two tables, one of them whose key is
packed. My goal is to see the effect on the size of the index file.
mysql> show create table Unpacked;
+--+--
Hi all,
I'm getting the following error when attempting to run a hot backup of a
4.0.18 MySQL database using ibbackup:
ibbackup: We wait 10 seconds before starting copying the data files...
050330 14:26:33 ibbackup: Copying /mysqldata/mysqld1/ibdata1
ibbackup: Error: log scan was only able to
I've got a good deal of experience using mysql, but never in a large
production environment with many concurrent users.
Using the InnoDB engine, what is the general practice for ensuring
data integrity when multiple users are writing to the same table?
Should I explicitly lock the table before I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
l'eau wrote:
>
> Using MySql Connect/J (mysql-connector-java-3.1.7.tar)
> on Linux Fedora 2.
>
> I use a Statement object and do the following query:
>
> String myquery = "SELECT * FROM term WHERE name REGEXP (\'"+ name
> +"\') and
Using MySql Connect/J (mysql-connector-java-3.1.7.tar)
on Linux Fedora 2.
I use a Statement object and do the following query:
String myquery = "SELECT * FROM term WHERE name REGEXP (\'"+ name
+"\') and term_type=\'"+ ontology +"\' LIMIT 20";
table term has 6 columns.
MySql
We finally split our huge logging aspect of an application to its own system,
and we changed the table type from InnoDB to MyIsam. This is a logging table,
1 log writer, many, many selects from customer care reps looking up the last
500 or so records. These are logs of timed events, so they al
Peter Brawley wrote:
Perhaps Oracle also has such a setting too. MySQL doesn't.
As a matter of fact, Oracle goes the other way in that if you store ''
into a VARCHAR field, it actually stores a NULL there. But it's
inconsistent in that doesn't consider a NULL varchar column to be = ''
(a literal
David
Please also have a look at MYdbPAL for MySQL. Freeware again - this will
sort out any schema conversions you might need - auto corrections. Plus you
can model the schema.
MDB conversion is shown in the tutorials.
Tim Hayes
-Original Message-
From: David Blomstrom [mailto:[EMAIL PR
On Wed, 30 Mar 2005 08:49:13 -0500, Brent Baisley <[EMAIL PROTECTED]> wrote:
> Wow, you are asking a lot, especially since an inexpensive UPS could be
> had for less than $50. You don't need one to keep the system up for a
> long time, just long enough for writes to finish. A few minutes should
> b
Asad Habib <[EMAIL PROTECTED]> wrote on 03/30/2005 10:53:38 AM:
> Does MySQL 4.1 support the use of GROUP BY and ORDER BY used in
> conjunction with one another? I have tried to execute several queries
> with both these clauses but the result set I get is different from what
I
> expect. My querie
Hi,
I'm getting this strange error when there are more than 1100 mysql
connections connected to the same server.
[EMAIL PROTECTED] mysql]# bin/mysql
bin/mysql: connect to server at 'localhost' failed
error: 'Can't create a new thread (errno 11). If you are not out of
available memory, you can con
My response intermixed...
"Denis Gerasimov" <[EMAIL PROTECTED]> wrote on 03/30/2005 09:29:00
AM:
>
> > >
> > > Hello list,
> > >
> > > I have two MySQL 4.1 servers, one local and one remote. I need to
> > transfer
> > > database from one server to another. What actually is the best way
of
> >
Duan Pavlica writes:
>maybe this is a silly question but how useful it is to create indexes
>on columns containing only values 0 and 1 (true and false)?
Most of the time I'd say such an index would not be real useful. If
the distribution of this column's values is equally distributed between
thes
Hello.
See:
http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html
Search in archives at http://lists.mysql.com/mysql for more advices about
solving this problem. For example see:
http://lists.mysql.com/mysql/178152
"prathima rao" <[EMAIL PROTECTED]> wrote:
> [--
Just forwarding this to the list.
On Wednesday, March 30, 2005 10:43, Christopher Vaughan wrote:
> Tom Crimmins on Wednesday, March 30, 2005 at 11:31 AM -0500 wrote:
>> Look at the functions HOUR(time), MINUTE(time), SECOND(time). These
>> will give you interger output for each part of the time
"Christopher Vaughan" <[EMAIL PROTECTED]> wrote on 30/03/2005 16:48:47:
> I have data in a table listed as
> 44:22:22
> 333:33:33
> It stands for hhh:mm:ss
> I want to break each part of the data into different parts based on
> the ':' to separate them. Then I want to take that data and sum it.
Hi All,
When you do a insert into a MySQL database and the disk is full, the
insert just hangs waiting for that table to become available.
This is fine for applications that care about data integrity. In this
case I care more about availability and speed and would prefer it if the
inserts grac
I think I remember a match_at(":") or pat_index(":") UDF which would
return the position of the first ":" for you, but I can't find it if it
does exist.
On Wed, 30 Mar 2005, Christopher Vaughan wrote:
>I have data in a table listed as
>44:22:22
>333:33:33
>It stands for hhh:mm:ss
>I want to b
On Wednesday, March 30, 2005 10:24, Christopher Vaughan wrote:
> Tom Crimmins on Wednesday, March 30, 2005 at 11:10 AM -0500 wrote:
>> If you convert it to a time field you can use mysql built-in
>> functions to do what you want. You are limited to the range
>> -838:59:59 to 838:59:59 though.
>
On Wednesday, March 30, 2005 09:49, Christopher Vaughan wrote:
> I have data in a table listed as
> 44:22:22
> 333:33:33
> It stands for hhh:mm:ss
If you convert it to a time field you can use mysql built-in functions
to do what you want. You are limited to the range -838:59:59 to
838:59:59 th
I have data in a table listed as
44:22:22
333:33:33
It stands for hhh:mm:ss
I want to break each part of the data into different parts based on the ':' to
separate them. Then I want to take that data and sum it. I wrote an if
statement to parse through this table but I can't get it to work. I
>maybe this is a silly question but how useful it is to create indexes on
>columns containing only values 0 and 1 (true and false)?
Perhaps, instead of the index, you might revise your schema a bit.
Why do you have this boolean column? What are you trying to
achieve?
With regards,
Martijn Tonie
Does MySQL 4.1 support the use of GROUP BY and ORDER BY used in
conjunction with one another? I have tried to execute several queries
with both these clauses but the result set I get is different from what I
expect. My queries read as follows:
SELECT *, *, * FROM *
WHERE *
GROUP BY * ORDER BY *
A
Du?an Pavlica <[EMAIL PROTECTED]> wrote on 30/03/2005 16:35:40:
> Hello,
>
> maybe this is a silly question but how useful it is to create
> indexes on columns containing only values 0 and 1 (true and false)?
Since I believe that MySQL ignores indexes if it expects to get more than
30% hits, i
Hello,
maybe this is a silly question but how useful it is to create indexes on
columns containing only values 0 and 1 (true and false)?
TIA,
Dusan
hey...
i now have FC2 running mysql-4.1.10a, php5, apache 2.0.51.
for some reason, the mysql rpms that i got from rpmfind.net/rpm.pbone,
etc... didn't seem to work, as i kept getting weird lib related errors...
i started using mysql-3.23 on FC2.
i basically followed the path/instructions from
I also think this would be a good idea. I have written some UDF's
for specific internal use and often wondered if they would be useful
to others. It would be nice if there was a centralized place to search
for UDFs, so you don't have to re-invent the wheel everytime you need
a function. I thin
Thanks for all the tips. I was able to import it with
Navicat. In fact, I was amazed at how smoothly it
went. I think it imported about 30 separate tables -
nearly 4 million rows - before Navicat froze. But I
was working on some other programs and probably ran
out of memory.
It recorded over 8,000
On Wed, 30 Mar 2005, Mark Papadakis wrote:
>That is a really good idea - though I am not sure there is much of
>those out there to justify the cause, nor many developers actually
>using UDFs.
Cheers :)
I think with the right infra more people would start using and developing
UDF's, especially if
On Wednesday 30 March 2005 10:49, Brent Baisley wrote:
> Wow, you are asking a lot, especially since an inexpensive UPS could be
> had for less than $50. You don't need one to keep the system up for a
> long time, just long enough for writes to finish. A few minutes should
> be plenty.
Yeah, remem
On Wed, 30 Mar 2005, Denis Gerasimov wrote:
>
>> >
>> > Hello list,
>> >
>> > I have two MySQL 4.1 servers, one local and one remote. I need to
>> transfer
>> > database from one server to another. What actually is the best way of
>> > handling this task?
>> >
>> > Are there any standard MySQL too
> >
> > Hello list,
> >
> > I have two MySQL 4.1 servers, one local and one remote. I need to
> transfer
> > database from one server to another. What actually is the best way of
> > handling this task?
> >
> > Are there any standard MySQL tools available for doing that (I mean
> MySQL
> > Adminis
Is there a description of tables anywhere on CD-ROM for Access database.
Mikhail
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 30, 2005 9:10 AM
To: David Blomstrom; mysql@lists.mysql.com
Subject: Re: Need Help with 813-MDB File
- Original Message
Hi!
MySQL-5.0.3 is probably the most important new MySQL release in several
years. On the MySQL side, a vast number of new features, like stored
procedures and views, have been implemented in 5.0. On the InnoDB side, we
changed the table format to a more space-saving one, and implemented the
2-
- Original Message -
From: "David Blomstrom" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 29, 2005 11:29 PM
Subject: Need Help with 813-MDB File
> I acquired a CD-ROM that lists many thousands of
> animal species. The main file is a 813-MB MDB file.
> I'm not sure if it's a spreadsheet
That is a really good idea - though I am not sure there is much of
those out there to justify the cause, nor many developers actually
using UDFs.
Still, having them all in one place could be nothing but a good thing.
MarkP
On Wed, 30 Mar 2005 14:39:11 +0100 (BST), Dan Bolser
<[EMAIL PROTECTED]>
Wow, you are asking a lot, especially since an inexpensive UPS could be
had for less than $50. You don't need one to keep the system up for a
long time, just long enough for writes to finish. A few minutes should
be plenty.
I don't see a problem with IDE drives. Your drive access patterns are
- Original Message -
From: "Denis Gerasimov" <[EMAIL PROTECTED]>
To: "MySQL General List"
Sent: Wednesday, March 30, 2005 1:12 AM
Subject: The best way to transfer data to another server
>
> Hello list,
>
> I have two MySQL 4.1 servers, one local and one remote. I need to transfer
> da
Hi,
I searched for previous discussion on this topic, but didn't find any.
I would like to see a centralized MySQL hosted UDF archive and development
project. The only existing 'archives' seem to be somewhat poorly
maintained (sorry), and suffer for their duplicated efforts and being
loosely di
hai, i was trying to install mysql 4 server on
windows 2000 when configuringthe server i received the below error
in mysql server instance configuration "could not start
the service mysql error:0" can i know how to solve the
error regards p
rao
No virus found in this outgoing messag
Hello.
If you can reproduce this problem on several different installations, you
may open a new bug (because #312 is closed) and leave there a note about bug
#312.
"Stephen Moretti (cfmaster)" <[EMAIL PROTECTED]> wrote:
> Gleb Paharenko wrote:
>
> Thanks for the reply.
>
>>S
Privet:)
See:
http://dev.mysql.com/doc/mysql/en/upgrading-to-arch.html
http://dev.mysql.com/doc/mysql/en/moving.html
"Denis Gerasimov" <[EMAIL PROTECTED]> wrote:
>
> Hello list,
>
> I have two MySQL 4.1 servers, one local and one remote. I need to transfer
> database from
Hello.
Select syntax is correct on my 4.1.10a MySQL instance.
EXPLAIN is telling me 'Impossible WHERE' until I put
values in the tables so the query could produce at
least several rows. After that everything was OK.
Graham Anderson <[EMAIL PROTECTED]> wrote:
> this sql works on mys
78 matches
Mail list logo