are looking for utilizing these tools that make
performance schema much easier to use and under stand.
Greg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
I am doing this to move data from one table to other and getting below
error.
How can check this particular record at this row number 921888 in dats_tem
table.
insert into reports1.dats1 select * from dats_tem;
ERROR 1292 (22007): Incorrect datetime value: '-00-00 00:00:00' for
column
On 6/26/07, Brown, Charles [EMAIL PROTECTED] wrote:
The MYSQL general query log does not include timestamp of queries that
it logs because queries are logged many many seconds before they are
executed.
Which version of MySQL are you running? I'm running 5.0.22 on my
desktop, but I'm fairly
On 3/14/07, Clyde Lewis [EMAIL PROTECTED] wrote:
System Configuration: Sun Microsystems sun4u Sun Fire E2900
System clock frequency: 150 MHZ
Memory size: 65536 Megabytes
CPU: 12 @ 1200 MHz
I'm looking for a tool that will allow us to determine the max number
of databases that can run in a
We're running mysql 4.1.20. If I understand the manual correctly, I can
change max_connections while mysqld is running without restart mysqld to
make the change take effect
Correct.
But what if mysqld restarts later in some
other situations, like machine reboot, would my (global) change on
On 3/8/07, Gary Sewell [EMAIL PROTECTED] wrote:
I'm having a problem with a single repair query seemingly taking over the
whole server. I'll try and explain….
Large table or 1.2m rows, running a repair on this causes the query queue to
grow and grow and finally max out.
The problem isn't table
On 3/11/07, Jean-Sebastien Pilon [EMAIL PROTECTED] wrote:
I am running a mysql database server and we experienced a power failure.
The mysql server does not want to restart because innodb is corrupted.
Version info:
Mysql version 4.1.11-Debian_4sarge7-log
Debian sarge
Reiserfs filesystem
What
On 3/13/07, Merlin [EMAIL PROTECTED] wrote:
I just compiled mysql4.1.22 on a suse 9.3 machine. All went fine, but
when I try to change the password I get prompted for one. So I hit
return as it is supposed to be blank, right? But it seems to be not:
/usr/local/mysql/bin # ./mysqladmin -u root
On 2/20/07, Clyde Lewis [EMAIL PROTECTED] wrote:
I'm looking to find a way to determine the number of transactions
that a particular database is processing each min/hour/day/month/year
http://dev.mysql.com/doc/refman/4.1/en/show-status.html
Would like to know what is the archive db.opt.
http://www.google.co.uk/search?q=mysql+db.optstart=0ie=utf-8oe=utf-8client=firefox-arls=org.mozilla:en-US:official
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Master_SSL_Allowed: Yes
Master_SSL_CA_File: /root/.mysql/cacert.pem
Master_SSL_CA_Path: /root/.mysql/
Master_SSL_Cert: /root/.mysql/client-cert.pem
Master_SSL_Cipher:
Master_SSL_Key: /root/.mysql/client-key.pem
I need to create an application where i will be requiring a backup server
like when one server fails i can switch automatically to the other server
hosted somewhere else , now the data needs to be consistent on both the
servers, one sol is i keep automated backups on the primary server and
-2001.php?article=tricks-sept-2001kind=trid=2033open=1anc=0view=1
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
of the recently
inserted record (it's more a problem on how to *get* the id value to return
than how to return it).
If anyone can show me how to do this or point me to the appropriate
documentation, I would be grateful.
--greg
that would be. Does anyone have any ideas?
http://www.cryptnet.net/fsp/zipdy/
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Go to Control PanelSystemAdvanced. Click Environmental Variables and Find
the PATH variable under System Variables and add the full path, i.e.
c:\Program Files\...\mysql\bin to the variable.
-Original Message-
From: David Lazo [mailto:[EMAIL PROTECTED]
Sent: Friday, August 25, 2006 2:54
. If you
don't find it there, follow up with the author.
Greg
--
Greg Lehey, Senior Software Engineer, Online Backup
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838-708
VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED]
Diary http://www.lemis.com
for the build team, but the
FreeBSD Ports Collection will have it as soon as the maintainer
updates it. He's on vacation until 21 August, so normally it wouldn't
be until after that. If you have a good reason to need it earlier,
let me know and I may be able to update it for you.
Greg
--
Greg Lehey
to it; it's quite possible to shoot yourself
in the foot.
Greg
--
Greg Lehey, Senior Software Engineer, Online Backup
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838-708
VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED]
Diary http://www.lemis.com
seek, 1.6 ms transfer). Clearly big blocks improve disk
bandwidth; but if you only need 4 kB, the rest doesn't buy you
anything. That's why we discuss rather than come to any useful
conclusion.
Greg
--
Greg Lehey, Senior Software Engineer, Online Backup
MySQL AB, http://www.mysql.com/
Echunga
.
Greg
--
Greg Lehey, Senior Software Engineer, Online Backup
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838-708
VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED]
Diary http://www.lemis.com/grog/diary.html
Are you MySQL certified? http
,
I'd be very surprised in this case--see above for reasoning.
Greg
--
Greg Lehey, Senior Software Engineer, Online Backup
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838-708
VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED]
Diary http
://bugs.FreeBSD.org/).
If the problem still occurs, it would be good to get more information
about the database and query structure.
Greg
--
Greg Lehey, Senior Software Engineer, Online Backup
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838-708
VoIP: sip
?
mysqldump should not hang, so it's a bug. The real question is how
you managed to trip it. Please enter a bug report and I'll look at it
as soon as possible.
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838
On Sun, 28 May 2006 20:17:53 -0400
Daniel McQuay [EMAIL PROTECTED] wrote:
Hello list,
I just installed MySQL on my FreeBSD box here at home and am having a
few problems with privileges. I can connect to mysql using; mysql -u
mysql and there is no password needed. However, when I try to
On Sunday, May 07, 2006 6:14 PM, Greg 'groggy' Lehey wrote:
On Sunday, 7 May 2006 at 9:27:31 -0700, Robert DiFalco wrote:
What are people doing for backups on very large MySQL/InnoDB
databases? Say for databases greater than 200 GB. Curious about
the backup methods, procedures
you *like* to
do backups if you had the choice? We're currently in the final stages
of the design of an online backup solution, and in the near future
I'll publish the specs. I won't mention them now to avoid influencing
you, but now's the time to speak up if you want something specific.
Greg
something soon. As soon as we have something to show,
we'll let you know. In the meantime, we're still defining the
architecture. If (any of) you have specific wishes, please let me
know.
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone
MySQL Transaction Engine Announced,
but New MySQL Transaction Engine to be Announced:
MySQL is due to unveil a new transaction database engine at its
upcoming user conference later this month, according to a company
executive.
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http
to everyone, MySQL is back up and running.
This was definitely enlightening!
Did you establish what the cause of the problem was?
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838-708
VoIP: sip:[EMAIL
Gary Huntress wrote:
David Logan wrote:
mos wrote:
At 09:27 PM 3/31/2006, you wrote:
I have been offering free database hosting for over 4 years and I've
been doing it on a shoestring.My last MySQL server was a generic
1GHz system with 256MB RAM running Redhat 9. The performance
of calls I can make in a day) that will either
insert a new record if the referring domain is not already in there,
or simply update the timestamp if the referring domain is already in
there.
Possible?
REPLACE INTO
http://dev.mysql.com/doc/refman/5.0/en/replace.html
--
Greg Donald
Zend Certified
independent, but I can't give you a
completion date yet.
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838-708
VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED]
Are you MySQL certified? http
to
get perfect.
This is the reason why we haven't gone that route with MySQL.
What would it take on our side for you to reconsider that decision?
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838-708
-features.html
snipMySQL only supports one master and many slaves./snip
--
Greg Donald
Zend Certified Engineer
MySQL Core Certification
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
exist on each server, are there
any tools that can do that? Can phpMyAdmin manage multiple mysql
servers?
Additional MySQL servers can be defined in phpMyAdmin's config.inc.php file.
--
Greg Donald
Zend Certified Engineer
MySQL Core Certification
http://destiney.com/
--
MySQL General Mailing
of problem, could you please give us a bug
report?
Thanks
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838-708
VoIP: sip:[EMAIL PROTECTED], sip:[EMAIL PROTECTED]
Are you MySQL certified? http
Innodb is indeed row level locking. You are likely thinking of BDB
which uses memory page level locking.
gw
sheeri kritzer wrote:
Innodb is not row-level locking -- it's memory-page-level-locking. A
memory page is usually small, so it's almost like row-level locking,
but not quite. Perhaps
in this area, but I would be talking about some sysctl
variable, a ulimit on open sockets, or something to that effect.
This doesn't seem consistent with the errors you're reporting. If you
did hit some FreeBSD-related limit, it would be reported in
/var/log/messages.
Greg
--
Greg Lehey, Senior
)
This suggests that you're using a BSD-style package. BSD systems have
group wheel, many UNIX systems don't. Can you give details of your
system and what version of MySQL you're trying to install?
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South
In addition to the id_Site, you also need to grab the MAX(Time) so you have
something to sort by. This requires a little trick known as a groupwise
maximum. See
http://dev.mysql.com/doc/mysql/en/example-Maximum-column-group-row.html for
an explanation and some examples.
Greg Fortune
file.
When upgrading between major versions (4.0, 4.1, 5.0, 5.1, etc), it's always
wise to make a full backup of the data files and a full backup of the
database using mysqldump. The output from mysqldump is just SQL so it is
always the safest route if you run into problems.
Greg Fortune
Also, you may find that check table/repair table are able to fix the problem.
See http://dev.mysql.com/doc/mysql/en/Table_maintenance.html for more
information.
Greg
On Thursday 12 January 2006 08:28, Greg Fortune wrote:
That looks a little odd. Do isam tables have a .myi file for each
Dotan Cohen wrote:
I keep a lot of personal information in a MySQL database. I have a few
querys premade for the wife to use, but we have gotten to the point
where we need a solution for her to be able to run her own queries.
She is NOT about to learn SQL, and myPHPadmin is a little too
On 12/4/05, Luiz Rafael Culik Guimaraes [EMAIL PROTECTED] wrote:
Dear Friends
Is their an Page with data of how much bandwidth mysql consume when using
remote servers?
mysql show status like 'Bytes_%';
+++
| Variable_name | Value |
/mysql/en/Forcing_recovery.html
InnoDB: about forcing recovery.
mysqld got signal 11;
This is obviously a bug. I've just checked the bug database, but I
don't see a report on it yet. Could you please enter one?
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com
Saffa Kemokai wrote:
I am unable to start mysql after several trials and fixes. I compiled
a mysql 5.0.15 source for FreeBSD 5.3. It doesn't seem to have placed
the files in their proper locations. Below is what I keep getting and
I don't know now how to get it working. What do I need to do
space.
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-418-838-708
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
.
--
Greg Donald
Zend Certified Engineer
MySQL Core Certification
http://destiney.com/
the structure of
the tables are all the same and we need to compare the
data. Any advice is welcome. Thanks.
mysqldump -l -B db1 db1.sql
mysqldump -l -B db2 db2.sql
diff db1.sql db2.sql diff.sql
--
Greg Donald
Zend Certified Engineer
MySQL Core Certification
http://destiney.com/
a MySQL problem. Take a look at
http://bugs.mysql.com/ for information on how to report it. In
particular, the server logs should give some information.
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
See complete headers for address and phone
quality would be of much help.
If this isn't your (Joeffrey's) problem, it might give you an idea of
the kind of information we're looking for.
Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
See complete headers for address and phone numbers
RV Tec wrote:
Folks,
I'm used to run MySQL (4.0) with OpenBSD (3.7). Now I've decided to give
Linux a shot, to see if I could gain some serious performance. The
server I'm using is a dual Opteron 246, with 2GB RAM, LSI MegaRAID 320.
CentOS 4.1 x86_64 seems to be a good OS.
Although I
Hi,
Our company is considering migrating some tablesfrom MyISAM to InnoDB,
as it has row-level locking and other improvements over MyISAM.
However, one of the things we do at the moment is rsync the MySQL data
directory to our development server every night over an 2Mbps ADSL
connection (as we
You might try --xml or --html with a different separator.
Greg
--
Greg Fortune
Enterprise Systems
Eastern Washington University
Phone: 509-359-6690
Email: [EMAIL PROTECTED]
On Wednesday 20 July 2005 03:28 pm, Dan Bolser wrote
Filesystem buffering?
pow wrote:
Hi everyone,
Im puzzling over why a query loads faster the second time I execute it.
I am sure it is not query cached, because that is off.
I also made sure that the key that is used was already cached b4 i even
executed the query the first time. So it is not
the // and insert the $$ and it will work great.
Greg
On 7/15/05, Scott Hamm [EMAIL PROTECTED] wrote:
How effective is Stored Procedure in MySQL 5.x?
--
Power to people, Linux is here.
--
Greg Fischer
1st Byte Solutions
http://www.1stbyte.com
--
MySQL General Mailing List
For list archives
-statements.html
Functions:
http://dev.mysql.com/doc/mysql/en/stored-procedures.html
Hope that helps.
Greg
On 7/6/05, Gleb Paharenko [EMAIL PROTECTED] wrote:
Hello.
When attempting to load a new function with the mysql cli client the
client
complains that the server has gone away
this happen to me once. Reseated the card in the database server,
fixed it right up.
--
Greg Donald
Zend Certified Engineer
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jeff Smelser wrote:
On Thursday 09 June 2005 01:26 pm, George L. Sexton wrote:
Another limitation in MySQL is that you can only have one timestamp column
with a default of CURRENT_TIMESTAMP.
How many friggin times do I have to say that this is not an issue with 4.1 and
above? Which, BTW,
they do
not use indexes correctly. This is a legitimate complaint, and one that
I personally hope Mysql looks into and repairs. I echo Kevin's thoughts
and I rarely even have a use for sub-queries (given I got used to them
not being available).
Greg
--
MySQL General Mailing List
For list
They do use indexes if you use them to build derived tables and are
pretty fast. The only case where I see them not using indexes when I
think they should is when you use a sub-query for an IN() clause.
Kevin Burton wrote:
OK...
Subqueries in 4.1 are totally broken. They don't use indexes.
Hmmm, I downloaded source and compiled, and had an instant segfault.
Rolled back to 4.1.11. I assumed it was something funky w/ my compile,
but after reading all the above posts ... ???
Mark Matthews wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Donny Simonton wrote:
I'm not sure but I
Donny Simonton wrote:
With Mysql you should ONLY use RAID10. Everything else is not worth your
time.
I would argue that a large stripe (RAID0) would be a better solution for
slaves in a large replicant network. Why waste the drive space and
performance on a RAID10 when you have multiple
Newer SATA drives are supporting command queueing, which should really
help their performance. I think when SATA-2 becomes more available,
SATA will start being a more viable choice and start rivaling SCSI
performance.
--
MySQL General Mailing List
For list archives:
correct? Any problems w/ ext3?
Sorry to bombard you w/ questions, but we have had nothing but horrible
performance using Opterons, and any specifics you can give would help to
clear up this mess. I know that I am not the only person who is seeing
this flakyiness.
Thanks,
Greg
Dathan Pattishall
I am all in favor of this idea. Currently, this info is scattered all
over the web, and finding it can be time consuming (even w/ Google). I
see lots of people jumping the same hurdles, so a central location for
this info seems it would greatly benefit the community.
Greg
Kevin Burton wrote
Kevin Burton wrote:
Greg Whalin wrote:
I suspect this is an OS issue. Our Opteron's were completing large
data update queries aprox 2-3 times slower than our Xeons when running
under 2.6. After a switch to 2.4, Opteron's are faster than the
Xeons. I mentioned NPTL being shut off
Kevin Burton wrote:
Greg Whalin wrote:
We are currently running 2.3.2 (Fedora Core 1) on our Opterons. When
we were still running linux 2.6, we were on 2.3.3 (Fedora Core 2).
Yeah... we were being bitten by 2.3.2's NPTL implementation for MONTHs
before I heard a rumor that the Internet Archive
similar reports (from
Friendster) about their use of Suse 2.6 and Opterons being similarly slow.
We are currently running MyIsam tables, but plan on switching to Innodb
in the next month or two btw, so our performance problems are w/ MyIsam.
Greg
Peter Zaitsev wrote:
On Fri, 2005-05-06 at 19:01
is not a good solution. Yet, Mysql recommends exactly this
config and in fact, does not seem to even support (via support contract)
a 2.4 solution for Opteron + Mysql.
Greg
Dathan Pattishall wrote:
What kernel are you running.
If your running 2.6.x use the deadline scheduler or downgrade to
2.4.23aavm 2.6
Kevin Burton wrote:
Greg Whalin wrote:
We have seen the exact same thing here. We used the deadline
scheduler and saw an immediate improvement. However, we still saw
much worse performance on our Opteron's (compared to our older Xeon
boxes). We ended up rolling back to Fedora Core 1
2.4.22
/ production dbs) and ended up rolling back to 2.4.
Kevin Burton wrote:
Kevin Burton wrote:
Greg Whalin wrote:
Deadline was much faster. Using sysbench:
test:
sysbench --num-threads=16 --test=fileio --file-total-size=20G
--file-test-mode=rndrw run
So... FYI. I rebooted with elevator=deadline
On 4/15/05, Scott Haneda [EMAIL PROTECTED] wrote:
How are sites doing the search by zip and coming up with results within x
miles? Is there some OSS zip code download that has been created for this?
http://marc.theaimsgroup.com/?l=php-generalm=110547634827453w=2
--
Greg Donald
Zend
unusable in IN() statements which
is how most people use subselects IMO.
greg
Kevin A. Burton wrote:
http://www.peerfear.org/rss/permalink/2005/04/02/BrokenMySQLSubqueries
Whats up with this?
As far as I can tell MySQL subqueries in 4.1.x releases are totally
broken with IN clauses The major
How about
UPDATE table set email = TRIM(TRAILING '' FROM email)
http://dev.mysql.com/doc/mysql/en/string-functions.html
Greg Fortune
On Thursday 10 March 2005 03:29 pm, Scott Haneda wrote:
I managed to mess up and email storage addresses are in the format of
[EMAIL PROTECTED]
How I can
Any chance of condensing some of the flag fields into bit fields?
Alternatively, can you represent the variables as (rule id, variable name,
variable value) in a single table rather than using lots of columns/tables?
Greg Fortune
On Monday 07 March 2005 10:31 am, Kevin Cowley wrote
joins that
output millions of lines of data.
Greg Fortune
On Monday 07 March 2005 10:48 am, Caron, Christian wrote:
Hi,
the default select_limit is set to 1000. What does this mean and how can
it affect a server?
Is there some information out there about this variable? I can't find
Just found and read this study:
http://www.distlab.dk/badger/Publications/report0403.ps
and was curious to see if anyone has any additional thoughts as to the
contents?
Greg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
-compliant
because it can't survive a fire.
-Rich
Exactly. No ACID database can ensure integerity in such a situation.
Postgres, Oracle, or any other transactional DB would have suffered the
same fate in these two cases (LiveJournal, Wiki).
Greg
--
MySQL General Mailing List
For list archives
+ linux 2.6.10 w/ myisam
tables), we have seen very slow performance when running intensive IO
operations (deleting 20 million rows from a 50 col table) and we have
experienced a greater number of index corruption on the opterons than on
our intel dbs.
Greg
--
[EMAIL PROTECTED]
Meetup.com
Rich Lafferty wrote:
On Thu, Feb 24, 2005 at 09:10:32AM -0500, Greg Whalin [EMAIL PROTECTED] wrote:
Exactly. No ACID database can ensure integerity in such a situation.
Postgres, Oracle, or any other transactional DB would have suffered the
same fate in these two cases (LiveJournal, Wiki
the recent experiences of LiveJournal/Wikipedia sway these answers?
Just going over some thoughts in my head and want to see if any good
discussion can come from this?
Greg
--
[EMAIL PROTECTED]
Meetup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Wikipedia.
Greg
[EMAIL PROTECTED]
Meetup.com
Daniel Kasak wrote:
Scott Haneda wrote:
There is a thread over at /. about WikiMedia being out due to a power
outage
http://slashdot.org/articles/05/02/22/0151213.shtml?tid=95
MySql is getting bashed pretty hard in some cases as apparently, in power
failures
I was under the impression that fsync() was only buggy in Linux in the
2.4 kernels. Is it still problematic in 2.6 series?
Greg
--
[EMAIL PROTECTED]
Meetup.com
Heikki Tuuri wrote:
Peter,
a buggy fsync() in Linux is one of the possible reasons here. If an
InnoDB tablespace gets corrupt
Daniel Kasak wrote:
Greg Whalin wrote:
Many data centers do not allow customers to install their own UPS
inside the rack. I am not sure if this is the case with Wikipedia,
but it is definitely the case at the data center we are hosted in. I
would love to shove one in after reading the horror
.
Greg
Donny Simonton wrote:
I know this may be strange, but have you turned on innodb on the box? Even
if don't use it? I have 8 amd64 boxes and have never experienced this
problem you are talking about. They range from single proc to quad proc.
Never this problem but all of them have innodb
http://dev.mysql.com/doc/mysql/en/innodb-auto-increment-column.html
Rishi Daryanani wrote:
Hi,
My database is mostly made up of MyIsam tables, and some InnoDB tables.
One particular Innodb table works fine with an auto increment field.
The table is updated often, records being added and deleted at
)
Then, add an index on that column and test your queries against the new index.
I'd be surprised if you saw much increase in speed, especially as your data
set grows.
Greg
On Wednesday 09 February 2005 09:17 am, Gabriel B. wrote:
Short Version:
is there any way to make an index for a date
Jochem van Dieten wrote:
On Sat, 15 Jan 2005 11:11:05 -0500, Robert Alexander wrote:
Each language is going to have its own personality. If they all did
things the same way, we wouldn't have the wealth of different ones to
choose from.
DBMS's are not languages, they are implementations.
Might
admins with this
backup test.
Greg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
improvement the changes made.
Greg
On Tuesday 21 December 2004 02:25 am, Gleb Paharenko wrote:
Hello.
Using SHOW PROCESSLIST you can just check if your query running, or
is waiting for some lock. For more info, you can run ps axm in shell
and look for the thread state, but that's more related
of info?
Greg
--
Greg Fortune
Enterprise Systems
Eastern Washington University
Phone: 509-359-6690
Email: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
We also use Linux Virtual Server for load balancing, but only on our
read-only cluster. Our current levels of RW traffic do not demand more
than one machine.
Russell E Glaue wrote:
We have fail-over using Linux Virtual Server, now upgrading to Red Hat
Cluster Suite. We do not implement
connector.
Greg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Got me then?! I am still running 4.0.22. Waiting for the connecter/J
to come out of gamma and for 4.1.* to stabilize a bit, so I can't offer
much other than what I have read.
Frank Febbraro wrote:
Are you seeing the slowdown only from your java app? Or from all clients?
I see this slowdown
comments? Does this make sense to people? Any
better ideas? I can say that this works, whereas the default does not.
Meaning, I am able to take a snapshot, and build a new replicant off
of that using the data retrieved from (record_log_pos).
Greg
--
Greg Whalin
Meetup.com
[EMAIL PROTECTED
Ronan Lucio wrote:
Jeff,
Actually, Ive never had such problem.
Im just afraid of it because Ive read some issues about corruption
in MySQL tables and the own MySQL Manual says that exist a command
just to repair MyISAM tables (myisamchk -
http://dev.mysql.com/doc/mysql/en/Table_maintenance.html).
On Tue, 2004-11-30 at 11:50 -0600, Jeff Smelser wrote:
On Monday 29 November 2004 11:35 pm, Greg Macek wrote:
I was thinking about this as well, but was hoping to minimize the amount
of work I would have to do. However, if this makes the most sense for
upgrading, perhaps this is what I'll
planned on
walking through the upgrade pages from mysql.com for going from 3.23 to
4.0 and 4.0 to 4.1. I was hoping not to have to re-create the databases
as the original poster mentioned, but I don't have a slave DB setup
either. Will this be an issue?
Greg
--
MySQL General Mailing List
For list
1 - 100 of 342 matches
Mail list logo