RE: slave to master

Master-master with load balancer would be best Jason Mallory, MySQL/SQL Server DBA p: +1.480.752.1198 | m: +1.480.823.7771 | f: +1. 480.752.1105  |  www.iridium.com The information contained in this email is strictly

RE: Audit Table storage for Primary Key(s)

I'll ask the dumb question. Why not create individual history tables corresponding to your 'main' tables? So, if you have an 'address' table, then the original record could be written to an 'address_his' table via an update or delete trigger (depending on whether you allow deletions or not) when a

RE: update a row only if any column has changed, in a very large table

If'n it were my nickel, here is how I would solve the problem (at a somewhat high level). That is, assuming I had an ETL tool available. 1. Create landing tables for your source data. 2. Load data from the source table(s) to your new landing table(s). 3. Perform lookups from the new landing table

RE: Basic SELECT help

Having watched responses go back and forth, I'll throw my cave-man approach into the mix. select id from (select distinct id, count(*) from my_table where type in (2,5) group by id having count(*) = 2)a; And addressing one of your concerns about more than two variables...in this example,you wou

RE: Additional Software to Download and Install

I'm a fan of Toad for MySQL. http://toadformysql.com/index.jspa > -Original Message- > From: AndrewMcHorney [mailto:andrewmchor...@cox.net] > Sent: Friday, October 14, 2011 1:12 PM > To: mysql@lists.mysql.com > Subject: Additional Software to Download and Install > > Hello > > I just d

Periodic slow performance with Confluence application

Thank you in advance ... (I have paid support with Confluence and I have also posted my question with them.) Our installation will run for hours or days without issues, and then CPU usage quickly spikes to nearly 100%, with mysqld taking 90% or more of the CPU. Bouncing Confluence and Mysql f

Re: Any table visualization tools with wires connecting the actual columns?

Toad for MySQL can do the diagramming piece...but, it looks and feels like you might have some of the same frustrations with it as well. But, another tool worth exploring nonetheless. On Thu, Apr 7, 2011 at 2:17 PM, Daevid Vincent wrote: > Does anyone have any suggestions on this? I've written

Surge 2010 Early Registration ends Tuesday!

t and guarantee your seat to this year's event! -- Jason Dixon OmniTI Computer Consulting, Inc. jdi...@omniti.com 443.325.1357 x.241 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Register now for Surge 2010

your seat to this year's event! http://omniti.com/surge/2010/register Thanks, -- Jason Dixon OmniTI Computer Consulting, Inc. jdi...@omniti.com 443.325.1357 x.241 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/m

Last day to submit your Surge 2010 CFP!

your business sponsor/exhibit at Surge 2010, please contact us at su...@omniti.com. Thanks! -- Jason Dixon OmniTI Computer Consulting, Inc. jdi...@omniti.com 443.325.1357 x.241 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

CFP for Surge Scalability Conference 2010

icipating as an exhibitor, please visit the Surge website or contact us at su...@omniti.com. Thanks, -- Jason Dixon OmniTI Computer Consulting, Inc. jdi...@omniti.com 443.325.1357 x.241 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

CFP for Surge Scalability Conference 2010

n Surge is just what you've been waiting for. For more information, including CFP, sponsorship of the event, or participating as an exhibitor, please contact us at su...@omniti.com. Thanks, -- Jason Dixon OmniTI Computer Consulting, Inc. jdi...@omniti.com 443.325.1357 x.241 -- MySQL Gene

Re: select daily random

> At 08:59 PM 2/27/2010, you wrote: >>Hello everyone, >> >>How would I select a random row that changes daily? >> >>Thanks > > The common way would be to do: > > select * from table order by rand() limit 1; > > You can of course add a Where clause to select only those rows that were > added today.

Re: select daily random

...I am using PHP 5.2 > Hello everyone, > > How would I select a random row that changes daily? > > Thanks > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=ja...@jasoncarson.ca > > -- MySQL General

select daily random

Hello everyone, How would I select a random row that changes daily? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Exporting the result of a Query into excel

additional caveat, you could export to html or csv formats as well which would allow you to work around any size limitations imposed by Excel. Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Query help

Depending on whether you just need to count or the transaction numbers, one of the following three should get you where you want/need to be: To identify the count for comp_id = 675: select count(distinct trans_no) from trans where comp_id = 675 and result = 'o'; To identify the transactions: sel

RE: Natural join problem

Methinx you need a "GROUP BY" in there. See below. > -Original Message- > From: John Meyer [mailto:john.l.me...@gmail.com] > Sent: Thursday, September 10, 2009 6:48 PM > To: mysql@lists.mysql.com > Subject: Natural join problem > > Two tables: > > USERS: > USER_ID (PK) > . . .etc > > T

RE: MySQL Windows version

to use localhost. > Do you need Apache and PHP? Is there a Windows application that works > like > phpMyAdmin? I tried MySQLAdmin on my Linux system, but I could not cut > and > paste SQL Commands into the editor. > [Jason Trebilcock] Toad for MySQL would be another optio

Default Date and Time

) NULL, `pageweb` varchar(50) NULL, PRIMARY KEY (`pevent`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; But this throws a syntax error. I have tried Now() as well. What am I doing wrong? Best, -Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Duplicate key name when importing mysql dump file

Hi, I'm trying to import a dumpfile like so: cat aac.sql | mysql -u root AAC It all runs fine until I get something like: ERROR 1061 (42000) at line 5671: Duplicate key name 'FK_mediaZip_to_zipSet' Is there a way I can tell it to ignore or replace the key? Thanks,

Re: IDE - SQLYog

I think we've got almost all of the big ones listed. To complete the list (or at least grow the list by one), let me offer up Toad for MySQL: http://www.toadsoft.com/toadmysql/ On Wed, Jun 10, 2009 at 1:55 PM, Isart Montane wrote: > I've been using phpmyadmin as a MySQL GUI for some time and wor

Re: Start MySQL with --intit-file?

! -Jason On Apr 29, 2009, at 1:20 PM, mark konetchy wrote: Jason, It looks like mysql is erroring out when you try to start it from the command line. What does the error log say? 2009/4/29 Jason Todd Slack-Moehrle OK, I have done this: [r...@server1 ~]# mysqld_safe A mysqld process

Re: Start MySQL with --intit-file?

: Host '173.8.172.53' is not allowed to connect to this MySQL server I must be a dunce, I know you guys know what you are talking about! -Jason On Apr 29, 2009, at 12:28 PM, mark konetchy wrote: i dont think that the init.d script will accept the argument. you need to run /usr/bin/m

Re: Start MySQL with --intit-file?

apartment I get: Unable to connect to host 67.23.34.37. Be sure that the address is correct and that you have the necessary privileges. MySQL said: Host '173.8.172.53' is not allowed to connect to this MySQL server Can I start over some how or how do I fix? I have never ha

Re: Start MySQL with --intit-file?

=PASSWORD('xxx') WHERE User='root'; FLUSH PRIVILEGES; GRANT ALL ON mysql.* TO 'root'@'localhost'; FLUSH PRIVILEGES; GRANT ALL ON mysql.* TO 'root'@'173.8.172.53'; commit; But I still get that I cannot connect from 173.8.172.53 I still dont see wh

Start MySQL with --intit-file?

I am trying to start MySQL with --init-file but i get that it is an invalid option. the 'man' page and --help dont help me decide what is. Here is what I am doing: r...@server1 ~]# mysql start --init-file = cloudsql.txt mysql: unknown option '--init-file' Thoughts? -Jas

Resetting MySQL Root Password

mypassword /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' How can I reset this and allow Root access, otherwise nobody has access! Thanks, -Jason -- MySQL Gene

Re: DB crashing while dumping

On Sun, Feb 15, 2009 at 1:43 PM, Martin Gainty wrote: > Jason- > > can we see the schema and a few data rows for > `soapware_charts_xmldocumentitems` > says something about invalid pointers? > > Martin > Ok, I hope this is what you are wanting, I'm a newb. s

Re: DB crashing while dumping

On Sun, Feb 15, 2009 at 4:07 PM, Walter Heck wrote: > http://bugs.mysql.com/bug.php?id=26081 > Walter, Thanks for replying. I read the bug and the comments. This seems to be a problem on 64bit AMD hardware. Is this a correct assessment? I'm using 2x Xeon quad core 64bit. Thanks, jd

DB crashing while dumping

nsert --master-data > /root/sql_dump1.sql Can anyone advice on what to do? Thank You Very Much, Jason Davis

Re: grabbing even addresses?

s is a one time thing, but if it works well it's something that could turn into a regular thing for me to do. Thanks again! -- Jason Pruim japr...@raoset.com 616.399.2355

grabbing even addresses?

such as: 123 Main 1232 Main 1233 Main 1234 Main 12345 Main and what I want out of those would be: 1232 Main 1234 Main Any ideas? Thanks for looking! :) -- Jason Pruim japr...@raoset.com 616.399.2355

Re: need help with query...

d call it like "List" and put "People" in the people database. and then you could just query the field List and display it how ever you needed. -- Jason Pruim japr...@raoset.com 616.399.2355

Re: Zip Codes with Leading Zeros

t we are left with incomplete codes. Can you help us learn the correct procedure for dealing with, exporting and importing zip codes? Thank you very much for all your help. Keith -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql

Re: looking for "ready made" address management

open source since I don't have time to check) google is your friend! :) -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Re: Tracking changes in large datasets over time

Hi Rob --- MySQL 5. On Fri, Jul 18, 2008 at 3:01 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]> wrote: >> I'm having trouble working through a data problem. Any tips or >> keywords that might clue

Tracking changes in large datasets over time

ences in balance. Anyone have any tips? Best, Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Selecting my data first

ished by a sub query somehow but I don't know how. Thanks, - Jake -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland,

Re: Problem attempting to use load data into

And everyone else as well! -- Ask me about: Dedicated servers starting @ $59.99/mo., VPS starting @ $19.99/mo., and shared hosting starting @ $2.50/mo. Unmanaged, managed, and fully-managed! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424

Re: Problem attempting to use load data into

On Apr 14, 2008, at 3:29 PM, Daniel Brown wrote: On Mon, Apr 14, 2008 at 1:29 PM, Jason Pruim <[EMAIL PROTECTED]> wrote: Hi Everyone, I am attempting to use this command: load data infile '/volumes/raider/elks.test.txt' into table elksCurrent fields terminated by '\t

Re: Problem attempting to use load data into

Hi again everyone, After taking the advice of someone offlist I tried the "IGNORE 1 LINES" and that didn't help... Same result. I've tried a tab delimited file, and a comma separated file. Same result with both. Any other ideas? :) On Apr 14, 2008, at 1:29 PM, Ja

Re: Problem attempting to use load data into

s: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists

Problem attempting to use load data into

st Name Last Name 123 Main St Holland MI 49424 1 \t \t \n (Yes I did change the name to protect the innocent! But all data is the correct type in each row) Any Ideas? -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED]

RE: relational tables

See below... > -Original Message- > From: John Taylor-Johnston [mailto:John.Taylor- > [EMAIL PROTECTED] > Sent: Thursday, March 20, 2008 2:17 PM > To: Sebastian Mendel; mysql@lists.mysql.com > Subject: Re: relational tables > > DROP TABLE IF EXISTS `person`; > CREATE TABLE `person` ( >

Re: Question about reading info from another table.

(IE: First Name would go into FName or firstname or namefirst or something like that) On Thu, Feb 28, 2008 at 11:49 AM, Jason Pruim <[EMAIL PROTECTED]> wrote: On Feb 28, 2008, at 1:29 PM, Rob Wultsch wrote: On Thu, Feb 28, 2008 at 10:59 AM, Jason Pruim <[EMAIL PROT

Re: Question about reading info from another table.

On Feb 28, 2008, at 1:29 PM, Rob Wultsch wrote: On Thu, Feb 28, 2008 at 10:59 AM, Jason Pruim <[EMAIL PROTECTED]> wrote: Hi Everyone, I am attempting to write a PHP application that reads info from a MySQL database, and I'm wondering if I can set up a column in one table that get

Question about reading info from another table.

6 = field1 Does that make sense? Would that be a join? Or maybe a primary key? I'm new to MySQL programming so RTFM's are appreciated as long as "M" is defined :) -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 w

Re: import from exel into mysql

h delimeters thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com [EMAIL PROTECTED]

Red Hat EL and Datbase Setup

hanks in advance, Jason

Re: Query help, please..

ke depending on where you are, that may be a shorter number to count :) But I don't know anything about how to do stuff off of separate tables yet still trying to grasp that :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://li

I'm actually planning the application first instead of coding first!!! :)

? Am I right in thinking that a second table is required? Would it be called a Relational database? Or have I missed the terminology? Any help would be greatly appreciated! Thanks for looking! ohhh... and in case it makes a difference it's MySQL 5.* and I'll be writing the stu

privileges

he database. I don't need Joe Blow for indiana to have direct access :) Oh, and do I specifically have to disallow certain privileges if all I want them to be able to do is delete, select or update records? -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com [EMAIL PROTECTED]

Re: Reset a auto increment field?

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

Re: Reset a auto increment field?

he column, no error message is given and the current sequence value is not changed. Ed -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 29, 2007 11:02 AM To: Jason Pruim Cc: MySQL List Subject: Re: Reset a auto increment field? Is there away to

Reset a auto increment field?

? Hope that makes sense! Thanks for looking! :) -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com [EMAIL PROTECTED]

Re: Database architecture and security

On Aug 23, 2007, at 11:50 AM, David T. Ashley wrote: On 8/23/07, Jason Pruim <[EMAIL PROTECTED]> wrote: I am planning on having the database open to customers of mine to store their mailing addresses on-line, and be able to manage the records. Is it safe, to have 1 database with l

Re: Database architecture and security

most flexibility/security. That way I can also edit 1 database and not screw it up for the entire user base, just the one user :) - Original Message - From: "Jason Pruim" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Thursday, August 23, 2007 10:58:52

Re: Database architecture and security

--+ Now each customer/person can have multiple addresses listed. I really like the idea of being able to have multiple addresses, some of our customers right now have lots of seasonal addresses... But that's a little bit out of my comfort zone right now... I'll add it to the feature l

Database architecture and security

tting up separate databases for everyone? I should mention, no one will be accessing the database directly, it'll be through a web interface and php to display it. Any info would be greatly appreciated! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland,

Re: date query

do the math fairly easily I think... But I'm just starting out with MySQL so I may have made a huge mistake :) In fact... It's quite probable :) -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com [EMAIL PROTECTED]

Re: Import file into MySQL Database..

es be causing a problem? (I've never loaded a CSV file.) Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -----Original Message-

Re: Import file into MySQL Database..

On Aug 9, 2007, at 10:11 AM, Edward Kay wrote: -Original Message- From: Jason Pruim [mailto:[EMAIL PROTECTED] Sent: 09 August 2007 14:16 To: Gary Josack Cc: mysql@lists.mysql.com Subject: Re: Import file into MySQL Database.. On Aug 8, 2007, at 5:19 PM, Gary Josack wrote: Try

Re: Import file into MySQL Database..

If anyone wants to see the result that I get goto: http://raoset.com/ tests/legion/index.php Any help is greatly appreciated! Thanks! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com [EMAIL PROTECTED] -- MySQL General Ma

Re: Import file into MySQL Database..

to the table: A. DREW | Last | Add1 | Add2 | City | State | Zip | Date | Xcode | Reason Which is a combination of the first address and the column names. On Aug 8, 2007, at 3:34 PM, Gary Josack wrote: Jason Pruim wrote: Okay, so I have been going crazy trying to figure this out...

Re: Import file into MySQL Database..

Original Message- From: Jason Pruim [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 1:15 PM To: mysql@lists.mysql.com Subject: Import file into MySQL Database.. Okay, so I have been going crazy trying to figure this out... All I want to do is load a excel file (Which I can con

Import file into MySQL Database..

to work? Or what other info do you need to be able to help me? :) Thanks! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com [EMAIL PROTECTED]

Strange Bursts of Gtime Syscall

0x1e1 mysqld`handle_one_connection+0x2e4 libc.so.1`_thr_setup+0x67 libc.so.1`_lwp_start Best Regards, Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Changing Table Collation Doesn't Take Effect

e error when trying to run a query against it that specifies COLLATE. Any help is greatly appreciated. Thank you very much in advance. Best Regards, Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Figuring out the difference in value between 2 fields

Okay, so I have been gooling all over trying to figure this out. I'm sure it's easy enough to do, but I can't seem to find it. All I want to do is figure out the difference between 2 fields. IE: Field 1= 20 Field 2 =10 Difference between Field 1 & 2 is: 10 Any ideas? -- MySQL General Maili

Re: We would like to link to you

Yes. :) And the one before it. On May 29, 2007, at 2:14 PM, Glen Barber wrote: Um... Did everyone get this message? Quoting: Dear Sirs, We contacted you last week, because we would like to exchange links with you. We understand that there is often not enough time in the day for everyth

Re: select with like not working...

I have tried %jason%, %jason, & jason% all with the same result... Do you need to have an index of the column? Currently I didn't intentionally make one so I'm not sure if it's automatic or not... On May 25, 2007, at 1:26 PM, Mike Lockhart wrote: -BEGIN PGP SIGNE

select with like not working...

Hi all, I'm new to the list so please excuse me if I make some newbie mistakes, I am having trouble figuring out why a select statement won't work, Here's the statement: "SELECT 'FName' FROM `current` WHERE `FName` like '%jason%';". if I run s

mysql-bin.index just went poof on Master while Master Running

this before? Its a first for me. BTW, the MySQL on both boxes is 5.0.27-debug on Solaris 10. The binaries are the MySQL-built binaries. Thank you in advance for your help. Best Regards, Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Strange InnoDB Deadlock Behavior

Hi Juan, Just wanted to touchbase and see if you had any suggestions based on the my.cnf and machine config. Thank you in advance. Best Regards, Jason On 1/15/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote: Jason, Send me a my.cnf in order to view your configuration ( using innodb s

Strange InnoDB Deadlock Behavior

Hi Juan, Could the update log purging lagging behind due to a high UPDATE load cause this behavior? I was reading up here: http://dev.mysql.com/doc/refman/5.0/en/innodb-multi-versioning.html If so, would using innodb_max_purge_lag help? Thank you again so much. Best Regards, Jason -- MySQL

Strange InnoDB Deadlock Behavior

the event. Whatever causes this, it seems to come upon the server fairly quickly. Any help is greatly appreciated. Thank you in advance! Best Regards, Jason ---SHOW PROCESS LIST--- *** 1. row *** Type: InnoDB Name: Status:

Extracting transactional data from InnoDB log files

se it caused the corruption in the ibdata file. Any help is greatly appreciated. Best Regards, Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Strange Crashing Error - Assertion failed: fixed == 1, file item.h, line 1601

l get y'all a core and a stack trace. Thank you again. Any help is very much appreciated. Best Regards, Jason On 1/8/07, Mark Leith <[EMAIL PROTECTED]> wrote: Hi Jason, Jason J. W. Williams wrote: > Hello, > > We've been getting random crashes on our MySQL servers runni

Strange Crashing Error - Assertion failed: fixed == 1, file item.h, line 1601

help is greatly appreciated. Should we report this as a bug? Best Regards, Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Bizarre InnoDB Error Message ( trx->active_trans == 0, but trx->conc_state != TRX_NOT_STARTED)

Hi Heikki, Yes indeed. We have a "uid" field that is AUTO INC. Is the error more an issue of the auto inc code in InnoDB not setting its error codes correctly on a rollback than the auto increment code initiating an error? Thank you in advance. Best Regards, Jason On 12/31/06, He

Bizarre InnoDB Error Message ( trx->active_trans == 0, but trx->conc_state != TRX_NOT_STARTED)

h the DEADLOCK section. It almost appears as if the deadlock listing is so long that it runs out of buffer and doesn't get to the TRANSACTIONS or other status sections. Thank you in advance! Best Regards, Jason ---ERROR MESSAGE--- 061228 19:02:55 [ERROR] trx->active_trans == 0, but tr

Re: Befuddled Why This Locks

Hi Dan, I guess I'm curious why this query acquires a read lock. Is it because its in a transaction? Thank you very much in advance! -J On 12/22/06, Dan Nelson <[EMAIL PROTECTED]> wrote: In the last episode (Dec 21), Jason J. W. Williams said: > If someone could suggest some a

Befuddled Why This Locks

fo >= 5 && info/count >= 0.75 The befuddling part is that the bad_behavior table is table locked (preventing updates/inserts) until the query above ends. The version of MySQL is 5.0.27. Any help is greatly appreciated. Thank you in advance. Best Regards, Jason -- MySQL General

Re: MySQL Performance Degrades Significantly Over Time

without losing data, please correct me if I'm wrong. Our data is 70% write/30% read, so the write latency is important. The filesystem is ZFS. Thanks again. Best Regards, Jason On 12/4/06, Daniel da Veiga <[EMAIL PROTECTED]> wrote: On 12/4/06, Jason J. W. Williams <[EMAIL PRO

Re: MySQL Performance Degrades Significantly Over Time

looking at the SCSI IOP latency. Does this sound reasonable to you? Best Regards, Jason On 11/27/06, Daniel da Veiga <[EMAIL PROTECTED]> wrote: On 11/27/06, Jason J. W. Williams <[EMAIL PROTECTED]> wrote: > Hi, > > We're running MySQL 5.0.27 under Solaris 10 on both O

Selecting Disk Layouts for Logs & DB Files

G, and then put the databases for the slave and master on a second VG. Or is there a better way of splitting the IO for different disks? Any help is greatly appreciated. Best Regards, Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

MySQL Performance Degrades Significantly Over Time

uties. The whole thing is kind of strange. Thank you again in advance. Best Regards, Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 5 SP question: can I use parameter in LIMIT clause?

I want to write a sp return paging of recordset. CREATE PROCEDURE `sp_GetJobsDetails`(Page INT, PageSize INT) BEGIN DECLARE RecordBegin INT; DECLARE tmpPageSize INT; SET RecordBegin = Page * PageSize - PageSize; SET tmpPageSize = PageSize + 1; SELECT JOB_ID

SQL statement work in mysql4 but not mysql5

ition, f.position Error: Unknown column 'f.id' in 'on clause' The alias seem not working? What should I do, I dont want to rewrite all my sql statement Thanks. Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: UPDATE from one server to another

Daniel da Veiga wrote: On 6/6/06, Jason Dimberg <[EMAIL PROTECTED]> wrote: I am working on an application where data will be collected on laptops and then uploaded to a central database once the laptop is able to connect to the network after being in the field. I was initially think

UPDATE from one server to another

web interface. Server: Linux/MySQL 5.0 Laptops MS Access 2003 OR MySQL 5.0/ PHP 5/ Apache 2 Thank you. -- Jason -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fun with Dates and Incentives.

I think doing a sort by date with limit 10 should get you the first ten. I believe the now() function uses the server time, so no need to do date/time calcs really. Good luck, Jason Brian Menke wrote: I'm hoping for some general advice on an approach for the following scenario: I

RE: Reply / Return Address of this List

don't like people inadvertently posting personal replies thanks to that decision, should simply find another list. -- Jason Teagle [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

OOC: Reply / Return Address of this List

tice for mailing lists to have replies automatically go to the list itself. -- Jason Teagle [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Error on T_echo ?? what is this ?

I believe you are missing the trailing semicolon from the previous line of code, before the "//confirm" comment. It's a rather cryptic way of saying it found "echo" when it expected something else first. Gotta love those PHP error messages. -- Jason Teagle [EMAIL PRO

RE: error with java

t; > any other suggestion!? > > thanks :) Wild stab in the dark here - Java I/O permissions not set correctly on your machine to allow it? If I recall, Java's sandbox feature means you have to supply a permissions file for I/O. Perhaps that file already exists on the other machine that

AlterTable Structure Across Multiple DBs

across multiple dbs as opposed to editing each one individually? In retrospect I should have combined them into one db and may consider doing that. All dbs start with 'pm_' and have identically named tables MySQL 5.0.18 Windows 2003 Thank you, -- *Jason Dimberg* -- MySQL General Ma

RE: Timestamp problem in mysql5.0.18

See, for the UK, on that date, 2am to 2:59 inclusive do not officially exist - hence, 3am to 3:59 for GMT+1, etc. I couldn't quite figure why 3am was being rejected until now. I'm impressed that MySQL knows that {:v) -- Jason Teagle [EMAIL PROTECTED] > -Original Messag

RE: mysql++1.7.1 & vc++6 compile errors

mysql++.lib in your list of libraries to link to within your project? (Project - Settings - 'All Configurations' from 'Settings for:' combo, Link tab, 'Input' from 'Category' combo) -- Jason Teagle [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   3   4   5   6   7   >