Re: MySQL refusing to accept passwords

On 7/22/2011 18:48, Tim Thorburn wrote: On 7/22/2011 5:02 PM, Shawn Green (MySQL) wrote: On 7/21/2011 22:45, Tim Thorburn wrote: Hello, For those keeping score, this will be the second time in the past few months I've come upon this problem. To recap, this is happening on a development laptop

Re: MySQL refusing to accept passwords

- Original Message - > From: "Tim Thorburn" > > Before this, I did try to simply reset the root password by once > again stopping the MySQL service, starting it with --skip-grant-tables; > however regardless of what I changed the password to, I received the > same error. This error was p

Re: MySQL refusing to accept passwords

On 7/22/2011 5:02 PM, Shawn Green (MySQL) wrote: On 7/21/2011 22:45, Tim Thorburn wrote: Hello, For those keeping score, this will be the second time in the past few months I've come upon this problem. To recap, this is happening on a development laptop running Win7 64-bit Ultimate and MySQL 5.

Re: MySQL refusing to accept passwords

Hi, I dont remember the details of the past 'experience' but, did you try a simple: mysql -uroot -p -h127.0.0.1 -P3306? and also an anomymous login: mysql also make sure you remove the anonymous account if present, sometimes it introduces strange behaviours as the one you described. and as su

Re: MySQL refusing to accept passwords

On 7/22/2011 17:02, Shawn Green (MySQL) wrote: ... quick correction ... * ...the account 'root' for a new installation is* created without a password. ... I originally said 'is not'. Sorry for the confusion -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware

Re: MySQL refusing to accept passwords

On 7/21/2011 22:45, Tim Thorburn wrote: Hello, For those keeping score, this will be the second time in the past few months I've come upon this problem. To recap, this is happening on a development laptop running Win7 64-bit Ultimate and MySQL 5.5.13. This morning, all was working well. This eve

Re: MySQL refusing to accept passwords

- Original Message - > From: "Tim Thorburn" > > For those keeping score, this will be the second time in the past few Yes, I remember that. You wouldn't happen to have a known-good backup around, to verify if the password has indeed changed in the authentication tables? -- Bier met gr

Re: MySQL HA on cloud

On Thu, Jul 21, 2011 at 6:20 AM, Yogesh Kore wrote: > Hi, > > I have cloud setup where MySQL servers are installed. > > Replication is applied in between mysql servers. > > Now I want to implemet HA for MySQL. > Can any one help me how can I achieve MySQL failover? > I looked DRBD, Linux Heartbeat

Re: MySQL RAND() Issues [was Re: How to Shuffle data]

Am 15.07.2011 19:40, schrieb Jan Steinman: >> From: Reindl Harald >> >> do not use any random-functions of mysql even if they exists >> http://bugs.mysql.com/bug.php?id=59253 > > So RAND() can be useful, but it is not really very random the problem is the idiotic temp table fecth a random reco

Re: MySQL RAND() Issues [was Re: How to Shuffle data]

In the last episode (Jul 15), Arthur Fuller said: > This would be sooo much simpler to solve in MS-SQL, given the function > NewID(), which is guaranteed to return a unique value. I have used this > in a few web sites and it works splendidly; something along the lines of > > SELECT TOP 10 *, NewI

Re: MySQL RAND() Issues [was Re: How to Shuffle data]

I have found this approach pretty effective: select *, rand() r from [mytable] where [condition] order by r limit 10 as long as you are aware that a random number is generated for every row in the table. - michael dykman On Fri, Jul 15, 2011 at 2:12 PM, Arthur Fuller wrote: > This would

Re: MySQL RAND() Issues [was Re: How to Shuffle data]

This would be sooo much simpler to solve in MS-SQL, given the function NewID(), which is guaranteed to return a unique value. I have used this in a few web sites and it works splendidly; something along the lines of SELECT TOP 10 *, NewID() FROM User_Messages ORDER BY NewID which is guaranteed to

Re: MySQL and set complements

Just now realized I answered to Mike only oops. So posting it again... forcing the use of the use_id index didn't really improve things, unfortunately. Cheers, Leonardo Borges www.leonardoborges.com On Sat, Jul 9, 2011 at 7:24 AM, mos wrote: > Leonardo, >What happens when you use "fo

Re: Mysql Trigger

On 7/10/2011 3:32 AM, vishesh kumar wrote:Hi Members Whats wrong i am doing in following create trigger statement Create trigger test before insert on user for each row begin set New.host=upper(new.host) end Above statement giving error check sql syntax , please guide me.

Re: Mysql Trigger

Thanks for reply , but i want to do only for certain record that i will put using IF On Sun, Jul 10, 2011 at 2:42 PM, Reindl Harald wrote: > > > Am 10.07.2011 10:32, schrieb vishesh kumar: > > Hi Members > > > > Whats wrong i am doing in following create trigger statement > > > > Create trigger

Re: Mysql Trigger

Am 10.07.2011 10:32, schrieb vishesh kumar: > Hi Members > > Whats wrong i am doing in following create trigger statement > > Create trigger test before insert on user >for each row >begin > set New.host=upper(new.host) >end > > Above statement giving error check sql syntax

Re: MySQL and set complements

Leonardo, What happens when you use "force index(user_id)" ? See http://dev.mysql.com/doc/refman/5.1/en/index-hints.html Mike At 09:19 AM 7/8/2011, you wrote: Same as before, but with the new index listed in the possible keys: ++-+---+---+--

Re: MySQL and set complements

Same as before, but with the new index listed in the possible keys: ++-+---+---+--+--+-+++-+ | id | select_type | table | type | possible_keys | key | key_len | ref

Re: MySQL and set complements

What did the explain output look like after the new index? On Fri, Jul 8, 2011 at 8:53 AM, Leonardo Borges wrote: > Hi Johnny, > > I just gave that a try but it didn't help as I suspected. > > I still believe the problem is in mysql not being able to handle set > subtractions. Therefore, it has

Re: MySQL and set complements

Hi Johnny, I just gave that a try but it didn't help as I suspected. I still believe the problem is in mysql not being able to handle set subtractions. Therefore, it has to perform the work harder to return the rows that represent a "no match" with NULL values in place so they can then be filtere

Re: MySQL and set complements

Leonardo, I think a new compound key on email_id and activity in the activities table may help. I'm not sure if this will help or not, Its hard to test w/o having a large data set to test against. On Thu, Jul 7, 2011 at 9:07 PM, Leonardo Borges wrote: > Sure can: > > show create table activit

Re: MySQL and set complements

Sure can: show create table activities; CREATE TABLE `activities` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `country_iso` varchar(2) DEFAULT NULL, `tags` varchar(255) DEFAULT NULL, `postcode` int(11) DEFAULT NULL, `act

Re: MySQL and set complements

Can you post show create table for activity and explain output of the problem query? On Jul 7, 2011 8:51 PM, "Leonardo Borges" wrote: Hello everyone, I have an increasingly popular web application running on top of mysql and due to its popularity, I'm running into performance issues. After care

Re: MySQL Replication - promote slave

Hi, > 1. flush logs on the master (only if it's accessible, of course). > Not really necessary if you block clients (firewall rule for new connections to port 3306?). Anyway, why don't you use a dual-master setup? I find that this is a whole lot easier to administer than a master/ fallback-slav

Re: MySQL Replication - promote slave

On 22/06/2011 15:21, Matthias Urlichs wrote: Hi, 1. flush logs on the master (only if it's accessible, of course). Not really necessary if you block clients (firewall rule for new connections to port 3306?). Hi Matthias, thank you for replying! Isn't the flush logs command necessary in or

Re: Mysql Failover Recommendations

I received a recommendation to look at MySQL-MMM http://mysql-mmm.org/. However, my two servers are in different parts of the country, so I can't use any IP-based fail over solution. I truly need a proxy that listens on 127.0.0.1 and forwards to either the "local" server, of if needed, to anot

Re: Mysql Failover Recommendations

- Original Message - > From: "Mike Diehl" > > I'm about to set master-master replication and would like to get > recommendations as to the best method for getting my applications to > failover when needed. I should already be in bed, but as a very brief reply: I find automatic failove

Re: MySQL loses password?

Try starting the server using --skip-grants-table and then resetting the password for the root account. http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_skip-grant-tables I've only seen/heard of the problems you're having with legacy system tables. Did you restore the data

Re: MySQL loses password?

You can still login if you want, check skip-grant-tables. On Jun 13, 2011 11:55 AM, "Tim Thorburn" wrote: > Ok, ran several scans on my dev PC. Unsurprisingly, nothing was found. > Trying to use command line produces the error: > ERROR 1045 (28000): Access denied for user 'root'@'localhost' (usin

Re: MySQL loses password?

Ok, ran several scans on my dev PC. Unsurprisingly, nothing was found. Trying to use command line produces the error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) The same Access denied for user 'root'@'localhost' (using password: YES) happens when tryi

Re: MySQL loses password?

This happens when you use an old client / library. Can you try from command line? Also issue: mysql --version Claudio On Jun 12, 2011 3:09 PM, "Tim Thorburn" wrote: > There's been no upgrade or old pre-upgrade on this machine. I say the > same dev password for years, as it is the same password I'v

Re: MySQL loses password?

There's been no upgrade or old pre-upgrade on this machine. I say the same dev password for years, as it is the same password I've used on my dev machines throughout the years. This machine started off as a fresh install of the OS several months ago. The only version of MySQL ever on this pa

Re: MySQL loses password?

If it's recently been upgraded or had an old pre-upgrade backup restored, that's not a major surprise; and surely you won't have ben running mysql on a win7 for several years :-) In brief, mysql changed password encryptions between 4.1 and 5.0, for various reasons. The old password scheme is st

Re: MySQL server has gone away

Are you using connection pooling in your application? Regards, Chandru On 5/27/2011 11:05 AM, Claudio Nanni wrote: 'MySQL server has gone away' Can be a network problem, Just to increase complexity :) On May 26, 2011 11:03 PM, "Prabhat Kumar" wrote: I had experience with such type of error,

Re: MySQL server has gone away

Try setting wait_timeout=36000 Regards, Chandru On 5/29/2011 11:13 PM, ars k wrote: Hi Aveek, I would like to suggest some points here: You could try increasing the max allowed packets to 128MB. Though you think 16MB is enough, increasing it is not going to affect the server. It is dynamic valu

Re: MySQL server has gone away

Hi Aveek, I would like to suggest some points here: You could try increasing the max allowed packets to 128MB. Though you think 16MB is enough, increasing it is not going to affect the server. It is dynamic value, so you could revert back the changes if you feel so. Also make sure log_warnings=2 wh

Re: MySQL server has gone away

'MySQL server has gone away' Can be a network problem, Just to increase complexity :) On May 26, 2011 11:03 PM, "Prabhat Kumar" wrote: > I had experience with such type of error, It was due lack of resources > available to MySql, max connections exceeds on the server. > you can write a simple scr

Re: MySQL server has gone away

I had experience with such type of error, It was due lack of resources available to MySql, max connections exceeds on the server. you can write a simple script which will grab and store output of 'show processlist' every min. and later you cna investigate the issue. On Wed, May 25, 2011 at 3:34 A

Re: MySQL server has gone away

Nothing in the error log or the slow query log that suggests that the query size is too large or us taking too much time to execute. Thanks Aveek On May 25, 2011, at 3:53 PM, Rik Wasmus wrote: >> failed to execute "SELECT * FROM cluster_info WHERE cluster = ?": >> MySQL server has gone

Re: MySQL server has gone away

> failed to execute "SELECT * FROM cluster_info WHERE cluster = ?": > MySQL server has gone away > > The error "MySQL server has gone away" is the error from the db handle. Can > anyone give me any pointers on why that happens? I looked up the > documentation in MySQL docs and the most com

Re: MySQL Datadir under rhel6

This may be entirely down the wrong path, but I seem vaguely to remember that RedHat has the datadir and stuff (semi-) hardcoded in /etc/init.d/mysql. - Original Message - > From: "Mario Deng" > To: mysql@lists.mysql.com > Sent: Tuesday, 24 May, 2011 1:08:41 PM > Subject: MySQL Datadir

RE: MySQL ignores foreign key constraints

HARSET=latin1 | +-+-- Thanks From: Suresh Kuna [mailto:sureshkumar...@gmail.com] Sent: 20 May 2011 12:15 To: Mimi Cafe Cc: mysql@lists.mysql.com Subject: Re: MySQL ignores foreign key constraints WHat are the table engine types ? On Fri, May 20, 2

Re: MySQL ignores foreign key constraints

WHat are the table engine types ? On Fri, May 20, 2011 at 4:37 PM, Mimi Cafe wrote: > Hi > > An ideas why MySQL silently ignores any foreign key constraints I define > for > the following tables? > > > mysql> desc book; > > +--+---+--+-+---

Re: MySQL ignores foreign key constraints

Try show create table ... ; A On Fri, May 20, 2011 at 12:07 PM, Mimi Cafe wrote: > Hi > > An ideas why MySQL silently ignores any foreign key constraints I define > for > the following tables? > > > mysql> desc book; > > +--+---+--+-+

Re: MySQL v5.5.12 on Mac OSX - Server won't start...

Am 14.05.2011 17:32, schrieb rich gray: > I have installed MySQL v5.5.12 Community Server on Mac OS X v10.5.8 > > When I try and start the server I get these messages before it aborts... > > 110514 17:16:14 mysqld_safe Starting mysqld daemon with databases from > /usr/local/mysql/data > 110514

Re: MySQL Backup solution for non-technical user

On Fri, May 13, 2011 at 10:21, Joerg Bruehe wrote: > Hi everybody! > > > Dotan Cohen wrote: >> Is there a simple browser-based MySQL backup solution for >> non-technical users. [[...]] >> The main features needed are: >> 1) Automatic scheduled off-site backups (via SSH or FTP) > > Off-site = good

Re: MySQL Backup solution for non-technical user

Hi everybody! Dotan Cohen wrote: > Is there a simple browser-based MySQL backup solution for > non-technical users. [[...]] > The main features needed are: > 1) Automatic scheduled off-site backups (via SSH or FTP) Off-site = good (for reliability purposes). > 2) Backup multiple databases and a

Re: [MYSQL] need simple help

On 5/12/2011 2:30 PM, Grega Leskovšek wrote: CREATE TABLE log ( idlog int auto_increment not null, imepriimek varchar(50), clock timestamp, action varchar(30), onfile varchar(100), filesize float(6,2), uniqueid(idlog) ); CREATE TABLE log ( idlog int auto_increment primary key, imepriimek va

Re: MySQL Backup solution for non-technical user

On Tue, May 10, 2011 at 22:58, Michael Heaney wrote: > Check out Zmanda: http://zmanda.com/zrm-mysql-enterprise.html > > Michael Heaney > JCVI > On Wed, May 11, 2011 at 10:00, Johan De Meersman wrote: > Zmanda ZRM backup, although the fancy webinterface is only available in the > commercial

Re: MySQL Backup solution for non-technical user

;Michael Heaney" > To: mysql@lists.mysql.com > Sent: Tuesday, 10 May, 2011 9:58:43 PM > Subject: Re: MySQL Backup solution for non-technical user > > Check out Zmanda: http://zmanda.com/zrm-mysql-enterprise.html > > > Michael Heaney > JCVI > -- Bier met grenady

Re: MySQL Backup solution for non-technical user

On 5/10/2011 3:55 PM, Dotan Cohen wrote: Is there a simple browser-based MySQL backup solution for non-technical users. The server is running Red Hat Enterprise Linux. The main features needed are: 1) Automatic scheduled off-site backups (via SSH or FTP) 2) Backup multiple databases and all their

RE: mysql deal with specail character problem

From: 赵琦 [mailto:tyzha...@gmail.com] Sent: Thursday, April 21, 2011 9:19 PM To: Jerry Schwartz Cc: Johan De Meersman; sstap...@mnsi.net; mysql Subject: Re: mysql deal with specail character problem thanks for reply! The charater set is latin1,and the key field is mangled by the email

Re: mysql deal with specail character problem

tuxera.be] > >Sent: Thursday, April 21, 2011 9:56 AM > >To: sstap...@mnsi.net > >Cc: ??; mysql; Jerry Schwartz > >Subject: Re: mysql deal with specail character problem > > > >- Original Message - > >> From: "Steve Staples" > >&g

RE: mysql deal with specail character problem

>-Original Message- >From: Johan De Meersman [mailto:vegiv...@tuxera.be] >Sent: Thursday, April 21, 2011 9:56 AM >To: sstap...@mnsi.net >Cc: ??; mysql; Jerry Schwartz >Subject: Re: mysql deal with specail character problem > >- Original Message -

Re: mysql deal with specail character problem

- Original Message - > From: "Steve Staples" > > Doesn't the '?-1-1' mean that it's a joined key? so the 3 That's what I tought, but I *can* see the characters he's typed, and the last of what you see as ? is definitely different. -- Bier met grenadyn Is als mosterd by den wyn

RE: mysql deal with specail character problem

On Thu, 2011-04-21 at 09:35 -0400, Jerry Schwartz wrote: > >-Original Message- > >From: ?? [mailto:tyzha...@gmail.com] > >Sent: Thursday, April 21, 2011 7:09 AM > >To: mysql > >Subject: mysql deal with specail character problem > > > >Hi: > >I have a table that the field a is primary key; >

RE: mysql deal with specail character problem

é que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > From: je...@gii.co.jp > To: tyzha...@gmail.com; mysql@lists.mysql.com > Subject: RE: mysql deal with specail character problem > Date: Thu,

RE: mysql deal with specail character problem

>-Original Message- >From: ?? [mailto:tyzha...@gmail.com] >Sent: Thursday, April 21, 2011 7:09 AM >To: mysql >Subject: mysql deal with specail character problem > >Hi: >I have a table that the field a is primary key; >I insert a record like this >insert into table(a,b,c) values('?',1,1)

Re: mysql deal with specail character problem

- Original Message - > From: "赵琦" > > it is strange, the primary key field is not the same, but i get this > error. I'm entirely unsure how MySQL handles non-roman, so I'll start off with a stupid question: are you sure there was no previous entry in the table with that value for a ?

Re: Mysql issue / crashing

Okie cool, Can you paste the error log details when it came up with force recovery 6. On Wed, Apr 20, 2011 at 6:16 PM, Brent Clark wrote: > On 20/04/2011 10:10, Suresh Kuna wrote: > >> It will, try it out. >> > > Thanks for replying. > > My Colleague and I, we tried a different route. > > We retr

Re: Mysql issue / crashing

On 20/04/2011 10:10, Suresh Kuna wrote: It will, try it out. Thanks for replying. My Colleague and I, we tried a different route. We retried innodb_force_recovery. But this time we started at 1 and progressed to 6. At 6 we were able to able to start working. So for our recovery procedure w

Re: Mysql issue / crashing

It will, try it out. On Wed, Apr 20, 2011 at 1:11 PM, Brent Clark wrote: > Sorry > > Would you be so kind as to explain your thinking. > > How would upgrading Mysql fix the issue? > > Regards > Brent Clark > > > On 20/04/2011 06:23, Suresh Kuna wrote: > > Install the latest version of mysql on t

Re: Mysql issue / crashing

Sorry Would you be so kind as to explain your thinking. How would upgrading Mysql fix the issue? Regards Brent Clark On 20/04/2011 06:23, Suresh Kuna wrote: Install the latest version of mysql on top of the current version and start the database. On Tue, Apr 19, 2011 at 9:34 PM, Brent Clark

Re: Mysql issue / crashing

Install the latest version of mysql on top of the current version and start the database. On Tue, Apr 19, 2011 at 9:34 PM, Brent Clark wrote: > Thanks for replying > > 5.1.55 > > > On 19/04/2011 13:55, Suresh Kuna wrote: > > What is the version of MYSQL you are using currently ? > > On Tue, Apr

Re: Mysql issue / crashing

Thanks for replying 5.1.55 On 19/04/2011 13:55, Suresh Kuna wrote: What is the version of MYSQL you are using currently ? On Tue, Apr 19, 2011 at 3:46 PM, Brent Clark mailto:brentgclarkl...@gmail.com>> wrote: Ive added innodb_force_recovery=4 Still no go. Origin

Re: Mysql issue / crashing

What is the version of MYSQL you are using currently ? On Tue, Apr 19, 2011 at 3:46 PM, Brent Clark wrote: > Ive added > > innodb_force_recovery=4 > > Still no go. > > > Original Message > Subject:Mysql issue / crashing > Date: Tue, 19 Apr 2011 12:15:30 +0200 > From:

Got It; Thank You; Re: Mysql Bug 04/01/11

Got It; Thank You, Thank You, Thank You On 4/1/2011 11:28 PM, Claudio Nanni wrote: Hi Thomas, Did you run the post install script? http://kae.li/iiikj Claudio On Apr 2, 2011 2:20 AM, "Thomas Dineen" > wrote:

Re: Mysql Bug 04/01/11

Am 02.04.2011 13:11, schrieb Claudio Nanni: > Reindl Harald, > > I would appreciate if you could please lower your tones. > and keep this list as professional as it has always been, this is not a > nerds forum. > > *Problem:* 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't > find

Re: Mysql Bug 04/01/11: http://dev.mysql.com/doc/refman/5.0/en/starting-server.html

Am 02.04.2011 02:18, schrieb Thomas Dineen: > The following error occurs: > 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: > './mysql/host.frm' (errno: 13) BTW: you know google? "Can't find file: './mysql/host.frm' (errno: 13)" http://bugs.mysql.com/bug.php?id=1279

Re: Mysql Bug 04/01/11

Reindl Harald, I would appreciate if you could please lower your tones. and keep this list as professional as it has always been, this is not a nerds forum. There is always someone that knows more than you but he's not "shouting" at you everytime you say something wrong. If you think that a questi

Re: Mysql Bug 04/01/11

Am 02.04.2011 02:18, schrieb Thomas Dineen: >> Gentlemen: >> >> - Keep in mind that I have approximately 50 hours into this Mysql server >> install and still no >> results! what have you done the whole time? have you tried RTFM? we are not here to guide a blind one trough a basic setup becaus

Re: Mysql Bug 04/01/11

Hi, On 2-4-2011 2:18, Thomas Dineen wrote: Can't find file: './mysql/host.frm' (errno: 13) http://tinyurl.com/3sc3ydx -- Kind regards / met vriendelijke groet, Jigal van Hemert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mys

Re: Mysql Bug 04/01/11

Hi Thomas, Did you run the post install script? http://kae.li/iiikj Claudio On Apr 2, 2011 2:20 AM, "Thomas Dineen" wrote:

Re: mysql-5.0.67-sol10-x86-local Bug

Hi! Reindl Harald wrote: > Am 01.04.2011 04:28, schrieb Thomas Dineen: >> Gentle People: >> >> Using the following startup command: /etc/init.d/mysql.server start >> I get the following error: >> 110331 18:49:41 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: >> './mysql/host.frm' (err

Re: mysql-5.0.67-sol10-x86-local Bug

Am 01.04.2011 04:28, schrieb Thomas Dineen: > Gentle People: > > Using the following startup command: /etc/init.d/mysql.server start > I get the following error: > 110331 18:49:41 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: > './mysql/host.frm' (errno: 13) > 1) Where do I find or

Re: Mysql Clustering Vs Scalr

Take a look at mmm for mysql. Easy and robust. sent from my mobile phone On Mar 22, 2011 12:07 PM, "Adarsh Sharma" wrote: > Dear all, > > I researched on a link that describes that Mysql to use with scalr for > fault-tolerance and high availability. > > http://scottmartin.net/2009/07/11/creating-

Re: mysql using aio/raw device on linux

Hi... If we are to compare MySQL/binlog with Oracle's redo log, there are some known differences. First of all, the (somewhat) equivalent structure in Oracle for the MySQL's binary log is not the redo log the log writer is writing to. It is the archived log. The function of those is also

Re: mysql using aio/raw device on linux

Just my two cents. That's why it is Oracle. Oracle is (almost) an operating system, with its advanced implementation of device/file system management, up to a logical volume management just consider ASM for example. MySQL is quite simpler. May be Oracle gurus could bring some key benefit to MySQL

Re: mysql using aio/raw device on linux

Thanks Guys; The reason I was seeking RAW/AIO, is mostly about non-blocking write; Which i mean: Even though single write is not faster on RAW, if it supports raw and Asynch IO write, then MySQL can continue to submit write request to disk without waiting for the previous write to complete, and

Re: mysql using aio/raw device on linux

Thanks Guys; The reason I was seeking RAW/AIO, is mostly about non-blocking write; Which i mean: Even though single write is not faster on RAW, if it supports raw and Asynch IO write, then MySQL can continue to submit write request to disk without waiting for the previous write to complete, and

Re: mysql using aio/raw device on linux

Hi, For the actual question, I agree with the points Johan mentioned. MySQL, to my knowledge, does not have an option to use raw devices for binary logs. Even if it had it, it would not have the benefits Chao is seeking. There is indeed a tradeoff between losing transactions and performan

Re: mysql using aio/raw device on linux

- Original Message - > From: "Chao Zhu" > >One Q: Can mysql binlog use raw device on Linux? Mmm, good question. Don't really know; but I'm not convinced you'll get huge benefits from it, either. Modern filesystems tend to perform pretty close to raw throughput. >From a just-thinki

Re: mysql binlog format

- Original Message - > From: "Brent Clark" > > 'Statement may not be safe to log' Heh. Some of those statements weren't particularly safe in previous versions, either, but they didn't whine :-p Roughly, what it comes down to is that statements that contain things that may be differe

Re: MySQL Enterprise support now at Oracle?

On Thu, Mar 10, 2011 at 5:05 PM, Jim McNeely wrote: > Shawn Green works for Oracle and has been very helpful, and I am happy to > eat a little bit of shoe leather! > > Thanks Shawn! > > Jim > Check the archives for Shawn's posts. IMNSHO, they are unparalleled in clarity and depth and breadth of

Re: MySQL Enterprise support now at Oracle?

Shawn Green works for Oracle and has been very helpful, and I am happy to eat a little bit of shoe leather! Thanks Shawn! Jim On Mar 10, 2011, at 11:11 AM, Jim McNeely wrote: > Wow! We paid for MySQL enterprise plus enterprise support back in the good > old days before ORACLE bought MySQL. I

Re: mysql < vs source

In the last episode (Mar 10), Brent Clark said: > Hiya > > I just found that I can run > mysql db -e 'source exporteddbdata.sql' > > The question I would like to ask is. Is there a speed difference between > > mysql db < exporteddbdata.sql > and > mysql db -e 'source exporteddbdata.sql' > (usi

Re: Mysql 5.1 -> 5.0

Just like that, not advisable. There's upgrade scripts in the packages that should handle 5.0 to 5.1; but your safest bet is still going to be a clean mysqldump and import. - Original Message - > From: "Brent Clark" > To: mysql@lists.mysql.com > Sent: Thursday, 10 March, 2011 2:07:11 PM

Re: mysql apache md5

problem with MySQL insert of md5(foo) not be recognised by an Apache md5 wanting. Noel > - Original Message - > > From: "Edward avanti" > > To: mysql@lists.mysql.com > > Sent: Monday, 7 March, 2011 5:54:02 AM > > Subject: Re: mysql apache md5 &

Re: mysql apache md5

--- > From: "Edward avanti" > To: mysql@lists.mysql.com > Sent: Monday, 7 March, 2011 5:54:02 AM > Subject: Re: mysql apache md5 > > everything to do with mysql > I try make it clearer, sorry for not so in first post > > customer relationship manager add users

Re: mysql apache md5

On Sun, Mar 6, 2011 at 9:35 PM, Reindl Harald wrote: > Sorry but what about are you speaking? > what are you doing? > and what has this to do with mysql? > > everything to do with mysql I try make it clearer, sorry for not so in first post customer relationship manager add users into mysql we wan

Re: mysql apache md5

Sorry but what about are you speaking? what are you doing? and what has this to do with mysql? Am 06.03.2011 05:34, schrieb Edward avanti: > Hi, I am having all sorts of problem getting apache to accept its MD5 > version, this is from a CRM using perl > I've tried concat $apr1$foo$ and md5(bar)

Re: Mysql clustering

Hi Machiel, Check these two links for good resources: http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/0596101716 http://www.amazon.com/MySQL-High-Availability-Building-Centers/dp/0596807309 AFAIK there is no up-to-date (print) book about NDB (anyone?). I've used the M

Re: Mysql clustering

Try search it on howtoforge.com Or buy a book like "high performance mysql" for reference. Regards, mary. --- machi...@rdc.co.za wrote: From: Machiel Richards To: mysql mailing list Subject: Mysql clustering Date: Wed, 23 Feb 2011 08:53:10 +0200 Good day all Does anybody perhaps have

Re: Mysql clustering

On Wed, Feb 23, 2011 at 7:53 AM, Machiel Richards wrote: >I tried to find info on the net and on the mysql website, but thus > far I haven't been able to find proper documentation on how to set > everything up. > Uhh... the documentation on the mysql site is very complete, afaik. >If s

Re: Mysql to Postgresql

2011/2/22 Adarsh Sharma : > Dear all, > > Today I need to back up a mysql database and restore in Postgresql database > but I don't know how to achieve this accurately. Have a look at: "mysqldump --compatible=postgresql" command:

RE: mysql TIME_WAIT

After a TCP connection has been closed, the state changes to TIME_WAIT. If I recall correctly, this is a way to prevent the same port from being immediately reused, and allow any duplicate packets from the previous connection that might still be floating around the network time to expire. In genera

Re: MySQL Administrator

On Fri, Feb 4, 2011 at 8:03 AM, Angela liu wrote: > Is MySQL Administrator still available for MySQL 5.1 and 5.5? > I believe that line of applications has been superceded by the MySQL Workbench. If you must use MySQL administrator for some reason, they will undoubtedly connect to 5.1 and 5.5,

RE: Mysql Event scheduler

1. no 2. yes -Original Message- From: Machiel Richards [mailto:machi...@rdc.co.za] Sent: Monday, January 10, 2011 2:07 AM To: mysql mailing list Subject: Mysql Event scheduler Good day all Can anyone perhaps off hand tell me whether the following two tasks will be able to be sche

Re: MySQL raw files to .SQL

Hmm, no I had not. Does this mean that there is no native way to do it? (that would be my preference.) Sent from my iPad On Jan 1, 2011, at 12:27 PM, Wagner Bianchi wrote: > Did a tried MaatKit? MaatKit let you control over the number of threads > dedicated to extract a MySQL backup. > > Best

Re: mysql 5.5 optimize changes?

As per usual, I seem to have found the answer after asking for help... It seems our team did not cleanly remove the old centos packaged versions, or perhaps there is a bug in the removal scripts. As such, an incorrect mysqlcheck binary was running and that somehow caused the problems.

<    1   2   3   4   5   6   7   8   9   10   >