Hi,
for all you people out there loving phpMyAdmin ;-)
please visit http://hackontest.org and vote for or suggest your favorite
feature you would like to see in phpMyAdmin and that can be implemented
within 24 hours by a team of three
Thank you very much!
--
Sebastian Mendel
--
MySQL
Any reply is appreciated .
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
Edition
More info and a 30-day trial version on www.upscene.com
Pricing information available on:
http://www.upscene.com/purchase.htm#adg
More information available here:
http://www.upscene.com/news/20080721.htm
With regards,
Martijn Tonies
Upscene Productions - Database Tools for Developers
Hi All,
Given a fairly simple table as follows
CREATE TABLE `common_userx2` (
`t_proj` char(6) default NULL,
`t_id` int(11) NOT NULL default '0',
`t_nick` varchar(50) character set latin1 collate latin1_bin NOT NULL
default '',
`t_country` varchar(50) NOT NULL default '',
`t_cpid`
Is there any other job running while the update is happening. Because,
myisam does a table level lock. Please check the show full processlist.
Also run mysqladmin -uroot -pxxx status. This would write lock information
into the machine.err log file. Check in this file also if there is any
locking
Hi All,
I have setup slave db. The machine configuration details of this slave is
same as master.
OS=redhat
8 cpu
16GB RAM
key_buffer_size=3000M
innodb_buffer_pool_size=1M.
But when i do top, in the master db
Cpu(s): 0.5%us, 0.3%sy, 0.0%ni, 87.2%id, 11.9%wa, 0.0%hi, 0.1%si,
0.0%st
Hi All,
Is there a simple way of checking when the backup db server performed
its last restore and whether it was successful or not. I need to ensure
that the dump and restore of the production box has run successfully
every night until proper backup/DRP procedures are in place. I'm not
Is my assumption correct that you dump your main production db and restore
it to a second server? And this restore is what you want to verify?
Olaf
On 7/21/08 8:34 AM, Warren Windvogel [EMAIL PROTECTED] wrote:
Hi All,
Is there a simple way of checking when the backup db server performed
its
Hi Warren,
R u using any tool/script for backup/restore procedure, if yes, then log
files generated by them should let u know, if they were successfull or
failed.
regards
anandkl
On 7/21/08, Warren Windvogel [EMAIL PROTECTED] wrote:
Hi All,
Is there a simple way of checking when the backup
Olaf Stein wrote:
Is my assumption correct that you dump your main production db and restore
it to a second server? And this restore is what you want to verify?
That is correct.
Warren
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Nothing else running and no queries go against that table, it's effectively
created just for this, so I would expect the table lock.
Show (full) processlist has nothing but this running..
Confirmed the faster disks by copying 5Gb files between two of the same type
of disk (I installed two of
If you do the dump/restore by hand or shell script than the first indicator
is if the process finishes without errors. Then you could calculate
checksums of your tables on both boxes and compare them, this will obviously
only work if the production db has not changed since the dump.
Are you doing
On 7/21/08, Moon's Father [EMAIL PROTECTED] wrote:
Any reply is appreciated .
--
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn
Maybe something to do with this: *BDB support will be removed. * Note that,
as of MySQL 5.1, BDB isn't supported any
Its mainly because it was purchased by Oracle. BDB provided transaction
support. Innodb has been the defacto choice for a ACID transactions,
but Innodb was also purchased by Oracle in its attempt to kill MySQL
after its failed attempt to purchase MySQL. That's why MySQL has been
working
when you run this update, what is the IO WAIT from the top command.
regards
anandkl
On 7/21/08, Phil [EMAIL PROTECTED] wrote:
Nothing else running and no queries go against that table, it's effectively
created just for this, so I would expect the table lock.
Show (full) processlist has
No, its mainly because BDB wasn't very good. Its transactional, but not
MVCC. Take a look at a contemporary article when the acquisition was made :
http://www.computerworld.com/databasetopics/data/software/story/0,10801,108705,00.html
Curtis Maurand wrote:
Its mainly because it was purchased
Possibly..
top - 07:52:58 up 18:04, 3 users, load average: 4.98, 4.09, 3.20
Tasks: 165 total, 3 running, 162 sleeping, 0 stopped, 0 zombie
Cpu0 : 0.0% us, 0.0% sy, 100.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0%
si
Cpu1 : 0.0% us, 0.3% sy, 0.0% ni, 0.0% id, 96.3% wa, 0.7% hi,
At 08:23 PM 7/20/2008, Perrin Harkins wrote:
On Sun, Jul 20, 2008 at 12:12 AM, mos [EMAIL PROTECTED] wrote:
Is there a way to get Insert ... select ... On Duplicate Update to
update
the row with the duplicate key?
That's what it does.
Why can't it do this?
What makes you think it can't?
On Mon, Jul 21, 2008 at 11:44 AM, mos [EMAIL PROTECTED] wrote:
I can't specify all of the columns in a Set statement in the
OnDuplicate clause because I don't know what the column names are and there
could be 100 columns.
Write code to do it. There is no way around specifying the
Copying 5GB files shows you what kind of performance you would get for
working with say video, or anything with large contiguous files.
Database access tends to be random, so you want a drive with faster
random access, not streaming speed. Try copying thousands of small
files and compare the
On 20.07.2008 23:49 CE(S)T, Rob Wultsch wrote:
On Sun, Jul 20, 2008 at 1:33 PM, Yves Goergen
[EMAIL PROTECTED] wrote:
Hello,
I've installed MySQL server 5.0 and have written a small statistics script
that regularly checks the number of connections and queries to the server,
which I can then
At 11:14 AM 7/21/2008, you wrote:
Copying 5GB files shows you what kind of performance you would get for
working with say video, or anything with large contiguous files.
Database access tends to be random, so you want a drive with faster
random access, not streaming speed. Try copying thousands
At 11:00 AM 7/21/2008, Perrin Harkins wrote:
On Mon, Jul 21, 2008 at 11:44 AM, mos [EMAIL PROTECTED] wrote:
I can't specify all of the columns in a Set statement in the
OnDuplicate clause because I don't know what the column names are and there
could be 100 columns.
Write code to do
On Mon, July 21, 2008 09:14, Brent Baisley wrote:
Copying 5GB files shows you what kind of performance you would get for
working with say video, or anything with large contiguous files.
Database access tends to be random, so you want a drive with faster
random access, not streaming speed. Try
So just use REPLACE instead of INSERT...
http://dev.mysql.com/doc/refman/5.0/en/replace.html
On Mon, Jul 21, 2008 at 11:44 AM, mos [EMAIL PROTECTED] wrote:
At 08:23 PM 7/20/2008, Perrin Harkins wrote:
On Sun, Jul 20, 2008 at 12:12 AM, mos [EMAIL PROTECTED] wrote:
Is there a way to get
At 12:16 PM 7/21/2008, you wrote:
So just use REPLACE instead of INSERT...
Sure, but a Replace will delete the existing row and insert the new one
which means also maintaining the indexes. This will take much longer than
just updating the existing row. Now if there were only a couple of
On Mon, Jul 21, 2008 at 2:43 PM, mos [EMAIL PROTECTED] wrote:
I thought if MySQL found a duplicate key on the insert, it would
automatically update the existing row that it found with the results from
table1 if I left out the column expressions in the update clause. But
apparently it doesn't
In the CLI, is there any way to source a file whose name has whitespace in
it (particularly spaces)?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
http://www.the-infoshop.com
Ls -la file\ name.file
\
Will escape the space for ya me believes
--Original Message--
From: Jerry Schwartz
To: mysql@lists.mysql.com
Sent: Jul 21, 2008 13:48
Subject: Spaces in sourced file names?
In the CLI, is there any way to source a file whose name has whitespace in
it
With 5.1 you have more control over general query log and the slow query log
- enable or disable at runtime, output to file or DB table.
As of MySQL 5.1.6, the server can write general query and slow query entries
to log tables, log files, or both. For details, see Section 5.2.1,
Selecting
OK. This is driving me Nutz 8-p
Any time I try to restart mysql, I get the error, Access denied for user
'debian-sys-maint'@'localhost'
My understanding is that the password for the debian-sys-maint user is found
in /etc/mysql/debian.cnf So, I edit that, and note the password.
I then
Do you login via sock or network ?
Didja change the passwd for localhost and % ?
--Original Message--
From: Jesse
To: MySQL List
Sent: Jul 21, 2008 17:35
Subject: Access denied for user 'debian-sys-maint'@'localhost'
OK. This is driving me Nutz 8-p
Any time I try to restart mysql, I
Thanks all for the suggestions. I *think* I've finally figured it out.
At the end of the day I think it was because the new drives were formatted
with ext3. I recreated them in ext2 and performance is back to where it was
on those queries..
I hadn't realised that ext3 would give that much of a
33 matches
Mail list logo
