Hi!
- Original Message -
From: "Gary Richardson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, March 05, 2005 1:34 AM
Subject: Re: Questions regarding INNODB
You could configure per table table spaces.. I suppose that would be a
little more trackable..
yes. Host
Does anyone know if there are any 3rd party shells that can connect to
a mysql server that support aliases, or have any features that can
make working from the console faster?
Thanks!
-Jacob
On Fri, 4 Mar 2005 11:59:56 -0600, jacob martinson
<[EMAIL PROTECTED]> wrote:
> Is it possible to setup
In the last episode (Mar 04), Stembridge, Michael said:
> mysqldump vs. 'mysql [db] > file.sql'
>
> I stumbled across the latter method early on but notice that most
> folks suggest using mysqldump instead; are there performance benefits
> with using mysqldump, or some other reason?
The latter ca
Right. First, I think the logic is flawed. We should successfully
prepare() or die. Period. If the call to prepare() failed ($sth is undef),
we should not making dying conditional on yet another value.
More to the point, this line is actually the cause of the problem. (Sorry I
didn't see i
You could configure per table table spaces.. I suppose that would be a
little more trackable..
On Fri, 04 Mar 2005 16:38:20 -0600, Michael Satterwhite
<[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> I just found out that the hosting company we're using has disabl
mysqldump vs. 'mysql [db] > file.sql'
I stumbled across the latter method early on but notice that most folks
suggest using mysqldump instead; are there performance benefits with using
mysqldump, or some other reason?
The same question could be applied to using mysqlimport vs. 'mysql [db] <
ta
Gerald Preston wrote:
David,
I read them and installed 4.1.10 and I am back to square one:
I used the following code:
my $dbh=DBI->connect( 'dbi:mysql:club', 'gjwpp88', 'x' ) or die
"\n$DBI::errstr\n";
You do not specify the host, so you are connecting to the default, which is
"localhos
When running this simple query:
SELECT fileid FROM test WHERE ecn='0'
MySQL yields this error:
#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='
The table collation is latin1_swedish_ci.
I ran SHOW CREATE TABLE fileid and foun
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I just found out that the hosting company we're using has disabled
INNODB support in their MySQL configuration. I'm a bit upset that they
don't document crippling the server anywhere, but that's neither here
nor there.
When I asked them about this, I go
Gerals Preston wrote:
[snip]
> my $sth = $dbh->prepare( $sql ) or die $dbh->errstr if $dbh->err;
[snip]
Regardless of other problems you may be having, I think you're not
doing what you want to do here. How about instead:
my $sth = $dbh->prepare($sql);
$sth || die "Error preparing sth from '$sql
Hello.
In your file you have lots of threads in Closing_tables
state and only seven queries which make updates. Means
that the thread is flushing the changed table data to disk
and closing the used tables. This should be a fast operation.
If not, then you should verify that you don't have
Hello.
> 0x808d8d7 handle_segfault + 423
> 0x82e68d8 pthread_sighandler + 184
> 0x80929a3 ip_to_hostname__FP7in_addrPUi + 483
> 0x809af45 check_connection__FP3THD + 213
Looks like it is a problem with gethostbyaddr(), which
solved in your version according to the manual at:
http://dev.
Hello.
No. There are only short forms of each command. See:
http://dev.mysql.com/doc/mysql/en/mysql-commands.html
jacob martinson <[EMAIL PROTECTED]> wrote:
> Is it possible to setup aliases in the mysql console to cut down on
> typing, i.e. instead of having to type out "show tabl
Hello.
> however, today one of them (Bytes_sent) reset itself
> to 0...
This variable changes only in one place (sql/net_serv.cc)
and has an unsigned long type. I think it has just overhelmed.
You may use some network accounting tool to calculate the
traffic.
E SA <[EMAIL PROTECTED
Lets not forget about mysqlhotcopy.
-Eric
On Fri, 4 Mar 2005 13:42:48 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> MrExecutive <[EMAIL PROTECTED]> wrote on 03/04/2005 01:12:02 PM:
>
> > Hello Guys,
> >
> > I am a newbie to mySQL and im trying to export my database via the
> > mySQ
Hello Guys,
I am using mySQL 4.1 for windows. How do i go about logging all failed
login attempts?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In the last episode (Mar 04), Chip Wiegand said:
> I made a change to my.cnf and want it to restart mysqld_safe so it
> will re-read my.cnf. How do I do this?
/usr/local/etc/rc.d/mysql-server.sh restart
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list arch
Someone else may have to chime in, but I think this will work:
mysqladmin -u root -p refresh
According to the help "refresh" will Flush all tables and close and
open logfiles. You may have to try it. Worst case just issue a
shutdown and then start it up again.
Scott
Chip Wiegand wrote:
I made a
On Thu, 3 Mar 2005, E SA wrote:
> Hi,
>
> I am trying to obtain read/write statistics from our
> database (4.0.21). I started by using the
> Bytes_received and Bytes_sent from "show status";
> however, today one of them (Bytes_sent) reset itself
> to 0...
>
> Which really messes up my calculation
I made a change to my.cnf and want it to restart mysqld_safe so it will
re-read my.cnf. How do I do this?
Thanks,
Chip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thu, 3 Mar 2005, Olivier Kaloudoff wrote:
> Hello,
>
> we're working on a two node setup to achieve high
> availability using 4.1.8;
>
> we first setup both servers with --bin-log, and only
> the slave server (db1) with --log-slave-updates. (binary logfile
> name is "master" on bot
MySQL: 4.1.8a
OS: FreeBSD 5.3
The problem is that BINARY LIKE '..' returns no rows no
matter what specified in '..' however BINARY field_name LIKE '..'
work, but I cannot use it because this does not use index (EXPLAINs are
bellow). According to documentation BINARY LIKE shoud work. But it
does no
Heikki Tuuri wrote:
Baba,
an undo log seems to be corrupt. He should restart mysqld with:
innodb_force_recovery=4
dump all tables, and recreate the whole InnoDB installation.
This was roughly my assessment and recommended procedure as well. The
customer decided to restore the system from a full b
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 03/04/2005 01:42:40 PM:
> UPDATE menu_sequence SET id=LAST_INSERT_ID(id+1);
>
>
> I am writing some code that I need to actually get the menu_sequence
> from above, store it in a variable and then do a increment. I do
> not know why I am having trou
MrExecutive <[EMAIL PROTECTED]> wrote on 03/04/2005 01:12:02 PM:
> Hello Guys,
>
> I am a newbie to mySQL and im trying to export my database via the
> mySQL Command line but i cant seem to find any good documentation on how
> to do this. More articles are telling me to use phpAdmin or som
UPDATE menu_sequence SET id=LAST_INSERT_ID(id+1);
I am writing some code that I need to actually get the menu_sequence from
above, store it in a variable and then do a increment. I do not know why I am
having trouble with this, but it looks like I would have to
String seq = "select id from m
i'll usually pipe mysqldump into gzip if it's a large database, or gpg
if there's sensitive data in it.
-jacob
On Fri, 4 Mar 2005 12:22:08 -0600, jacob martinson
<[EMAIL PROTECTED]> wrote:
> run:
>
> mysqldump --help
>
>
> On Fri, 04 Mar 2005 13:12:02 -0500, MrExecutive <[EMAIL PROTECTED]> wr
run:
mysqldump --help
On Fri, 04 Mar 2005 13:12:02 -0500, MrExecutive <[EMAIL PROTECTED]> wrote:
> Hello Guys,
>
> I am a newbie to mySQL and im trying to export my database via the
> mySQL Command line but i cant seem to find any good documentation on how
> to do this. More articles are te
http://www.mysql.com would be a nice place to start.
On Fri, 04 Mar 2005 13:12:02 -0500, MrExecutive <[EMAIL PROTECTED]> wrote:
> Hello Guys,
>
> I am a newbie to mySQL and im trying to export my database via the
> mySQL Command line but i cant seem to find any good documentation on how
> to
Hello Guys,
I am a newbie to mySQL and im trying to export my database via the
mySQL Command line but i cant seem to find any good documentation on how
to do this. More articles are telling me to use phpAdmin or some other
gui tool. I would like to learn the commands anyone has a good doc on
Is it possible to setup aliases in the mysql console to cut down on
typing, i.e. instead of having to type out "show tables" I can just
type "\dt" as in postgresql?
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
Since playing back binary logs is just like doing normal queries the
tips on this page mostly apply.
http://dev.mysql.com/doc/mysql/en/insert-speed.html
Depending on your shell scripting level you might have to mysqlbinlog
to a file then
add in lock statments or whatever you decide to use.
-Eric
Marcin Lewandowski wrote:
Hi,
I've got webserver with php and mysql-4.0.22
There I've got large phpbb2.
That's it. phpbb2 is known to consume ressources, if I were you i
wouldn't search further... not a mysql issue afaik
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For l
I saw some time ago a post on this list with a script for managing
multiple masters but I have lost it and I can not found it on a google,
mysql list archives, anywhere.
I have wrote a program in c for managing it but I would like to compare
if I didn't forgot about something.
I would be very
How do I create a table using:
date_format('2004-10-03 15:06:14','%m/%d/%y %T');
That way I can import Access Data?
--
Power to people, Linux is here.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Gerald Preston wrote:
[...]
I get "DBI connect<'club','gjwpp88',..> failed; Client does not support
authentication protocol requested by server"
Check this:
http://dev.mysql.com/doc/mysql/en/old-client.html >
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Mel,
- Alkuperäinen viesti -
Lähettäjä: "mel list_php" <[EMAIL PROTECTED]>
Vastaanottaja: <[EMAIL PROTECTED]>;
Lähetetty: Friday, March 04, 2005 4:13 PM
Aihe: Re: mysql crash - innodb not starting
Hi Heikki,
Still only one process with ps -fA. And mysql doesn't want to start
normally.
Tim,
Thanks, that did the trick. One thing, I tried to zip the files up and
I get permission denied when I attempt to do that with the command below.
All of the files are there, but they don't get zipped up. I also notice
that the txt files and the sql files have slightly different ownership
Hi Heikki,
Still only one process with ps -fA. And mysql doesn't want to start
normally.
This morning I tried by deleting innodb files (ibdata1,ib_logfile0,
ib_logfile1), and it didn't succeed in recreating them.
I just tried once again now and everything is fine, mysql starts and
recreates th
Mike,
- Alkuperäinen viesti -
Lähettäjä: "Mike Debnam" <[EMAIL PROTECTED]>
Vastaanottaja:
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Friday, March 04, 2005 2:49 PM
Aihe: Re: Correct way to use innodb_file_per_table?
Heikki,
the best way would be to symlink whole database directories under th
Mel,
do
ps -fA
Do you see more mysqld processes?
If the ibdata1 file stays locked even though there is no mysqld process,
then this is a bug in Linux.
If you do not use InnoDB, you can delete ibdata1 and ib_logfiles.
Best regards,
Heikki
Innobase Oy
InnoDB - transactions, row level locking, and f
Heikki,
> the best way would be to symlink whole database directories under the
> datadir. Then also an ALTER TABLE keeps the new .ibd file on
> the drive you
> intended it to be on. If you symlink a single .ibd file, then
> an ALTER will
> create the new .ibd file as not symlinked.
>
> As a
Hi,
according to the manual:
http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html
150 is "a foreign key definition would be incorrectly formed for the
altered table"
/Johan
Joppe A wrote:
Hello all,
I have a problem with a script I have made, it always stops when it tries to creat
Hello all,
I have a problem with a script I have made, it always stops when it tries to
creat a special table, I have been comparing this part of the script with the
other parts that is working and cand find anything that looks wrong...
The message MySQL write is:
Can't create table './test_
I did ps -aux
I see one mysqld running (mine, launched with --skip-innodb).
I shut it down.
ps -aux: nothing
I tried to start it again, doesn't work.
As it is running on a machine managed by the system service I went to see
them after shutting it down again, they have no mysql process running.
(s
> But when I execute a complex query, it hangs there forever. I don't have
> a chance to see the result because I need to go home to have dinner. The
> same query run in a FreeBSD system in Mysql5.01 just takes 2 seconds.
Please, execute this statements while the huge query is running,
and se
Hello.
> mysqladmin:connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)'
...
> shell>safe_mysqld --user=root --pid-file=/var/db/mysql/mysql.pid
> --skip-grand-tables &
> [1] 28712
> shell> Sta
Hello.
> Is the build in one for english only ?
On my Linux system with utf8 locale it works perfectly with
russian words. As the format of the file you may use such where
every word begins with a new line.
"Gabriel PREDA" <[EMAIL PROTECTED]> wrote:
> How internationalized is the ft_s
I simplified the query and narrowed the problem down to the use of
SUBSTRING_INDEX:
UPDATE `param_str`
SET `value` =
SUBSTRING_INDEX(
`value`,
';',
1
) + 1
WHERE
`id`=0 AND
`name`='prf_hits'
Table structure:
CREATE TABLE `param_str` (
`id` int(11) NOT NULL default '0',
David,
I read them and installed 4.1.10 and I am back to square one:
I used the following code:
#!/perl
use warnings;
use strict;
use DBI;
#use DBD-mysql;
my $group_name = "beer";
my $me = "E";
my $daily = "03032005";
my $item = "Bacardi";
my $unit = "2";
my
50 matches
Mail list logo
