Gustav Wiberg wrote:
Hi there!
I wonder how I'll get a div-function in SQL?
I dunno, maybe by looking in the manual? From [1]:
Division:
mysql> SELECT 3/5;
-> 0.60
[1] http://dev.mysql.com/doc/mysql/en/arithmetic-functions.html
--
Jasper Bryant-Greene
Freelance web developer
http:/
Hi there!
I wonder how I'll get a div-function in SQL?
I want to divide to columns and make a new column based on the result.
/G
@varupiraten.se
Hi there!
I wonder how I'll get a div-function in SQL?
I want to divide to columns and make a new column based on the result.
/G
@varupiraten.se
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.
--
===
Jab
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 acc
I'd try setting
innodb_buffer_pool_size=8G
in my.cnf
--
Alexey Polyakov
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
R
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]
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 kn
[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,
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
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.
> Pl
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.
mysq
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 chec
> 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
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 Te
> 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: http:
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)
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 reg
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 '
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.
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 mo
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 |
+-+---+
| skip_ne
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 s
> --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
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.
--- GoldED
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-
From:
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
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
"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.
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 s
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 acro
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 user_d
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], [EMAIL
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: mysql@list
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 varchar(
> 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]
user=m
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
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 Connection
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 t
"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
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 i
[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 tabl
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 Maili
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 Pa
45 matches
Mail list logo
