the slave just doesn't realize that
it's lost its connection.
...Todd
--
The total budget at all receivers for solving senders' problems is $0.
If you want them to accept your mail and manage it the way you want,
send it the way the spec says to. --John Levine
--
MySQL General Mailing List
it's a
memory or file issue.
...Todd
--
Always code as if the guy who ends up maintaining your code will be a
violent psychopath who knows where you live. -- Martin Golding
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
. Thank you so much for clearing that up.
...Todd
--
Always code as if the guy who ends up maintaining your code will be a
violent psychopath who knows where you live. -- Martin Golding
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
, why is it printing out the correct value using latin1
but not using utf8 ?
...Todd
--
Always code as if the guy who ends up maintaining your code will be a
violent psychopath who knows where you live. -- Martin Golding
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
is local for you) hiring a consultant skilled in
mysql crash data recovery:
- Oracle
- Percona
- SkySQL
Regards...Todd
--
SOPA: Any attempt to [use legal means to] reverse technological
advances is doomed. --Leo Leporte
--
MySQL General Mailing List
For list archives: http
like you need to find the appropriate value to use to
make your data accessible.
Regards... Todd
--
SOPA: Any attempt to [use legal means to] reverse technological
advances is doomed. --Leo Leporte
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On Wed, Jan 25, 2012 at 6:42 AM, Todd Lyons tly...@ivenue.com wrote:
For example, I shut down my mysql daemon, I make a copy of my
corrupted database at /var/lib/mysql/ into /var/lib/mysql_tmp/, and
then manually start the mysql daemon in the foreground with this:
su - mysql -c '/usr/libexec
in 0.0086
seconds' at the bottom). I have many ODBC clients accessing this server as
well, they all have slowness problems too.
I'm stumped. What could possibly be causing this issue?
Wild Guess: Does DNS resolution, especially reverse dns resolution,
still work on the mysql server?
...Todd
, the biggest step in the sequence above is likely #8.
The ability to assess a situation without freaking out (for too long)
is a big part of a sysadmin job IMHO.
Regards... Todd
--
If Americans could eliminate sugary beverages, potatoes, white bread,
pasta, white rice and sugary snacks, we would
the best fit in this case.
...Todd
--
If Americans could eliminate sugary beverages, potatoes, white bread,
pasta, white rice and sugary snacks, we would wipe out almost all the
problems we have with weight and diabetes and other metabolic
diseases. -- Dr. Walter Willett, Harvard School of Public
) does it still choose what you consider to
be the wrong key?
--
Regards... Todd
I seek the truth...it is only persistence in self-delusion and
ignorance that does harm. -- Marcus Aurealius
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
ForwardX11=yes in ~/.ssh/config
ssh host1
# then from there:
ssh -X host2
On host 2, running a gui app pops it up on my local desktop.
--
Regards... Todd
I seek the truth...it is only persistence in self-delusion and
ignorance that does harm. -- Marcus Aurealius
--
MySQL General Mailing List
replication.
--
Regards... Todd
I seek the truth...it is only persistence in self-delusion and
ignorance that does harm. -- Marcus Aurealius
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
you restarted the stress test, did it access new tables or the
same ones that the previous stress test did? What happens if you tell
innodb to use less memory and do your tests? Have you found any way
to make mysql not run out of memory?
--
Regards... Todd
I seek the truth...it is only
Simple - brilliant. I've modified to cat a temporary script...
1) cat the file as suggested:
cat ~/payload/scripts/create_mysqldb.sql EOF
###---
### Display the current user
###---
create database puppet;
###---
### Display all default accounts
###---
USE puppet;
###---
### Remove
file_with_allsql_you_need.sql
or
cat file_file_with_allsql_you_need.sql | mysql -u root -hlocalhost
and you are done.
On Tue, Jul 27, 2010 at 3:56 PM, Todd E Thomas
todd_...@ssiresults.com mailto:todd_...@ssiresults.com wrote:
I'm looking for automation direction...
I've found many packages that sit on top
. Variable expansion is the problem. For now all
of my other scripts substitute $PASSWD_PRIV_ROOT (from my
1_GLOBAL_ENV.sh) for the actual password. The *.sql scripts do not.
If anyone can shed some light on this I would appreciate the help.
--
Thanks for the assist,
Todd E Thomas
C: 515.778.6913
It's
would greatly
appreciate any pointers in the right direction. Bash is comfortable for
me and perl is within reach. I'm not much versed in anything else right now.
--
Thanks for the assist,
Todd E Thomas
It's a frail music knits the world together.
-Robert Dana
--
MySQL General Mailing List
testing so far, I've not
hit a timeout or received an incorrect OK or FAILED message in the
5.1.x series.
--
Regards... Todd
The best thing about pair programming is that you have the perfect
audience for your genius. -- Kent Beck
--
MySQL General Mailing List
For list archives: http
, will I be avail to uploaded into
a myisam
database and will it work?
Depends. If you use foreign keys in innodb, then you cannot import
that into myisam because myisam does not support foreign keys. If you
do not use foreign keys, it should work.
--
Regards... Todd
--
MySQL General Mailing
erroneous
assumption that if you were using foreign keys, when you switched to
MyISAM you wanted to continue to use foreign keys. Without the op
saying one way or the other, Michael's answer is more correct than
mine.
--
Regards... Todd
--
MySQL General Mailing List
For list archives: http
issue
or problem with xtrabackup? I'm not aware of any show-stopper bugs.
I'm just curious, because it works well for us. The backup is online
with the only lock held occuring while it's copying over the *.frm and
*.MY* files, which is not very much for us.
--
Regards... Todd
--
MySQL
-h10.200.100.10 -uroot
-p'. When you enter the correct password, it should let you in.
* I don't know if you'll need to restart mysql for it to bind to the
new IP. I don't think so, but then again I have not tested it.
--
Regards... Todd
--
MySQL General Mailing List
For list archives: http
in short order. Look at your cron jobs that
start or end around the time that all those empty binlogs are being
created.
--
Regards... Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
tables.
Note that foreign keys will break if your InnoDB table uses them.
--
Regards... Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
, not just the
ibdata and iblog files. Just make sure that your innodb settings in
my.cnf match.
--
Regards... Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
expecting me to do their work for them just
so they can receive emails from a public list that they joined.
Regards... Todd
On Wed, Jul 15, 2009 at 10:20 AM, postmas...@boxbe.com wrote:
Hello Todd Lyons,
I use Boxbe to protect my email address. While I did receive your email
about Re: Copy
that will explain the sudden drop
in speed.
--
Regards... Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi All,
I want to create a table that defaults to current_date and current_time.
I have:
CREATE TABLE `personalevent`(
`pevent` mediumint(10) NOT NULL,
`eventid` mediumint(10) NOT NULL,
`userid` mediumint(10) NOT NULL,
`username` varchar(10) NOT NULL,
Hi Guys,
i am still lost here:
GRANT ALL ON mysql.* TO 'root'@'localhost' IDENTIFIED BY 'XXX';
GRANT ALL ON mysql.* TO 'root'@'173.8.172.53' IDENTIFIED BY 'XXX';
FLUSH PRIVILEGES;
Here is the command that I am executing:
[r...@server1 ~]# /etc/init.d/mysqld restart
--init-file=clouds.sql
(or whatever the path to mysqld_safe is)
2009/4/29 Jason Todd Slack-Moehrle mailingli...@mailnewsrss.com
Hi Guys,
i am still lost here:
GRANT ALL ON mysql.* TO 'root'@'localhost' IDENTIFIED BY 'XXX';
GRANT ALL ON mysql.* TO 'root'@'173.8.172.53' IDENTIFIED BY 'XXX
!
-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
, mark konetchy wrote:
hey jason,
you need to restart the *server* with the init-file option, have a
look at:
http://dev.mysql.com/doc/refman/5.0/en/server-options.html
2009/4/28 Jason Todd Slack-Moehrle mailingli...@mailnewsrss.com
I am trying to start MySQL with --init-file but i get
Hi All,
CentOS 5.3
I installed MySQL Server via yum and started it.
I tried entering:
mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
But I get:
r...@server1 ~]# /usr/bin/mysqladmin -u root -h localhost password
) How to Use Charsets and
Collations Properly Susanne Ebrecht
A quick reminder, in the U.S. we're in daylight savings time now, so
those times are 7AM PDT / 8AM MDT / 9AM CDT / 10AM EDT. Ultimately
though, you can't go wrong if you base it on 14:00 UTC :-)
--
Regards... Todd
All
/mysqld/mysqld.pid
[mysqldump]
quick
--
Regards... Todd
All truth passes through three stages. First, it is ridiculed. Second,
it is violently opposed. Third, it is accepted as being self-evident.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Hi All,
On OS X, I have some Obj-C that creates NSTasks to execute some sql
statements.
What do I deploy on the client to make this work for them? I want to
make it park of my package installer, but I dont know what pieces.
Thoughts?
-Jason
--
MySQL General Mailing List
For list
-Original Message-
From: Per Jessen [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 14, 2008 6:23 AM
To: mysql@lists.mysql.com
Subject: RE: what is the proper way to store timezone information?
Boyd, Todd M. wrote:
When recording this information, do I store the full name
?) in the other table...
As I don't deal with letters/characters outside of the 'standard'
Latin-iso-asdfasdf collation, I'm afraid there's not much else I can
explain using my limited knowledge.
Hopefully, though, that helped to give you an idea of what he was
driving at. ;)
Todd Boyd
Web Programmer
at best. :) Can you not zero-fill? Are you
sorting by the entire field's value, or just a portion of it? Wouldn't
substring_index() sort all jane## entries arbitrarily, since your
(theoretical) example returns everything to the left of the first match
(but not including the match)?
Todd Boyd
Web
the time_zone_id value, then do it that way. It's not as if
it won't store your data if you store the time_zone_name... it just might be
harder to use as a variable later, being text instead of an identifying number.
Again... totally a matter of your preference.
Todd Boyd
Web Programmer
-Original Message-
From: Boyd, Todd M. [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 10:33 AM
To: Emily Heureux; mysql@lists.mysql.com
Subject: RE: natural sort via substrings
---8--- snip
Forgive me if I am incorrect, but wouldn't jane2 already be listed
before jane10
talks
about using Sphinx in BSD distros.)
Hope that helps,
Todd Boyd
Web Programmer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
of the database.
Thanks for any inputs
Is SELECT COUNT(*) FROM * too open-ended?
BTW... do you want the number of records per table, or number of tables
per database??
Todd Boyd
Web Programmer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
-Original Message-
From: Emily Heureux [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 11:12 AM
To: Boyd, Todd M.; mysql@lists.mysql.com
Subject: RE: natural sort via substrings
Hi, I am sorry for being so vague. The values are not as simple as
jane20,
jane10, or jane2
From: Jim Lyons [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2008 12:10 PM
To: Boyd, Todd M.
Subject: Re: natural sort via substrings
What I would do is form 2 additional fields from the first, an alphanumeric
field and a numeric field so:
jane-2 jane- 2
alex 3 alex 3
was that
tables are either created as case-insensitive, or the search needs to be
specified as case sensitive (with BINARY).
Could this be a similar issue, perhaps? One table is specifically
case-insensitive with regard to the function, and the other is not?
Just spit-balling...
Todd Boyd
Web
myisam_sort_buffer_size=750MB.
/tmp folder has 16GB free space.
---8--- snip
OS error code 28: No space left on device
I would say you are running out of space.
Todd Boyd
Web Programmer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 12, 2008 10:27 AM
To: Boyd, Todd M.
Cc: mysql
Subject: Re: enable and disable keys
/tmp has 16GB free space
On 6/12/08, Boyd, Todd M. [EMAIL PROTECTED] wrote:
-Original Message-
From: Ananda Kumar [mailto:[EMAIL
,
dunno why it's not working for you.
- --
Regards... Todd
when you shoot yourself in the foot, just because you are so neurally
broken that the signal takes years to register in your brain, it does
not mean that your foot does not have a hole in it. --Randy Bush
Linux kernel 2.6.22-14
Hi All,
I have a client that wants to insert data into a VarChar field that contains
commas. These are property addresses.
Example:
2966 Moorpark Ave, San Jose, CA, 95128
1 Infinite Loop, Cupertino, CA, 95
How can I allow this?
Thanks!
-Jason
that relay-log and replicate
those commands into a local BDB database. The reason is for maximum
speed.)
- --
Regards... Todd
we're off on the usual strange tangents. next will be whether
it is ethical to walk in your neighbor's open house if they're
running ipv6
the timeout rather quickly.
Of course this doesn't address potential errors with the Slave SQL
Thread, but that is known.
- --
Regards... Todd
There are four boxes to be used in defense of liberty:
soap, ballot, jury, and ammo. Please use in that order. --Ed Howdershelt
Linux kernel
whether other engines obey the same rules and methods.
- --
Regards... Todd
Chris: grep 500 sendmail.mc
undefine(`FAIL_MAIL_OVER_500_MILES')dnl
Chris: just in case ...
Linux kernel 2.6.22-14-generic 3 users, load average: 0.00, 0.00, 0.00
-BEGIN PGP SIGNATURE-
Version: GnuPG
that the
innodb space is full. I know that the space isn't full because it is still
working. I am wondering how I can get a true size of the space used. I
would like to get back into the 2G segments. Any suggestions.
Todd
--
MySQL General Mailing List
For list archives: http
= 'user1' I do get
results. Could the user have been added using an insert causing the SHOW
GRANTS to fail?
Any Ideas
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to parse binary logs and recover from them, but is
there a way to do the same for text logs? I think I can write a bash
script to reformat the file into a series of queries, but I was hoping
there was an easier way.
Thanks so much, anyone willing to help.
Todd Ellison
--
MySQL General Mailing
todd hewett wrote:
mysql INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER)
mysql VALUES(36534);
ERROR 1216: Cannot add a child row: a foreign key constraint fails
Can you please post the output of:
SHOW CREATE TABLE BOARD_SERIAL_NUMBER;
mysql SHOW CREATE TABLE
) VALUES(36534),
INSERT INTO' at line 2
Any help ideas recommendations are appreciated.
Thanks,
Todd
as unknown
columns.
Any other ideas out there?
Thanks Todd
mysql INSERT INTO VCS_PO_NUMBER (VCS_PO_NUMBER) VALUES(899234);
Query OK, 1 row affected (0.00 sec)
mysql INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER)
mysql VALUES(36534);
ERROR 1216: Cannot add a child row: a foreign
row in set (0.02 sec)
Thanks again for your help in getting this right.
Todd
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED
I have created a table, sfyc and as root I issued the following:
grant all on * to todd identified by 'my_password' with grant option;
However, todd cannot access sfyc with
mysql -u todd -p sfyc
And the mysql db contains the following:
user table
+---+--+
| host | user
show
in the table, db.
Todd
Chris wrote:
Did you run the statement witht he mysql database as the current
database? If so , you're statement probably got converted to this:
grant all on mysql.* to todd identified by 'my_password' with grant
option;
It seems like a logical thing
The grant
remove mysql and yum install mysql and
yum install mysql-server and the control files are not recreated.
Any suggestions?
Todd
--
Ariste Software
200 D Street Ext
Petaluma, CA 94952
(707) 773-4523
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
you again!
Todd
Michael Stassen wrote:
Todd Cary wrote:
Unfortunately, I blew MySQL away by replacing the MySQL control
tables with others and not making a copy of the folder.
My data is backed up, so that is not a problem, but I cannot
reinstall MySQL and create the mysql directory
Thanks Gleb,
That was educational.
Is there a way to log connections in such a way that is easy to tell how
many connections were happening at one time?
Thanks,
Todd
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 12, 2005 12:26 AM
To: mysql
ran fine.
After that I've increased max_connections limit in /etc/my.cnf and app runs
fine.
Is there a way to determin what connectiions to MySQL are being used by whom?
Thanks,
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
such a beast exist?
---
Todd Gruben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
command prompt today to see if that
makes a difference.
Thanks,
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I've tested mysql in my high school lab running from an administrator
and from a student account, both from within the Cygwin terminal, and
at the Windows command prompt. From the administrator account, it runs
fine for hours. From the student account, it promptly (within 15
seconds or so)
frequently for users.
Also, if you have any ideas on how one might perform updates on specific
entries in that table without select privileges I'd be glad to hear them.
(though it sounds like it may be impossible)
Thanks again,
Todd
--
MySQL General Mailing List
For list archives: http
be
retrieved via that account, only overwritten.
UPDATE secrettable SET column = 'value';
DELETE FROM secrettable;
That may be possible, but I can't really see anywhere where that would be
useful.
Thanks.
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Thinking about this some more, it might be possible to achieve what my last
email suggests by allowing select on the primary key column. Or would that
set us back again? Thoughts?
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
=2;
So far as I've been testing this seems to work while preventing the user from
ever selecting what's in the other secrettable columns.
Thanks again!
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
in another teacher's lab.
Any ideas appreciated,
Todd
P.S. If you could cc me any replies, I'd appreciate it, since I read
the list on
digest.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
tool had no choice but to create new
foreign keys with the same name appended with the number 1. The end
result... total chaos. Fixed it though. I really appreciate your help.
Todd
On Aug 30, 2004, at 6:20 AM, [EMAIL PROTECTED] wrote:
Foreign keys are used to enforce foreign relationships
to enter data (NULL) into these fields which are child rows.
Can someone explain what I should do? Should I just change these fields
of data into NULL? I'm literally just trying to populate the tables
with enough data to run some test queries.
Any suggestions?
Todd
--
MySQL General Mailing List
This is just my guess, I am still too new to know for sure, but I would say
php can do what ever the user that is logging in can. phpMyAdmin will
create databases, and it is just a PHP Script.
Todd Hackathorn
-Original Message-
From: Elly Wisata [mailto:[EMAIL PROTECTED]
Sent
them if they want to save the file or open the file.
The thing is you have to tell the client browser it is a type of file that
it recognizes.
Hope that helps, good luck.
Todd Hackathorn
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 2:33
, It is labeled Libraries and header files,
this put both the old version and the new version. When I found this error
I searched all the forums and everyone had very complex(at lease for me)
ways of recompiling mySQL. But, just installing this rpm fixed it for me.
Good Luck,
Todd Hackathorn
to use it
instead. Also I am still learning mySQL and RedHat so don't need anything
more complex that it has to be. I am used to just installing it and away I
go, now I have all these different options.
Thanks in advance.
Todd Hackathorn
Is there any way to iterate thru the keys in a fulltext index? This issue
does not come up for other indexes since ORDER BY can achieve this:
For example if table t is indexed on part_id
SELECT DISTINCT part_id FROM t ORDER by part_id;
will return all keys in index order
Is there a way to
far
the graphical packages for updates are the only thing I miss from SQL
Server.
Thanks in advance for any help.
Todd Hackathorn
server? To make two connections and pull data from one to the other?
Thanks,
Todd Hackathorn
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 8:30 AM
To: HACKATHORN, TODD (SWBT); [EMAIL PROTECTED]
Subject: Re: Scripting
Todd,
I'm also pretty new
with fairly large
tables. I am new to both Linux, and mySQL, but do have a decent amount of
experience in other SQL system.
I am using RedHat 9, mySQL Ver 12.22 Distrib 4.0.18, for pc-linux (i686).
Thanks in advance,
Todd
Is there any way to disable replication of all temp tables using
replicate-ignore-table or some other means? The names of the temp tables
are generated randomly by a script. Thanks
Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Is there a way to export/import MySQL tables in XML format?
Todd
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jay -
I am not an expert with XML, however I use it with Delphi and Delphi's
TClientDataset. In this usage, I use the builtin SaveTo and LoadFrom
methods.
Todd
Jay Blanchard wrote:
[snip]
Is there a way to export/import MySQL tables in XML format?
[/snip]
Well Todd, it is a little more
John -
Right under my nose! Thanks
Todd
John Griffin wrote:
Look at http://www.mysql.com/doc/en/mysql.html. The -X option may give you what you need.
-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 01, 2003 9:57 AM
To: Todd Cary; Jay
Dan -
Or from my place, "It pays for me to read the docs - thoroughly". Oh!
Docs! What are they? :-[
Todd
Dan Greene wrote:
The most guarenteed way to have a feature in a product pointed out is to make a public statement that it's not available :)
keyboard in mouth,
I tried installing MySQL on Fedora and all seemed to go fine, but there
is no mysqladmin. Have I missed something here?
And I am not sure where the mysql executable resides. The version is
MySQL-3.23.58-1.i386.rpm
Todd
--
inline: NewLogo.gif
://www.php.net/manual/en/function.mysql-insert-id.php
todd[1]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE/hd7v9xvMmfxCaFkRAsoZAJ9eL5aQf0dCHwY/nFdH5vQIny0BrgCgrcI3
V64M7/8+BnyHjJLlzYvG1C4=
=MFdB
-END PGP SIGNATURE-
--
MySQL General Mailing List
For list archives: http
Using MySQL and InnoDB, are there system tables or other tools that I can
use to see which statements that are executing have consumed the most CPU
time and find out which user, transaction and/or connection those statements
belong to?
If I identify a user that is causing a problem is there a way
I cannot tell from the Reference Manual whether the table cache is used with
the InnoDB database engine or not? It sounds like it only applies to tables
that are stored in separate disk files. Is the table cache used by InnoDB?
Bill
--
MySQL General Mailing List
For list archives:
: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 10:44 PM
To: [EMAIL PROTECTED]
Subject: Re: Do InnoDB rollback segments expand dynamically?
Bill,
- Original Message -
From: Bill Todd [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday
I know, I know, with database servers more is always better.g However,
assume I need to deploy MySQL using InnoDB to multiple sites. Hardware cost
is a significant consideration. Is there any information available on
MySQL's memory requirements? Most database vendors give you something as a
What transaction isolation level(s) does BDB support? I can't find any
information on BDB transactions section 7.6 of the manual.
Thanks,
Bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Since InnoDB does not allow phantom reads with Repeatable Read isolation
(which are allowed in the ANSI SQL definition of Repeatable Read) what is
the difference between these two isolation levels. Is it just serialization
and that is all?
Bill
--
MySQL General Mailing List
For list archives:
Using InnoDB with an autoextend tablespace, if I start a transaction that
results in many record versions, will the rollback segments grow dynamically
and force the tablespace to grow dynamically to provide the required room
for record versions in the rollback segments?
Bill
--
MySQL General
1 - 100 of 283 matches
Mail list logo