Re: Replicating queries to testing server

[Scott Tanner]

On Tue, 2006-06-13 at 19:04, Dan Trainor wrote:
> Jake Peavy wrote:
> > On 5/24/06, *Dan Trainor* <[EMAIL PROTECTED] > 
> > wrote:
> > 
> > Hi -
> > 
> > I would like to be able to replicate all queries from a live MySQL
> > server, to a testing server at the office.
> > 
> > The reason for doing this is to test load under [semi]real-world
> > conditions with the new server.  I think that by doing something like
> > this, I would be able to fine-tune the new server in preparation for
> > replacing the original server.
> > 
> > So what I can't figure out right now is how to set up a situation like
> > this, where the live server would replicate every one of it's
> > queries to
> > the testing machine, and have the testing machine not respond with
> > anything - just simply mow through the queries.
> > 
> > The testing server will have a snapshot of the live database, so I will
> > ahve data to work with.  However, the testing machine is on a private
> > internal subnet, and I don't see how this type of setup would work from
> > a logical MySQL standpoint.
> > 
> > Keeping all this in mind, also remember that I cannot change any of the
> > code which references the MySQL server.  I need to be able to do this
> > using some native MySQL function.
> > 
> > Any feedback would be greatly appreciated.  I look forward to all your
> > responses.
> > 
> > Thanks!
> > -dant
> > 
> > 
> > Big Dan T?
> > 
> > I haven't done it, but I think what you need to do is
> > 
> >1. enable binlog on the live DB
> >2. transfer the binlogs from some period of time over to your test server
> >3. pipe the queries contained in the binlog into your test server,
> >   something along the lines of:   $ mysqlbinlog
> >   bin_file_from_live_db.0001 | mysql
> > 
> > HTH,
> > 
> > -- 
> > -jp
> 
> Hi, Jake -
> 
> This would certainly work.  However, I'd like to do all of this as close 
> to real-time as I possibly can.  I don't think that I can get an 
> accurate representation of load if I just throw it on the new machine 
> that way.
> 
> Thanks though!
> -dant

The binlog would only give you the changes (updates, inserts, and
deletes). The general log (--log) would be a better representation of
the server, since it logs all actions, when they started, and from which
host.
 The issue is in making the play-back real-time. I dont believe
mysqlbinlog takes the start time into consideration, so the playback
would be one single serial thread with no delays between transactions.
Not realistic. A little scripting and parsing would create what your
looking for though.

 You could also do a tcpdump at the DB server, only capturing the
incoming mysql statements (providing your not doing SSL encapsulation).
This would also give you the timing and all transactions, but I'm not
sure how the server would handle TCP playback.

 In trying to do the same thing, we ended up creating a java based
stress testing tool to mimic our DB traffic, using the basic info from
TCP dumps as a model.

Regards,
Scott


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Reset (or Defrag) the AUTO_INCREMENT columns

[Daniel Kasak]

wolverine my wrote:

> Yes, I agree on what you have described.
>
> However, what should we do when the value is reaching the maximum? To
> alter the data type to a bigger one?

Yes - convert the data type to a larger one.

If you've got a mediumint, for example, you can convert it to an
unsigned mediumint. The 'unsigned' bit means that the field won't store
negative values - this gives you twice the positive numbers you can
store. Otherwise if you're already using an unsigned data type, then
just go up to the next data type ( eg mediumint to int, or int to
bigint, etc ).

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Reset (or Defrag) the AUTO_INCREMENT columns

[wolverine my]

Yes, I agree on what you have described.

However, what should we do when the value is reaching the maximum? To
alter the data type to a bigger one?


On 6/14/06, Daniel Kasak <[EMAIL PROTECTED]> wrote:

wolverine my wrote:

> May I know if there is any way we can reset (or defrag?) the values

You shouldn't do that. It's much easier for you as a database
administrator if these values are left up to MySQL.

What happens, for example, if you restore from a backup that has rows
which you recently deleted? You'll have a number of records ( possibly
many ), all with the same primary key. How do you figure out which
record is the oldest one, which is the 2nd oldest one, which is the
current one, etc? What happens if you have records in a related column
that were referring to this primary key? You've got a big mess!

Also, there's no such thing as 'defrag'ing an auto_increment column. The
space left when you delete a row will be taken by another record when
MySQL sees fit.

If you absolutely must have a continuous stream of numbers for your
primary key, then don't use an auto_increment column. Instead, use a
numeric column and write some code to create your next primary key value.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: fixed or dynamic row sizes with point

[Gaspar Bakos]

Hi,


RE:
> we have a table with many (~0.5 billion) records and a geometry field
> which was defined as a simple "point". The `show table status` shows that
> the row format is dynamic, however, a simple point in the GIS
> representation has a fixed format (see: WKB: 21 bytes: 1 for MSB/LSB, 4
> for type and 2x8 for the two doubles). We experienced that in this case,
> when we include this point field all `select`ions and indexing (alter
> table ... add [spatial] index ...) are much slower rather than if we
> exclude this "point" object.

I made a couple of new tests related to this.

To give further examples, if the table contains a point-type column
(MMpoint) at the end, selection based on another column (e.g. MMI) is
about 2 to 3x slower (with or without indexing on MMI).

Splitting of geometry information from the table to a separate table,
and using join, greatly increases speed, especially if done on
10million or more records.

All in all, it is a great pity that the geometry.point type can not be
chosen as fixed "width".

Gaspar

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Reset (or Defrag) the AUTO_INCREMENT columns

[Daniel Kasak]

wolverine my wrote:

> May I know if there is any way we can reset (or defrag?) the values

You shouldn't do that. It's much easier for you as a database
administrator if these values are left up to MySQL.

What happens, for example, if you restore from a backup that has rows
which you recently deleted? You'll have a number of records ( possibly
many ), all with the same primary key. How do you figure out which
record is the oldest one, which is the 2nd oldest one, which is the
current one, etc? What happens if you have records in a related column
that were referring to this primary key? You've got a big mess!

Also, there's no such thing as 'defrag'ing an auto_increment column. The
space left when you delete a row will be taken by another record when
MySQL sees fit.

If you absolutely must have a continuous stream of numbers for your
primary key, then don't use an auto_increment column. Instead, use a
numeric column and write some code to create your next primary key value.

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Reset (or Defrag) the AUTO_INCREMENT columns

[wolverine my]

Hi!

I have the following tables and the data,

CREATE TABLE category (
   id TINYINT UNSIGNED AUTO_INCREMENT PRIMARY KEY
   name VARCHAR(50) NOT NULL
);

CREATE TABLE user (
   id TINYINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
   name VARCHAR(50) NOT NULL,
   category TINYINT UNSIGNED REFERENCES category(id)
);


SELECT * FROM category;
+++
| id | name   |
+++
|  1 | Classic|
|  2 | Gold   |
|  5 | Platinum   |
|  6 | Blacklist  |
+++

SELECT * FROM user;
+++--+
| id | name   | category |
+++--+
|  2 | John   | 1|
|  3 | Mark   | 2|
|  5 | Kenneth| 5|
|  6 | Sammy  | 6|
|  8 | Jane   | 5|
+++--+


Based on the above, the values of both ids are defragmented.
The category.id 3 and 4 are deleted and
the user.id 1, 4 and 7 are deleted.

May I know if there is any way we can reset (or defrag?) the values so
that they look like the following?


SELECT * FROM category;
+++
| id | name   |
+++
|  1 | Classic|
|  2 | Gold   |
|  3 | Platinum   |
|  4 | Blacklist  |
+++

SELECT * FROM user;
+++--+
| id | name   | category |
+++--+
|  1 | John   | 1|
|  2 | Mark   | 2|
|  3 | Kenneth| 3|
|  4 | Sammy  | 4|
|  5 | Jane   | 3|
+++--+

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replicating queries to testing server

[Dan Trainor]

Jake Peavy wrote:

On 5/24/06, *Dan Trainor* <[EMAIL PROTECTED] > wrote:

Hi -

I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.

The reason for doing this is to test load under [semi]real-world
conditions with the new server.  I think that by doing something like
this, I would be able to fine-tune the new server in preparation for
replacing the original server.

So what I can't figure out right now is how to set up a situation like
this, where the live server would replicate every one of it's
queries to
the testing machine, and have the testing machine not respond with
anything - just simply mow through the queries.

The testing server will have a snapshot of the live database, so I will
ahve data to work with.  However, the testing machine is on a private
internal subnet, and I don't see how this type of setup would work from
a logical MySQL standpoint.

Keeping all this in mind, also remember that I cannot change any of the
code which references the MySQL server.  I need to be able to do this
using some native MySQL function.

Any feedback would be greatly appreciated.  I look forward to all your
responses.

Thanks!
-dant


Big Dan T?

I haven't done it, but I think what you need to do is

   1. enable binlog on the live DB
   2. transfer the binlogs from some period of time over to your test server
   3. pipe the queries contained in the binlog into your test server,
  something along the lines of:   $ mysqlbinlog
  bin_file_from_live_db.0001 | mysql

HTH,

--
-jp


Hi, Jake -

This would certainly work.  However, I'd like to do all of this as close 
to real-time as I possibly can.  I don't think that I can get an 
accurate representation of load if I just throw it on the new machine 
that way.


Thanks though!
-dant

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replicating queries to testing server

[Jake Peavy]

On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote:


Hi -

I would like to be able to replicate all queries from a live MySQL
server, to a testing server at the office.

The reason for doing this is to test load under [semi]real-world
conditions with the new server.  I think that by doing something like
this, I would be able to fine-tune the new server in preparation for
replacing the original server.

So what I can't figure out right now is how to set up a situation like
this, where the live server would replicate every one of it's queries to
the testing machine, and have the testing machine not respond with
anything - just simply mow through the queries.

The testing server will have a snapshot of the live database, so I will
ahve data to work with.  However, the testing machine is on a private
internal subnet, and I don't see how this type of setup would work from
a logical MySQL standpoint.

Keeping all this in mind, also remember that I cannot change any of the
code which references the MySQL server.  I need to be able to do this
using some native MySQL function.

Any feedback would be greatly appreciated.  I look forward to all your
responses.

Thanks!
-dant



Big Dan T?

I haven't done it, but I think what you need to do is

  1. enable binlog on the live DB
  2. transfer the binlogs from some period of time over to your test
  server
  3. pipe the queries contained in the binlog into your test server,
  something along the lines of:   $ mysqlbinlog bin_file_from_live_db.0001 |
  mysql

HTH,

--
-jp


Filming on location for Walker: Texas Ranger, Chuck Norris brought a
stillborn baby lamb back to life by giving it a prolonged beard rub. Shortly
after the farm animal sprang back to life and a crowd had gathered, Chuck
Norris roundhouse kicked the animal, breaking its neck, to remind the crew
once more that Chuck giveth, and the good Chuck, he taketh away.

4 byte utf8 sequences

[Christopher Key]

Any ideas on whether and when MySQL is likely to support 4 byte utf8
sequences?
 
Chris Key

Re: MS access query in mysql

[Peter Brawley]

Andrew Zahn wrote:
I am using MS Access to read from a MySQL database. The query 
generated through access listed below returns incorrect data when 
executed in Access and doesn't work at all in MySQL. I believe it has 
to Last() and with the # symbols around the date. Any insight into 
this problem would be greatly appreciated.


SELECT ReturnTbl.ComponentID, ReturnTbl.PartDescription, 
Sum(ReturnTbl.Quantity) AS SumOfQuantity, Last(CompVendorListTbl.Cost) 
AS LastOfCost
FROM ReturnTbl LEFT JOIN CompVendorListTbl ON ReturnTbl.ComponentID = 
CompVendorListTbl.ComponentID

WHERE (((ReturnTbl.Date)<#2/1/2006#))
GROUP BY ReturnTbl.ComponentID, ReturnTbl.PartDescription, 
ReturnTbl.USL, ReturnTbl.RtnMfgr
HAVING (((Sum(ReturnTbl.Quantity))<>0) AND ((ReturnTbl.USL)=0) AND 
((ReturnTbl.RtnMfgr)=0))

ORDER BY ReturnTbl.PartDescription;
MySQL has no Last() function. You need a subquery (eg SELECT MAX(cost) 
FROM CompVendorListTbl WHERE componentid=returntbl.componentid), or one 
of the tricks described at 
http://dev.mysql.com/doc/refman/5.1/en/example-maximum-column-group-row.html,
or one of the tricks described under 'Within-Group Aggregates' at 
http://www.artfulsoftware.com/queries.php.


Surround date literals with '', not ##. MySQL will not expect a US date 
format unless you apply explicit formatting.


PB

-


Thanks,
Andrew Zahn





--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.4/363 - Release Date: 6/13/2006


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MS access query in mysql

[Andrew Zahn]

I am using MS Access to read from a MySQL database. The query generated 
through access listed below returns incorrect data when executed in 
Access and doesn't work at all in MySQL. I believe it has to Last() and 
with the # symbols around the date. Any insight into this problem would 
be greatly appreciated.



SELECT ReturnTbl.ComponentID, ReturnTbl.PartDescription, 
Sum(ReturnTbl.Quantity) AS SumOfQuantity, Last(CompVendorListTbl.Cost) 
AS LastOfCost
FROM ReturnTbl LEFT JOIN CompVendorListTbl ON ReturnTbl.ComponentID = 
CompVendorListTbl.ComponentID

WHERE (((ReturnTbl.Date)<#2/1/2006#))
GROUP BY ReturnTbl.ComponentID, ReturnTbl.PartDescription, 
ReturnTbl.USL, ReturnTbl.RtnMfgr
HAVING (((Sum(ReturnTbl.Quantity))<>0) AND ((ReturnTbl.USL)=0) AND 
((ReturnTbl.RtnMfgr)=0))

ORDER BY ReturnTbl.PartDescription;



Thanks,
Andrew Zahn


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replicating queries to testing server

[Dan Trainor]

nigel wood wrote:

Dan Trainor wrote:


Dan Trainor wrote:


Hi -

I would like to be able to replicate all queries from a live MySQL 
server, to a testing server at the office.


The reason for doing this is to test load under [semi]real-world 
conditions with the new server.



Hi -

So I was thinking about this more, and then it dawned on me.  This is 
simple MySQL replication.


Sorry for wasting the time.


No, it isn't. Selects aren't replicated nor is the timing true to catch 
contention problems.  I've done this recently and whilst I don't have 
time now I'll post my solution tomorrow. Assuming:


A) Your using *nux
B) Your application(s) and database are hosted on different machines
C) You have root access on one of the boxes
D) You can take a live db snapshot

It will let you record and playback your database server's load.

HTH

Nigel



Hi, Nigel -

Were you ever able to take a moment to respond?  I had not seen a 
response yet.


If time allows, I would certainly appreciate it.

Thanks!
-dant

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Windows Compiled Help MySQL Reference Manual -- Error

[Jake Peavy]

On 6/7/06, Jake Peavy <[EMAIL PROTECTED]> wrote:


On 6/7/06, Paul DuBois <[EMAIL PROTECTED]> wrote:
>
> At 17:30 -0600 6/7/06, Jake Peavy wrote:
> >Hey yall,
> >
> >I'm unable to open the .chm I just downloaded for 5.1.  I get the
> following
> >error:
> >
> >Cannot open the file: mk:@MSITStore:C:\Documents and
> Settings\jpeavy1\My
> >>Documents\refman-5.1-en.chm.
> >>
> >
> >Any ideas?
>
> It does seem to be corrupt.  We'll take a look into it.  Thanks.
>

Great.  Can you respond to this when you have an updated file up?



How's this coming along?  Still corrupt I see.   Seems like it ought to
be a pretty quick fix.

--
-jp


Chuck Norris once ate three 72 oz. steaks in one hour. He spent the first 45
minutes having sex with his waitress.

mluwwmamupnzo

[stan]

Message de la Plate-Forme SECURITE de l'Universite Sidi Med Ben Abdallah de Fes 
- USMBA -


ALERT!!!
This e-mail contained one or more infected files.
The following attachments were infected and have been repaired:

No attachments are in this category.

The following infected attachments were deleted:

1. yvge.zip/yvge.doc
  .scr: [EMAIL PROTECTED]

The following infected attachments were blocked because of Mail Policy 
violations:

No attachments are in this category.

You may wish to contact the sender to inform them about their infections.

Thank you,

 Your ISP

 Equipe USMBA  Original message text follows 


Mail transaction failed. Partial message is available.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How can i decrypt password

[Barry]

Vitaliy Okulov schrieb:

Здравствуйте, Paul.

Вы писали 13 июня 2006 г., 17:13:52:


At 14:09 +0200 6/13/06, Kim Christensen wrote:

On 6/13/06, Barry <[EMAIL PROTECTED]> wrote:

Kaushal Shriyan schrieb:

 Hi

 I have a situation here how can i decrypt the mysql database userrs
 password

 Kaushal

Not possible.

It is possible. However, that depends on which version of MySQL you
are using - and which crypt method you are using for the passwords.



mysql.user.Password is encrypted using the same algorithm as the PASSWORD()
function.  The algorithm changed in 4.1.0 and again in 4.1.1, but in all
cases, it is one-way encryption.



--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com


Hm, but if I use bruteforce or dictionary method?


It would take ages and you still wouldn't be sure if it works.

--
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.mysql.com/[EMAIL PROTECTED]

Re[2]: How can i decrypt password

[Vitaliy Okulov]

Здравствуйте, Paul.

Вы писали 13 июня 2006 г., 17:13:52:

> At 14:09 +0200 6/13/06, Kim Christensen wrote:
>>On 6/13/06, Barry <[EMAIL PROTECTED]> wrote:
>>>Kaushal Shriyan schrieb:
  Hi

  I have a situation here how can i decrypt the mysql database userrs
  password

  Kaushal
>>>Not possible.
>>
>>It is possible. However, that depends on which version of MySQL you
>>are using - and which crypt method you are using for the passwords.

> mysql.user.Password is encrypted using the same algorithm as the PASSWORD()
> function.  The algorithm changed in 4.1.0 and again in 4.1.1, but in all
> cases, it is one-way encryption.

> -- 
> Paul DuBois, MySQL Documentation Team
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com

Hm, but if I use bruteforce or dictionary method?

-- 
С уважением,
 Vitaliy  mailto:[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How can i decrypt password

[Paul DuBois]

At 14:09 +0200 6/13/06, Kim Christensen wrote:

On 6/13/06, Barry <[EMAIL PROTECTED]> wrote:

Kaushal Shriyan schrieb:

 Hi

 I have a situation here how can i decrypt the mysql database userrs
 password

 Kaushal

Not possible.


It is possible. However, that depends on which version of MySQL you
are using - and which crypt method you are using for the passwords.


mysql.user.Password is encrypted using the same algorithm as the PASSWORD()
function.  The algorithm changed in 4.1.0 and again in 4.1.1, but in all
cases, it is one-way encryption.

--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Does anybody knw the Asterisk app_addon_sql_mysql.c ?

[didier]

Hello list,

First, I apologize for my poor English
Second, i don't know if this post will be read by some Mysql expert 
having some minor expertise on Asterisk (the pbx telephony, but no 
matter here we are on the Mysql side)
I want to modify this script:  *app_addon_sql_mysql.c * to travel across 
the Fetch result set:  Backward/Forward and not only to the next row as 
this script actually do.
This script use persistent connexion to the database (because it works 
with  'use' result and not 'store' result) and don't allow user to go to 
a particular row (and of course no backward).


If somebody could help.. it's probabely trivial for a Mysql 
harskilled coder (that i'm not) but i'm unable to get a real advice from 
Asterisk users.
- see the script: 
http://ftp.digium.com/pub/asterisk/asterisk-addons-1.2.3.tar.gz

*and look at: app_addon_sql_mysql.c*

- a comment on the Asterisk wiki: 
http://www.voip-info.org/wiki/index.php?page=Asterisk+cmd+MYSQL


Thanks a lot for any advice or "how to"

Best regards


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How can i decrypt password

[Kim Christensen]

On 6/13/06, Barry <[EMAIL PROTECTED]> wrote:

Kaushal Shriyan schrieb:
> Hi
>
> I have a situation here how can i decrypt the mysql database userrs
> password
>
> Kaushal
Not possible.


It is possible. However, that depends on which version of MySQL you
are using - and which crypt method you are using for the passwords.

--
Kim Christensen

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL crashes constantly and can't get MySQL 5.0.21 to write core-file

[Wouter de Jong]

On Tue, Jun 13, 2006 at 08:55:59AM +0200, Wouter de Jong wrote:

> The symptoms are that MySQL is constantly (eg. within every 30 minutes) 
> getting signal 11's according to the logfile, and is restarting.

Problem finally tracked down and filed bug report.

Regards,

-- 
WideXS  http://www.widexs.nl
Wouter de Jong  System-Administrator
Tel +31 (0)23 5698070   Fax +31 (0)23 5698099
Bijlmermeerstraat 62,   2131 HG  HOOFDDORP, NL

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How can i decrypt password

[Vitaliy Okulov]

Здравствуйте, Kaushal.

Вы писали 13 июня 2006 г., 15:36:02:

> Hi

> I have a situation here how can i decrypt the mysql database userrs password

> Kaushal


Maybe use Cain & Abel program:
Homepage: http://www.oxid.it/cain.html
Download for winXP: http://www.oxid.it/downloads/ca_setup.exe

-- 
С уважением,
 Vitaliy  mailto:[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How can i decrypt password

[Barry]

Kaushal Shriyan schrieb:

Hi

I have a situation here how can i decrypt the mysql database userrs 
password


Kaushal

Not possible.

--
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.mysql.com/[EMAIL PROTECTED]

How can i decrypt password

[Kaushal Shriyan]

Hi

I have a situation here how can i decrypt the mysql database userrs password

Kaushal

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to set host table?

[Barry]

Takanobu Kawabe schrieb:
> 
> Hello, my name is Takanobu Kawabe.
> 
> I use MySQL 4.1.19 server now.
> I  don't know  how to  set  Host  table  in mysql  database.
> 
> For db table,tables_priv  table and so on, can set  using  GRANT SQL 
> statement.
> 
> Can I  use  this statement  for  setting  Host  table?
> 
> If  I can, what  SQL statement can I use?
> 
> Otherwise,  can I only  insert  the host  table  depended on db table? 
> 
Hello Takanobu-san!

This will surely help you:
http://dev.mysql.com/doc/refman/4.1/ja/connection-access.html

それじゃ　：）

Barry

-- 
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.mysql.com/[EMAIL PROTECTED]

Re: insert not working with auto_increment column

[Digvijoy Chatterjee]

On 6/13/06, Rob Desbois <[EMAIL PROTECTED]> wrote:

If you are going to specify values for all columns in your insert, you should 
put NULL as the value for an AUTO_INCREMENT column, e.g.
mysql> insert into SalesSupData values (NULL,2,2,'test',140);

My preferred way however is to put the column names and just miss out the 
auto_increment column:
mysql> insert into SalesSupData(ClientId, SupTypeId, Description, UserId) 
values (2,2,'test',140);

--Rob


That works
thanks
Digz

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

re: insert not working with auto_increment column

[Rob Desbois]

If you are going to specify values for all columns in your insert, you should 
put NULL as the value for an AUTO_INCREMENT column, e.g.
mysql> insert into SalesSupData values (NULL,2,2,'test',140);   

My preferred way however is to put the column names and just miss out the 
auto_increment column:
mysql> insert into SalesSupData(ClientId, SupTypeId, Description, UserId) 
values (2,2,'test',140);   

--Rob


__
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
__

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my-huge.cnf quite outdated (fwd)

[Barry]

Gaspar Bakos schrieb:

-- Forwarded message --
Date: Mon, 12 Jun 2006 11:39:11 -0400 (EDT)
From: Gaspar Bakos
To: Barry <[EMAIL PROTECTED]>
Subject: Re: my-huge.cnf quite outdated

Hello, Barry,

RE:

Guess we would answer to everyone on the list who wishes to optimize his
cnf.


I don't guess, and don't even expect that you answer to everyone.


Well if everyone would start posting "his" cnf. You would end up 
confused. That's what i pointed out with it.

Sometimes it is good to guess.




"Oh, i have add super X RAMs with latencies of blah blah. Please i
think my cnf is outdated can somone help me?" Or: "Oh, i have added a
HD with 2times more rounds per/m can you update my cnf PLZ?"


These are not what I asked, they are pretty negative exaggarations.


Well yes you did. Well they are negative but in the end you will face 
this. There are no typical 8GB, SATA II 2TB filesystem RAID clustered, 
with high connection network card configs out there that would run 
"smooothly" on your system. It's just as it is.

You have to do it by yourself.
You would be lucky as hell finding somone with the same hardware config 
as you have.





And "yes". You can tweak the shit out of the mysql.cnf files.
You have to test yourself on "your" system.


This is what I am doing, and in the meantime, looking for experience,
and also sharing mine.

Experience is only gained by doing.
I did configured Server which had half a terrabyte of data and that was 
no fun at all.
When you get further in this you will see that at the end you only have 
two ways of accomplishing it.
Reading every manual you get about the cnf and get a hang on what every 
variable do or get a customer contract and let somone configure it.




And btw. the cnf files wrk with even bigger tables than you have.
Not "optimal" but "okay".


How big?


i tested them with 350 GB files on a 4GB RAM 500GB SATA raid1 system.
And was stable.




Every special server needs special handling. there is no "the one and
only you have to do it this way" way


OK, so why is there a my-{small,large,huge}.cnf ?
They are guidelines for typical systems and applications.
But they are quite outdated, as typical systems changed.


Because those cnf do give a push in a way you want to go but when you 
want optimized configs you have to specialise it depending on the server.

That's what i said. nothing more or less



All in all: I was looking for _typical_ configs for 4GB+ machines and
100Gb+ tables.


Now guess this time. There isn't something like that.

Barry

--
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.mysql.com/[EMAIL PROTECTED]

insert not working with auto_increment column

[Digvijoy Chatterjee]

I have a problem with inserting data into table in Mysql.

I have a Auto_increment Column in Table which throws errors when I try
to insert into the table.

This is table description.
mysql> desc SalesSupData;

+-+-+--+-+-++

| Field   | Type| Null | Key | Default | Extra   |

+-+-+--+-+-++

| SSId| int(11) | NO   | PRI | NULL| auto_increment |

| ClientId| int(5)  | YES  |   | NULL  |   |

| SupTypeId   | int(5)  | YES  || NULL   | |

| Description | text| YES  | | NULL||

| UserId  | int(5)  | YES  |   | NULL   | |

+-+-+--+-+-++

This is the error I get when I try to insert using single quotes ''

mysql> insert into SalesSupData values ('',2,2,'test',140);

ERROR 1264 (22003): Out of range value adjusted for column 'SSId' at row 1

Without using quotes.

mysql> insert into SalesSupData values (2,2,'test',140);

ERROR 1136 (21S01): Column count doesn't match value count at row 1

My Application was running fine with mysql-4 ,i recently upgraded to
5 ,and all my insert queries are bombing.Can anyone help me fix this.

Regards
Digz

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to set host table?

[Takanobu Kawabe]

Hello, my name is Takanobu Kawabe.

I use MySQL 4.1.19 server now.
I  don't know  how to  set  Host  table  in mysql  database.

For db table,tables_priv  table and so on, can set  using  GRANT SQL 
statement.

Can I  use  this statement  for  setting  Host  table?

If  I can, what  SQL statement can I use?

Otherwise,  can I only  insert  the host  table  depended on db table? 

Re: SQL naming convention?

[Barry]

wolverine my schrieb:

Hi!

When writting a SQL scripts, do you follow any standard SQL naming
convention? Similar to what described in
http://kurafire.net/articles/sql-convention


Yes. Most of the time.
Depends always on where you work and what conventions were used.



Does MySQL provides such naming convention guidelines and best practices?

Nope. Since any name of a column has just to be syntactically correct.

Barry

--
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.mysql.com/[EMAIL PROTECTED]

GOOD DAY

[ro]

Message de la Plate-Forme SECURITE de l'Universite Sidi Med Ben Abdallah de Fes 
- USMBA -


ALERT!!!
This e-mail contained one or more infected files.
The following attachments were infected and have been repaired:

No attachments are in this category.

The following infected attachments were deleted:

1. document.exe: [EMAIL PROTECTED]

The following infected attachments were blocked because of Mail Policy 
violations:

No attachments are in this category.

You may wish to contact the sender to inform them about their infections.

Thank you,

 Your ISP

 Equipe USMBA  Original message text follows 


The message cannot be represented in 7-bit ASCII encoding and has been sent as 
a binary attachment.

Message de la Plate-Forme SECURITE de l'Universite Sidi Med Ben Abdallah de Fes 
- USMBA -


File attachment: document.exe

The file attached to this email was removed because it is infected with the 
[EMAIL PROTECTED] virus.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL crashes constantly and can't get MySQL 5.0.21 to write core-file

[Wouter de Jong]

Hi,

We have major problems with one of our database machines the past few
weeks. We've replaced the complete machine about 3 times now, with
different memory... no luck. So I doubt it's hardware.
It's a SuperMicro SuperServer 6014H-82 ... dual Xeon 3.0, 8GB DDR2-RAM,
4x73GB Maxtor SCSI (RAID10)

The symptoms are that MySQL is constantly (eg. within every 30 minutes) 
getting signal 11's according to the logfile, and is restarting.


060613 08:47:25  mysqld started
060613  8:47:26  InnoDB: Started; log sequence number 0 144990980
060613  8:47:26 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.21-debug'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  
Source distribution
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=67108864
read_buffer_size=6287360
max_used_connections=22
max_connections=750
threads_connected=19
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 
6206509 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Writing a core file


The memory is OK, it's a machine dedicated to MySQL with 8GB of RAM.

We're now running on Fedora Core 5 on x86_64 platform.
We were running the latest Fedora 5 RPM's (mysql-5.0.21-2.FC5.1), but 
since they are compiled with --without-debug I've rebuild it from the 
SRPM with --with-debug=full

When running this, I got no crash... but couldn't run it too long, since
the machine became very slow and a lot of clients could no longer connect 
after sometime due to timeout. 

When running with --skip-safemalloc I got the crashes as well.

I'm running with --core-file and it states 'Writing a core file' in the logs... 
but it doesn't 
write it anywhere ! I've also added --core-file-size=100 and even changed 
system-ulimit for 
corefiles to unlimited. It just never writes a core file :((

Also tried starting mysqld directly under user mysql, to bypass any possible 
problem with setuid and 
not being able to dump core files... no success.


If someone could help me with this  maybe I'm missing a step :)

Thanks in advance !

Regards,

-- 
WideXS  http://www.widexs.nl
Wouter de Jong  System-Administrator
Tel +31 (0)23 5698070   Fax +31 (0)23 5698099
Bijlmermeerstraat 62,   2131 HG  HOOFDDORP, NL

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]