Hi All,
Hope this is the right list to post to, excuse if it is not ;-)
Server scenario:
Dedicated server running MySQL 4 and secondary process inserting data into
MySQL
How does one calculate what the values should be for the following areas in
the my.cfg file to give optimal performance:
Jason Dimberg wrote:
> I am working on an application where data will be collected on laptops
> and then uploaded to a central database once the laptop is able to
> connect to the network after being in the field. I was initially
> thinking of using MS Access as a front end with linked tables thr
I wish I could uninstall mySQL and start over but I don't know how..
On 6/7/06, tomáz rezistänz <[EMAIL PROTECTED]> wrote:
!!
I apologize..
I should have mentioned that I am using a Mac in OSX 10.4.5
My main concern is should I begin logging into mSQL using the termi
!!
I apologize..
I should have mentioned that I am using a Mac in OSX 10.4.5
My main concern is should I begin logging into mSQL using the terminal or is
this done from a browser??... Yes, I am know nothing.. no commands.. nada..
On 6/6/06, Daniel da Veiga <[EMAIL PRO
On 6/6/06, tomáz rezistänz <[EMAIL PROTECTED]> wrote:
I have no idea how to log in to mySQL... can you help?
/bin/mysql.exe for Windows
/usr/bin/mysql (AFAIK) for *ix like
YMMV
Run it with "-u root -p" and you can provide your password.
That's the problem with wizards and howtos, you gotta K
Daniel da Veiga wrote:
On 6/6/06, Jason Dimberg <[EMAIL PROTECTED]> wrote:
I am working on an application where data will be collected on laptops
and then uploaded to a central database once the laptop is able to
connect to the network after being in the field. I was initially
thinking of using
hey what is happening. Thank you for this list.. THank you for having me.. I
would appreciate your assistance if you are familiar with this...
first off, I KNOW F¡¢K ALL about mySQL.
Now..
I'm doing this tutorial and it tells me to install phpmyadmin, mySQL, etc.
I get to a screen in phpmyadmi
[EMAIL PROTECTED] wrote:
Any idea why libmysqlclient_r.so is not being created when I compile after a
configure --without-server?
Compile MySQL with --enable-thread-safe-client configure option.
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based
Ahhh! I should have thought of this beforehand.
The query I was sending using doubles:
UPDATE track_char SET rotX = 0.0, rotY = 0.0, rotZ = 0.0WHERE name =
'Tom'
The query I was sending using ints:
UPDATE track_char SET rotX = 0, rotY = 0, rotZ = 0WHERE name = 'Tom'
There was a missing space bet
[snip]
It seems to work with INTs when I do it from the MySQL commandline. I
guess something is weird with the JDBC connector or something...
[/snip]
May I suggest echoing your query out so that you can see what it is
trying to insert?
--
MySQL General Mailing List
For list archives: http://list
It seems to work with INTs when I do it from the MySQL commandline. I
guess something is weird with the JDBC connector or something...
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 2:26 PM
To: Thomas Amundsen; mysql@lists.mysql.com
Subject:
Hi Gaspar,
OK, thanks for the info. Seems like procedure analyse() has some other
bugs, for example despite controlling the number of possible enum
fields to e.g. 16, it returns an enum with 256 elements.
By the way, I opened a bug for this issue:
http://bugs.mysql.com/20305
Regards,
Jere
[snip]
Here is what it gave me when I did describe:
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| id| int(10) unsigned | NO | PRI
Here is what it gave me when I did describe:
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| id| int(10) unsigned | NO | PRI | NULL
[snip]
Right...the thing is that they are supposed to be INTs, but I can only
successfully perform an update query if I use doubles for the fields...?
[/snip]
Do a describe on the table and make sure that they are INTs, then show
us the update statement.
"because it is hard to read"
"why?"
Right...the thing is that they are supposed to be INTs, but I can only
successfully perform an update query if I use doubles for the fields...?
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 1:59 PM
To: Thomas Amundsen; mysql@lists.mysql.com
Any idea why libmysqlclient_r.so is not being created when I compile after a
configure --without-server?
I did two other boxes this morning and everything went just fine. Now this one
(RH 9) is not getting it's libraries created. The compile/install looks like
it works just fine.
--ja
--
[snip]
Now, when I try to update the rotX, rotY, and rotZ fields, I have to put
a double into it, ints don't work. But then, when I print out the
database, it looks like this:
Which clearly indicates that it is storing the rot fields as ints.
I am just wondering why I can't give it an
Hi Rob,
So each of the old rows splits into 30 new rows.
Really 180 rows, right?
The existing table has about 85000 rows, equating to over 15 million in the new
structure.
Ways I have tried end up creating massive queries or just hogging the server
for absolutely ages - what is the best wa
[snip]
I'm currently looking for a tool that will take XML and produce a
database
from it. Not really looking for anything in particular at this point,
just
sort of scoping around. Anyone know of such a tool?
[/snip]
MySQL kinda' has a built-in tool
http://dev.mysql.com/tech-resources/arti
Hi,
I am using Java to maintain a MySQL database. I have a table in the
database created by:
"CREATE TABLE track_char ("
+ "id INT UNSIGNED NOT NULL AUTO_INCREMENT,"
+ "PRIMARY KEY (id),"
+ "name CHAR(40),"
Hi all,
I'm currently looking for a tool that will take XML and produce a database
from it. Not really looking for anything in particular at this point, just
sort of scoping around. Anyone know of such a tool?
--
Chris White
PHP Programmer/DB Sloth
Interfuel
--
MySQL General Mailing List
Fo
On 6/6/06, Eugene Kosov <[EMAIL PROTECTED]> wrote:
Hi, List!
I'm a little bit confused with (IMHO) poor query performance.
I have a table with 1'000'000 records.
Table consists of 2 service fields and a number of data fields. Service
fields are status and processor_id (added for concurrent que
Hi, List!
I'm a little bit confused with (IMHO) poor query performance.
I have a table with 1'000'000 records.
Table consists of 2 service fields and a number of data fields. Service
fields are status and processor_id (added for concurrent queue processing).
The question is why are updates s
Rob Desbois wrote (06-06-2006 15:22):
Rob, to clarify, your new 'index' column will be based on the value of
the 'part' column and individual column names from the old table?
That is correct.
Perhaps something like this, where [colnum] is derived from column name
like p1? (part+1)*[colnum]
T
On 6/6/06, Jason Dimberg <[EMAIL PROTECTED]> wrote:
I am working on an application where data will be collected on laptops
and then uploaded to a central database once the laptop is able to
connect to the network after being in the field. I was initially
thinking of using MS Access as a front en
Ask our mutual friend, Google. It has lots of answers for you.
-Original Message-
From: Peter Lauri [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 10:09 AM
To: 'Tim Lucia'; 'Jason Dimberg'; mysql@lists.mysql.com
Subject: RE: UPDATE from one server to another
Can you run rsync o
Can you run rsync on Windows environment?
-Original Message-
From: Tim Lucia [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 06, 2006 6:32 PM
To: 'Peter Lauri'; 'Jason Dimberg'; mysql@lists.mysql.com
Subject: RE: UPDATE from one server to another
rsync is a *nix utility that synchronizes t
[snip]
what type of password algorithum does mysql 5.x uses for encrypting
passwords? and how does these algorithum keeps the password in secure.
[/snip]
Here is some helpful info;
http://www.mysql.com/search/?q=password+security&charset=
--
MySQL General Mailing List
For list archives: http://
Ben Clewett wrote:
> C# has two DateTime constants:
>
> DateTime.MinValue = '0001-01-01 00:00:00.000'
> DateTime.MaxValue = '-12-31 23:59:59.999'
>
>
> MySQL really doesn't like these values, it shows warnings:
>
> +-+--+-+
Hello,
Have you taken a look at the following sections in the manual?
http://dev.mysql.com/doc/refman/5.0/en/user-names.html
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
Thanks,
Jimmy Guerrero
Sr Product Manager
My
Hi,
what type of password algorithum does mysql 5.x uses for encrypting passwords?
and how does these algorithum keeps the password in secure.
Regards,
Shivaji.
Ben Clewett wrote:
(I know that TIMESTAMP has a far smaller date range than DATETIME.
But all our data has to be time-zone independent. Therefore TIMESTAMP
is the only field appropriate for our use.)
try and see if this works
SELECT * FROM a WHERE cast(t as datetime) > '0001-01-
Hello,
Is it possible to tell myisamchk where the intermediate files (.TMD) must be
created.
Because my database are big and these not enough space in his directory.
I try with --tmpdir but this doesn't work.
I use myisamchk ver 2.7 and mysql 4.1.11
thank's
Nuno
--
MySQL General Mailing
On Mon, Jun 05, 2006 at 10:16:05PM -0700, Ken Williams wrote:
> Anyone know if 4.0.27 will be fixed for the mysql_real_escape issue?
> (http://lists.mysql.com/announce/364)
>
> 4.1 and 5 have been already, kinda wondering why 4.0 hasn't.
It will not, because 4.0 does not have this bug.
Jim Winst
Hi, Jeremy,
RE:
> Looks like a bug. The code in question is:
> >
>if (num_info.dval > -FLT_MAX && num_info.dval < FLT_MAX)
> sprintf(buff, "FLOAT(%d,%d)", num_info.integers,
> num_info.decimals);
>else
> sprintf(buff, "DOUBLE(%d,%d)", num_info.integers,
> n
Hi Barry,
> Well removing 'explicit' warnings for every user having problems with
> 3rd party modules would have mysql without any warnings nowadays ;)
>
> i think that your mono should get more stable.
I completely take this on board. This is a bug outside MySQL.
Warnings are very useful. Wh
Nenad Bosanac schrieb:
Hi
I have one problem that i can`t resolve.
still need advice or is it solved?
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
Hi all,
We have a copy of an old version of a database and a huge LOG file ( 9
Gig ) ( not the binary log unfortunately but the GENERAL QUERY LOG )
started when we put this database live.
The only solution I see would be to run the queries from this log file
to the database. What do you think?
Ben Clewett schrieb:
Hi Barry,
This is what I get:
mysql> CREATE TABLE a ( t TIMESTAMP );
Query OK, 0 rows affected (0.25 sec)
mysql> SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
Empty set, 1 warning (0.00 sec)
mysql> SHOW WARNINGS;
+-+--+--
Ben Clewett schrieb:
Hi Barry,
This will happen when comparing against a TIMESTAMP field.
CREATE TABLE a ( t TIMESTAMP );
SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
Well my msql doesn't give me any errors using that query.
neither a warning.
This "might" be a problem with windows.
Wi
Hi Barry,
This is what I get:
mysql> CREATE TABLE a ( t TIMESTAMP );
Query OK, 0 rows affected (0.25 sec)
mysql> SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
Empty set, 1 warning (0.00 sec)
mysql> SHOW WARNINGS;
+-+--+
Duncan Hill wrote:
On Tuesday 06 June 2006 15:38, [EMAIL PROTECTED] wrote:
Quoting Barry <[EMAIL PROTECTED]>:
Well my msql doesn't give me any errors using that query.
neither a warning.
Ditto.
usemysql> use test;
Database changed
mysql> CREATE TABLE a ( t TIMESTAMP );
Query OK, 0 rows affect
Quoting Barry <[EMAIL PROTECTED]>:
> Ben Clewett schrieb:
> > Hi Barry,
> >
> > This will happen when comparing against a TIMESTAMP field.
> >
> > CREATE TABLE a ( t TIMESTAMP );
> >
> > SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
> >
>
> Well my msql doesn't give me any errors using tha
On Tuesday 06 June 2006 15:38, [EMAIL PROTECTED] wrote:
> Quoting Barry <[EMAIL PROTECTED]>:
> > Well my msql doesn't give me any errors using that query.
> > neither a warning.
>
> Ditto.
>
> usemysql> use test;
> Database changed
> mysql> CREATE TABLE a ( t TIMESTAMP );
> Query OK, 0 rows affecte
There may be a technique for that in SQL, but I sure don't know it.
I'd likely approach this problem with an external language like perl.
You'll still end up processing about 15 million inserts, so it'll take a
while, but it shouldn't actually end up being all that rough on your
database server
> Rob, to clarify, your new 'index' column will be based on the value of
> the 'part' column and individual column names from the old table?
That is correct.
> Perhaps something like this, where [colnum] is derived from column name
> like p1? (part+1)*[colnum]
The actual formula I want to use i
Rob, to clarify, your new 'index' column will be based on the value of
the 'part' column and individual column names from the old table?
Perhaps something like this, where [colnum] is derived from column name
like p1? (part+1)*[colnum]
Dan
Rob Desbois wrote:
I need to upgrade a MyISAM DB
Hi Barry,
This will happen when comparing against a TIMESTAMP field.
CREATE TABLE a ( t TIMESTAMP );
SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
I understand that TIMESTAMP cannot handle this date. But I would hope
to be able to compare against this date without MySQL giving the
warnin
Ben Clewett schrieb:
To whom it may concern,
I'm involved in lots of C# coding with several coders.
I have a gripe with MySQL which may be easy to solve in future development.
C# has two DateTime constants:
DateTime.MinValue = '0001-01-01 00:00:00.000'
DateTime.MaxValue = '-12-31
rsync is a *nix utility that synchronizes two file systems, one local and
one remote (typically). It is used to produce mirrors / backups / etc. You
would not want to use it to synchronize database (raw) files via the file
system.
If you include a timestamp field, you can use that to copy across
To whom it may concern,
I'm involved in lots of C# coding with several coders.
I have a gripe with MySQL which may be easy to solve in future development.
C# has two DateTime constants:
DateTime.MinValue = '0001-01-01 00:00:00.000'
DateTime.MaxValue = '-12-31 23:59:59.999'
Ioannis Anifantakis wrote:
> Hello,
>
> I have been using MySQL version 4.0 because I have experienced problems since
> version 4.1 and later versions...
>
> I tried to update to version 5.0 but problems remain, in short
>
> Due to my stupidity I had been using latin1 encoding for my databa
I need to upgrade a MyISAM DB, one of the tables has the structure:
CREATE TABLE old_event_data (
event_id MEDIUMINT UNSIGNED NOT NULL,
p1 UNSIGNED INT NOT NULL,
...
p30 UNSIGNED INT NOT NULL,
part UNSIGNED TINYINT(1) NOT NULL
);
This is 'event data', each event having 6 entries wit
Hello,
I have been using MySQL version 4.0 because I have experienced problems since
version 4.1 and later versions...
I tried to update to version 5.0 but problems remain, in short
Due to my stupidity I had been using latin1 encoding for my database even
though everything seemed quite smo
hi, Peter
Try this:
select a.name, sum(if (b.table_a.id is NULL,0,1)) as indid from table_a a
left join table_b b on(a.id=b.table_id.id) group by a.id;
best regards,
Leo Huang
2006/6/1, Peter Lauri <[EMAIL PROTECTED]>:
Hi,
I have a table table_a and table_b:
table_a {
id
name
}
table_b {
I am not that clever, but I would just create a Web Service (WS) on the
Server that the Laptop call whenever the laptop want to push the date into
the server database.
I heard something about something called rsync, but I think that is
restricted to Linx, Unix.
/Peter
-Original Message-
Dear ladies and gentlemen,
Upscene Productions is happy to announce a new version of
the database developer tool:
"Advanced Data Generator" (version 1.6.2)
A fast test-data generator tool that comes with a library
of real-life data, can generate data to your database,
SQL script or CSV files, man
58 matches
Mail list logo
