t you 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
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 s
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 'P_LAS
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 sin
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 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
Wha
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 tabl
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
ma
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
http://dev.mysql.com/doc/refman/4.1/en/server-statu
Would like to know what is the archive "db.opt".
http://www.google.co.uk/search?q=mysql+db.opt&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=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
Seconds_Behind_Mast
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
restore
rick/tricks-sept-2001.php?article=tricks-sept-2001&kind=tr&id=2033&open=1&anc=0&view=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]
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
7;t know how
accurate 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 Panel>System>Advanced. 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
in the code you downloaded. 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],
fter 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, 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 PROT
a dry run before
entrusting your database 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:[EMAI
(5 ms seek,
0.1 ms transfer). Random access to a single 64 kB block takes about
6.6 ms (5 ms 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
co
a much better chance of it being
accepted. If you or somebody else want to do this, please contact me
first so that we can discuss the approach.
Greg
--
Greg Lehey, Senior Software Engineer, Online Backup
MySQL AB, http://www.mysql.com/
Echunga, South Australia
Phone: +61-8-8388-8286 Mobile: +61-41
; 4.1.20. If you have indeed hit a bug, your best bet would be to upgrade
>and try again. You should probably at least read the *long* list of bug
> fixes from 4.1.7 to 4.1.20 in the MySQL change history in the manual
> <http://dev.mysql.com/doc/refman/4.1/en/news-4-1-x.html>.
While it
ason to
believe that my guess is right. In this case, it's not a MySQL
problem. The best thing to do then would be to report it via the
FreeBSD bug reporting system (http://bugs.FreeBSD.org/).
If the problem still occurs, it would be good to get more information
about the database and que
.
>
> Is this a legit bug I should report to the buglist or did I screw
> something up?
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 Softwar
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
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
time: how would 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 w
e mess, and
you should see 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.mys
not "New 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 Sof
>> ...
>>
>> There are several possible reasons for this. ...
>
> Thanks 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://ww
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 Redh
ment (since my ISP limits
> the total number 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.my
ating server behaviour
> at the client side. Although this works for a very large part, it isn't
> exactly easy and there are still problems sometimes, it's hard to
> get perfect.
>
> This is the reason why we haven't gone that route with MySQL.
What would it take on our si
SAM tables, is NO.
Currently foreign key constraints only work for InnoDB tables. We're
working making foreign keys table 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: +
ariables' returns, plus what databases 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 Certific
http://dev.mysql.com/doc/refman/5.1/en/replication-features.html
MySQL only supports one master and many slaves.
--
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]
;re having this kind 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 My
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. Perha
able, 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 Software Engineer
MySQL AB, http://www.mysql.com/
d in group table(s)
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, htt
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 F
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 e
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 Fortun
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
compicate
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 |
++---
lespace. Please refer to
> InnoDB: http://dev.mysql.com/doc/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?
G
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
rse
it can use nearly twice as much disk 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 li
ne.
>
> Any help is appreciated.
Add an auto_increment option to your Id field.
--
Greg Donald
Zend Certified Engineer
MySQL Core Certification
http://destiney.com/
systems? We are sure 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/
ned bug report has done a
very good job of describing his problem. Only reports of similar
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
M
port to MySQL or to PHP? I'm not able to test
> other APIs at the moment.
If the server dies, that's 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 S
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 though
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 h
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 l
So, remove 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 Solution
c/mysql/en/c-api-prepared-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
might check your network cards. Had
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,
le because 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 Mailin
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
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: http://lists.mysql.com/mys
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 replic
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
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 Ar
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 bein
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
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
uch w/ 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=dea
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
6 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.
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-general&m=110547634827453&w=2
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 PR
oduct 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
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
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
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
perience (running mysql on Opteron + 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
--
[E
be complaining that MySQL isn't ACID-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
--
MyS
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
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
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 in a
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
.
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 i
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
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 no
culate how much 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
>
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]
ay to get at this kind 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 load-ba
Ronan Lucio wrote:
Jeff,
Actually, IÂve never had such problem.
IÂm just afraid of it because IÂve 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)
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
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 f
connector.
Greg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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,
On Mon, 2004-11-29 at 13:11 -0600, Paul DuBois wrote:
> At 12:57 -0600 11/29/04, Jeff Smelser wrote:
> >On Monday 29 November 2004 09:01 am, Greg Macek wrote:
> >
> >> I am actually in the process of planning a similar upgrade for our
> >> database server. None o
1 - 100 of 361 matches
Mail list logo
