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
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
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
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
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
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
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 dae...@daevid.com wrote:
Does anyone have any suggestions on
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
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/mysql?unsub
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
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.com/mysql?unsub
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 General Mailing List
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.
select * from
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
...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 Mailing List
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
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:
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
TWEETS:
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 option.
Anything pointing to the above would be helpful.
Thanks in advance
) 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
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, Jason
--
MySQL
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 isart.mont...@gmail.comwrote:
I've been using phpmyadmin as a MySQL
: 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 had this much
trouble, but I guess historically for me, I have not done a setup from
scratch.
-Jason
--
MySQL General Mailing List
For list archives: http
: 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/mysqld_safe
!
-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 mailingli...@mailnewsrss.com
OK, I have done this:
[r...@server1
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?
-Jason
--
MySQL General
=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 what I am doing wrong...
-Jason
On Apr 28, 2009, at 5:34 PM
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 General Mailing List
For list archives: http
--master-data /root/sql_dump1.sql
Can anyone advice on what to do?
Thank You Very Much,
Jason Davis
On Sun, Feb 15, 2009 at 4:07 PM, Walter Heck li...@olindata.com 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.
On Sun, Feb 15, 2009 at 1:43 PM, Martin Gainty mgai...@hotmail.com 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.
schema: http
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
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
.
--
Jason Pruim
japr...@raoset.com
616.399.2355
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.com/[EMAIL PROTECTED]
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
11287 James St
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 unsubscribe
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]
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 me into a known pattern would
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, MI, 49424
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]
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.mysql.com/mysql
To unsubscribe:http
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, Jason Pruim wrote:
Hi
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' lines terminated
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-9337
www.raoset.com
[EMAIL PROTECTED
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` (
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
www.raoset.com
[EMAIL PROTECTED
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 gets it's info
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 PROTECTED]
wrote:
Hi Everyone,
I am attempting
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]
--
MySQL General Mailing List
For list
in advance, Jason
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://lists.mysql.com/[EMAIL PROTECTED]
--
Jason Pruim
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 stuff to access that database with php 5.
--
Jason Pruim
:)
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]
?
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]
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 an auto incrementing 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
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, MI, 49424
add it
to the feature list though and keep your e-mail to reference :)
Thanks! :)
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424
www.raoset.com
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
. 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 mysql@lists.mysql.com
Sent: Thursday, August 23, 2007 10:58:52 AM (GMT-0500) America/
New_York
Subject
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 lots
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]
--
MySQL General Mailing List
For list archives: http
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 Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
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
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-
From: Jason Pruim [mailto
to help me? :)
Thanks!
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424
www.raoset.com
[EMAIL PROTECTED]
-
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 convert to just
about
| 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...
All I want to do is load a excel file (Which I can convert
`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]
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]
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
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
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 select 'FName' FROM current; then I get 6 rows
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 SIGNED MESSAGE-
Hash
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://lists.mysql.com/[EMAIL
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 storage
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:
=
070114 22:09:05 INNODB MONITOR OUTPUT
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
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]
. 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 running MyISAM
tables for the last month, its gotten very bad in the last two weeks
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]
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, Heikki Tuuri
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 trx-conc_state
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 advice/guidance I
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 Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
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 PROTECTED] wrote:
Hi
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 Opteron and
UltraSparc T1 machines
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://lists.mysql.com
.
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]
, 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://lists.mysql.com/[EMAIL
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
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
thinking of using
a 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]
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 have
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]
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]
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 PROTECTED]
-Original Message
- 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 works?
--
Jason Teagle
[EMAIL PROTECTED]
--
MySQL General Mailing List
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 Mailing List
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 Message-
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 - 100 of 607 matches
Mail list logo