Sorry man, as everyone keeps saying, there is only 4 gig of ram in the
entire known 32 bit universe.. that includes space for
process-specific system buffers, file handles, internals... the
TOTAL amount of ram you can give to 32-bit MySQL in ANY combination is
around 3.5G (many will tell you, not
On Wed, 29 Aug 2007 18:02:31 -0400, "Michael Dykman" <[EMAIL PROTECTED]>
said:
> I mean that the theoretical limit of a 32-bit application is 4G... in
> practice, you won't quite get that (for a pile of practical reasons)..
> best to keep your configured memory requirements to around 3.5G or
> y
[EMAIL PROTECTED] wrote:
Please remove me from this list or tell me how I can do this procedure...
Thanks...
Have you noticed what the footer of each message says?
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.my
Please remove me from this list or tell me how I can do this procedure...
Thanks...
mail2web.com Enhanced email for the mobile individual based on Microsoft®
Exchange - http://link.mail2web.com/Personal/EnhancedEmail
--
MySQ
I mean that the theoretical limit of a 32-bit application is 4G... in
practice, you won't quite get that (for a pile of practical reasons)..
best to keep your configured memory requirements to around 3.5G or
you will run into weird errors.
- michael dykman
On 8/28/07, Ken Peng <[EMAIL PROTECTE
Do you mean you want to be able to display the record number as sorted by
the auto-increment field, rather than the auto-increment field itself? Or do
you just want the total number of records? Or do you just want the highest
current value of the auto-increment field?
The latter two are easy:
SEL
Jason Pruim wrote:
I see what you are getting at with this, and have decided that mucking
around with auto incrementing values doesn't exactly fit in with the way
databases were designed to work.
Somehow though, I still need to supply this whether I end up adding a
"Record" number field i
On Aug 29, 2007, at 2:30 PM, Shawn Green wrote:
Hi Jason,
Jason Pruim wrote:
Is there away to reset an auto incrementing field count? I have a
database that currently has 935 records in it but because I have
deleted a few the current number used for NEW records is 938 :)
How can I get it
It would not reset to 901 unless the highest numbered record were 900. It
won't fill in holes.
Since autoincrement fields are typically used as keys linking to other
tables, renumbering existing records is not done often. If you REALLY want
to renumber them all, copy the records to a new table but
Hi Jason,
Jason Pruim wrote:
Is there away to reset an auto incrementing field count? I have a
database that currently has 935 records in it but because I have deleted
a few the current number used for NEW records is 938 :) How can I get it
to count the records and assign a record number based
Hi All,
I have been using MySQL 5.1.x with InnoDB and Raw
Devices.
[mysqld]
innodb_data_home_dir=
innodb_data_file_path=/dev/hdd1:3Gnewraw;/dev/hdd2:2Gnewraw
...
[mysqld]
innodb_data_home_dir=
innodb_data_file_path=/dev/hdd1:5Graw;/dev/hdd2:2Graw
Is there any way to specifiy the autoexten
Yes, for a MyIsam type table.
Ed
-Original Message-
From: Jason Pruim [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 29, 2007 11:53 AM
To: emierzwa
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Reset a auto increment field?
If I understand you correctly, if my table is M
If I understand you correctly, if my table is MyISAM, after I did a
delete query I could just: "ALTER TABLE t2 AUTO_INCREMENT="1"; and
that would cause the auto increment value to be set to 901 (Assuming
900 total current records) on the next insert?
On Aug 29, 2007, at 1:48 PM, <[EMAIL PR
Peter, Baron and all,
I think that I am almost there. Here's my query to return
cycle time in hours:minutes:seconds accounting for business hours. There
is some discussion as to when a ticket cycle time ends - for example if
a person works on a ticket at 10:00 at night and closes it, i
To change the value of the AUTO_INCREMENT counter to be used for new
rows, do this:
ALTER TABLE t2 AUTO_INCREMENT = value;
You cannot reset the counter to a value less than or equal to any that
have already been used. For MyISAM, if the value is less than or equal
to the maximum value currently
> Is there away to reset an auto incrementing field count? I have a
> database that currently has 935 records in it but because I have
> deleted a few the current number used for NEW records is 938 :) How
> can I get it to count the records and assign a record number based on
> the total count?
Is there away to reset an auto incrementing field count? I have a
database that currently has 935 records in it but because I have
deleted a few the current number used for NEW records is 938 :) How
can I get it to count the records and assign a record number based on
the total count?
Hop
Dear MySQL users,
We are proud to present to you the MySQL Server 5.1.21-beta
release, a new beta version of the popular open source database.
Bear in mind that this is a beta release, and as with any other
pre-production release, caution should be taken when installing on
production level syste
Alex Arul Lurthu wrote:
To have a good understanding on the show innodb status output checkout
http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/
One area you can look at is the "LATEST DETECTED DEADLOCK". But in most
cases have found calculations on the status varia
The MySQL Proxy documentation is in place!
The MySQL Proxy is an application that communicates over the network
using the MySQL Network Protocol and provides communication between
MySQL servers and MySQL clients. In the most basic configuration, MySQL
Proxy simply passes on queries from the client
Hi Frederico,
the precedence between the comma-operator and JOIN changed
with 5.0.12.
See http://dev.mysql.com/doc/refman/5.0/en/join.html
Excerpt from that article:
Previously, the comma operator (,) and JOIN both had the same
precedence, so the join expression t1, t2 JOIN t3 was interpreted as
Try not mixing left join and comma-joins, and use an INNER JOIN keyword
between "m.manufacturers_id, products_to_categories"
Baron
Federico Giannici wrote:
Since we upgraded from MySQL 4.0 to 5.0 (under OpenBSD 4.1 amd64) the
following command:
select count(*) as total from products_descript
No, i dont see any other effect.
On 8/29/07, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi Anand,
>
> Is there any other way it effects the queries.
>
> Regards,
> Krishna
>
> On 8/29/07, Ananda Kumar < [EMAIL PROTECTED]> wrote:
> >
> > Its all ways better to use integers without quo
Since we upgraded from MySQL 4.0 to 5.0 (under OpenBSD 4.1 amd64) the
following command:
select count(*) as total from products_description pd, products p left
join manufacturers m on p.manufacturers_id = m.manufacturers_id,
products_to_categories p2c left join specials s on p.products_id =
s
Hi Anand,
Is there any other way it effects the queries.
Regards,
Krishna
On 8/29/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> Its all ways better to use integers without quotes. It would effect
> execution plan of the sql.
>
> regards
> anandkl
>
>
> On 8/29/07, Krishna Chandra Prajapati <[E
Its all ways better to use integers without quotes. It would effect
execution plan of the sql.
regards
anandkl
On 8/29/07, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> hi all,
>
> create table stu (name varchar(20), roll int(2), id decimal(2));
>
> insert into stu values ('krishna',
hi all,
create table stu (name varchar(20), roll int(2), id decimal(2));
insert into stu values ('krishna', '25', '25');
insert into stu values ('krishna', 25, 25);
The above two queries are working properly.
my question is whether it is going to impact in future.
Integer and decimal values in q
Hi,
Just to make it clear; I mean thread_concurrency, not
innodb_thread_concurrency.
Cheers,
Andrew
From: Alex Arul Lurthu [mailto:[EMAIL PROTECTED]
Sent: Wed, 29 August 2007 10:10
To: Andrew Braithwaite
Cc: mysql@lists.mysql.com
Subject: Re: thread_concurrenc
Hi All,
Also, i guess u can use tools like TOAD or sqltools to get reports on db
changes.
regards
anandkl
On 8/29/07, Edoardo Serra <[EMAIL PROTECTED]> wrote:
>
> Hi Krishna,
>you can use MySQL binlog to see queries that made changes to db
> data
>
> Hope it helps
>
> Regards
>
> Krishna
I am not sure whether you are talking about innodb_thread_concurrency. If so
please check out
http://www.mysqlperformanceblog.com/2006/06/05/innodb-thread-concurrency for
more details. Innodb_thread_concurrency works on linux.
Thanks
Alex
On 8/29/07, Andrew Braithwaite <[EMAIL PROTECTED]> wrote:
Hi,
Does anyone know if thread_concurrency works in linux or is it just
limited to Solaris and Windows?
I know the general rule is number of CPU's*2 but will this actually have
any effect with Linux's threading model?
Thanks for any help :)
Andrew
Mysql, query
This message has been scanned f
Hi!
SQL Maestro Group announce the release of SQL Maestro for MySQL 7.8, a
complete Windows GUI solution for MySQL administration and database
development.
http://www.sqlmaestro.com/products/mysql/maestro/
New features:
1. SQL Maestro for MySQL is optimized to work with MySQL servers with a
Hi Krishna,
you can use MySQL binlog to see queries that made changes to db data
Hope it helps
Regards
Krishna Chandra Prajapati ha scritto:
Hi All,
Is there is any script or tool that generate the report and send an email
for changes done in the databases;
There is any otherway (man
If you want to track the schema level changes, updates, inserts etc you
always have the binlogs/update logs. If you want to track select queries
also you have the general query log. Check out
http://dev.mysql.com/doc/refman/4.1/en/log-files.html for the different logs
available. Of course be wary o
Thanks a lot Alex.
regards
anandkl
On 8/29/07, Alex Arul Lurthu <[EMAIL PROTECTED]> wrote:
>
> To have a good understanding on the show innodb status output checkout
> http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/
>
>
> One area you can look at is the "LATEST D
Hi All,
Is there is any script or tool that generate the report and send an email
for changes done in the databases;
There is any otherway (manual) So that i can look that what changes has been
done in the database today.
Regards,
Krishna
To have a good understanding on the show innodb status output checkout
http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/
One area you can look at is the "LATEST DETECTED DEADLOCK". But in most
cases have found calculations on the status variables more helpful.
--
Ale
Hi Friends,
When i do "SHOW INNODB STATUS\G". It gives me details of transaction
happening on INNODB engine.
Please let me know what all information i should consider from this output
to ensure if everything is fine or there are issue which i should address.
I am using mysql version "5.0.41-comm
38 matches
Mail list logo