In the last episode (Aug 29), Jason Pyeron said:
Why is this not an error?
mysql select count(*) paths;
+---+
| paths |
+---+
| 0 |
+---+
1 row in set (0.00 sec)
Why should it be? You've simply omitted the optional AS keyword in a
standard no-table SELECT query.
Hi,
I use the following to connect my application to the MySQL server:
Public ConnectionString As String = driver={MySQL ODBC 3.51
Driver};server=localhost;uid=root;database=mydatabase
As you can see the version of the Connector is 3.51. I use MySQL version
4.1.11.
Martin
From: Gleb
Hallo,
I would like a single row in a table, and not more than one, to be
used as a preferred value in another application.
Is this possible, and, if yes, how?
Groetjes,
Hans.
--- GoldED+/LNX 1.1.5/050823
* Origin: The Wizard is using MBSE/Linux (2:280/1018)
--
MySQL General
[EMAIL PROTECTED] wrote:
Hallo,
I would like a single row in a table, and not more than one, to be
used as a preferred value in another application.
Is this possible, and, if yes, how?
add a column 'preferred', tinyint(1) NOT NULL.
To change the preferred value:
START TRANSACTION
UPDATE
Hi all,
I'm pretty new to the list, so please be kind :)
I'm having serious problems with our core mysql server.
We are running a Dell Poweredge 2850 with dual Xeon 3.0 processors, RAID
5 and 1Gb memory.
There are 3 main databases running on this machine, one is a freeradius
database, one
my.cnf add this: skip-name-resolve under [mysqld]
On 8/29/05, Callum McGillivray [EMAIL PROTECTED] wrote:
Hi all,
I'm pretty new to the list, so please be kind :)
I'm having serious problems with our core mysql server.
We are running a Dell Poweredge 2850 with dual Xeon 3.0 processors,
Hello.
Please send your configuration files for master and slave. Check that
you don't have skip-networking in your slave's configuration file.
Jan Roehrich [EMAIL PROTECTED] wrote:
I have a strange problem setting up replication. I followed each step of
setting up replication in the
Hello.
Your versions seem to be rather fresh. If you are able to make a
reproducible test case you may want to report a bug at:
http://bugs.mysql.com
M DR [EMAIL PROTECTED] wrote:
Hi,
I use the following to connect my application to the MySQL server:
Public ConnectionString
Hello.
=09To give you an idea of my database, I use Linux box with 6GB ram,
MySQL version 4.0.15. Most of my configuration is in lines with
my-huge.cnf.
Your version of MySQL is rather old, I strongly recommend you to upgrade
to the latest release (4.1.14 now). If your server has x86
Please send your configuration files for master and slave. Check that
you don't have skip-networking in your slave's configuration file.
Master:
--
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-bin=bin-log
server-id=1
[mysql.server]
i want to make it so that i will have to fill in all
the attributes in .so i put not null for all the
attributes. Is this correct ?? when for example do
not fill in user_name , all the other values is
accepted and stored in the databaseplease advise
create table user_details
(user_id
Use the keyword 'default' to make the attributes default to the values you
want.
Use some thing like this
user_name varchar(50) default 'default_value' not null
sujay
-Original Message-
From: joshua pereira [mailto:[EMAIL PROTECTED]
Sent: Monday, August 29, 2005 5:24 PM
To:
Hi,
MySQL online manual of Japanese edition is garbled.
http://dev.mysql.com/doc/mysql/ja/index.html
I think the manuals other than English are garbled.
What'a happen?
Hirofumi Fujiwara[EMAIL PROTECTED],
joshua pereira wrote:
i want to make it so that i will have to fill in all
the attributes in .so i put not null for all the
attributes. Is this correct ?? when for example do
not fill in user_name , all the other values is
accepted and stored in the databaseplease advise
create table
Hello
I am using mysqldump to backup my entire database (about 40GB total)
each night. I dump each table separetly, so that if mysqldump crashes
in the middle somewhere, the rest of the database still gets backed up.
Most of the tables are fairly small. About 20GB of the database is
spread
Hello.
Could not see skip-networking anywhere.
--skip-networking can be specified as the command line option. Use:
show variables like 'skip_networking';
to check if it is enabled.
Jan Roehrich [EMAIL PROTECTED] wrote:
Please send your configuration files for master and
Gustafson, Tim [EMAIL PROTECTED] wrote on 08/29/2005 09:24:36 AM:
Hello
I am using mysqldump to backup my entire database (about 40GB total)
each night. I dump each table separetly, so that if mysqldump crashes
in the middle somewhere, the rest of the database still gets backed up.
Most
Shawn,
Thanks. I should have included the switches I was using to make the
backup.
I'm using --opt --quote-names, and according to the manual, --opt
includes --quick.
Tim Gustafson
MEI Technology Consulting, Inc
[EMAIL PROTECTED]
(516) 379-0001 Office
(516) 908-4185 Fax
http://www.meitech.com/
Gustafson, Tim wrote:
When backing up this table, I get this error message every night:
/usr/local/bin/mysqldump: Error 2013: Lost connection to MySQL server
during query when dumping table `DocumentVariants` at row: 13456
The table actually has 94,916 rows in it. There are no entries in the
No, max_allowed_packet is 100 megabytes, and the maximum data field in the
database is 50MB right now, and most are well below 10MB.
Tim Gustafson
MEI Technology Consulting, Inc
[EMAIL PROTECTED]
(516) 379-0001 Office
(516) 908-4185 Fax
http://www.meitech.com/
-Original Message-
Hallo Jasper,
Op 29 Aug 05 schreef Jasper Bryant-Greene aan mysql:
I would like a single row in a table, and not more than one, to be
used as a preferred value in another application.
JBG add a column 'preferred', tinyint(1) NOT NULL.
Thank you!
Groetjes,
Hans.
---
--skip-networking can be specified as the command line option. Use:
show variables like 'skip_networking';
to check if it is enabled.
mysql show variables like 'skip_networking';
+-+---+
| Variable_name | Value |
+-+---+
| skip_networking | OFF |
Gustafson, Tim wrote:
No, max_allowed_packet is 100 megabytes, and the maximum data field
in the database is 50MB right now, and most are well below 10MB.
mmm. OK, not having any more bright ideas :-) I would try dumping
it using an explicit `--where=` claus to guarantee fixed ordering,
and
Jan Roehrich wrote:
--skip-networking can be specified as the command line option. Use:
show variables like 'skip_networking';
to check if it is enabled.
mysql show variables like 'skip_networking';
+-+---+
| Variable_name | Value |
+-+---+
|
Hi All,
We have a production Database, running mysql 4.0.17 , on a
Poweredge 2650 with 3 GB RAM, and dual Xeon 2.4 GHZ, the server
averages between 100 and 200 qps ( ,also and the CPU/MEM load is
pretty low and is extremely fast except for once in a while may be 1
in 1 queries take
Hello.
Has anyone else had similar problems? Can anyone shed some light on how
to successfully back up this database?
Have a look here:
http://dev.mysql.com/doc/mysql/en/gone-away.html
Hello
I am using mysqldump to backup my entire database (about 40GB total)
each night. I
I have a database on a mysql server (version 4.0.20-max) with this table:
mysql show create table Dsmaccnt\G
*** 1. row ***
Table: Dsmaccnt
Create Table: CREATE TABLE `Dsmaccnt` (
...
...
`Termination ` tinyint(3) unsigned NOT NULL default
Hi,
Thanks for your answers,
What is according to you the bug? Should it always return a string format
value? Or should it always return a system.byte[] format value?
And I guess you also refer to the strange behavior that it's different when
adding an ORDER BY or GROUP BY, right?
Kind
Francesco Dalla Ca' wrote:
I have a database on a mysql server (version 4.0.20-max) with this table:
mysql show create table Dsmaccnt\G
*** 1. row ***
Table: Dsmaccnt
Create Table: CREATE TABLE `Dsmaccnt` (
...
...
`Termination ` tinyint(3)
mysql create table prova (`Termination ` int);
ERROR 1166: Incorrect column name 'Termination '
The manual says:
Database, table, and column names should not end with space characters.
http://dev.mysql.com/doc/mysql/en/legal-names.html
--
MySQL General Mailing List
For list archives:
Hassan Schroeder wrote:
Does the size of the contents of that field exceed your defined
max_allowed_packet size?
Gustafson, Tim wrote:
No, max_allowed_packet is 100 megabytes, and the maximum data field in
the database is 50MB right now, and most are well below 10MB.
Tim Gustafson
MEI
I believe it's the size of the row, not the size of a
single field, that matters. Is it possible you have a
row which exceeds max_allowed_packet size?
No. There is one blob fields (always less than 50MB) and like 10 other fields,
all integers.
smime.p7s
Description: S/MIME cryptographic
If you suddenly are spiking in unauthenticated connections, you may
be the target of a network attack. This could be just a random probe,
you may be a random target or someone may be targeting you. Although
if someone were specifically targeting you, you would probably be down.
I would
Guys,
I have a huge table to which I'm attempting to update the foreign key
and index. It is taking me more than 20 hrs to complete the process and
would like to know if someone can point me in the right direction.
Please let me know of any additional information that I should provide.
Clyde Lewis [EMAIL PROTECTED] wrote on 08/29/2005 01:47:11 PM:
Guys,
I have a huge table to which I'm attempting to update the foreign key
and index. It is taking me more than 20 hrs to complete the process and
would like to know if someone can point me in the right direction.
Please
This is a test server with nothing else hitting the box. I imported a
dump of a production database and is trying to find a way to reduce the
time it takes to rebuild the index on the mentioned table
Hard Drive spec:
Clarion EMC Hard drive 100 GB internal 3.5 Fibre Channel 1 rpm buffer
[EMAIL PROTECTED] wrote:
Hallo Jasper,
Op 29 Aug 05 schreef Jasper Bryant-Greene aan mysql:
I would like a single row in a table, and not more than one, to be
used as a preferred value in another application.
JBG add a column 'preferred', tinyint(1) NOT NULL.
Thank you!
Groetjes,
Hallo Michael,
Op 29 Aug 05 schreef Michael Stassen aan [EMAIL PROTECTED]:
I would like a single row in a table, and not more than one, to
be used as a preferred value in another application.
JBG add a column 'preferred', tinyint(1) NOT NULL.
MS It's hard to say without knowing just
Get used to it, I've got similar tables, mine have less columns, but
more records, my biggest takes a week to restore a mysqldump
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If you are doing big updates on indexes, like during an import, you
want to adjust your variables accordingly. The variables that would
speed inserts and index updates are
key_buffer_size
bulk_insert_buffer_size
if using MYISAM table types:
myisam_max_sort_file_size
myisam_sort_buffer_size
I'd try setting
innodb_buffer_pool_size=8G
in my.cnf
--
Alexey Polyakov
Hello.
And I guess you also refer to the strange behavior that it's different when
adding an ORDER BY or GROUP BY, right?
Yes, in my opinion, ORDER BY shouldn't change the column's type.
M DR [EMAIL PROTECTED] wrote:
Hi,
Thanks for your answers,
What is according to
On Monday 29 August 2005 04:55 pm, Alexey Polyakov wrote:
I'd try setting
innodb_buffer_pool_size=8G
in my.cnf
Then it will run out of memory. You only get 2gig for bufferpools no matter
how much more you have.
--
===
43 matches
Mail list logo