gt;
> >>> > process with id 37 have been there for a long time, i tried to kill
> it
> >>> and
> >>> > drop the table. what can i do?
> >>> >
> >>> >
> >>> > Pau Marc Muñoz Torres
> >>> > skype: pau_marc
> >>> > http://www.linkedin.com/in/paumarc
> >>> > http://www.researchgate.net/profile/Pau_Marc_Torres3/info/
> >>> >
> >>> >
> >>> > 2015-05-17 7:23 GMT+02:00 Adarsh Sharma :
> >>> >
> >>> >> Hi Pau,
> >>> >>
> >>> >> Ideally drop table should not take that much time , you have to
> check
> >>> if
> >>> >> your command is executing or it is in waiting stage. May be you are
> >>> not
> >>> >> able to get lock on that table.
> >>> >>
> >>> >> Cheers,
> >>> >> Adarsh Sharma
> >>> >>
> >>> >>
> >>> >> On Sat, 16 May 2015 at 23:34 Pau Marc Muñoz Torres <
> paum...@gmail.com
> >>> >
> >>> >> wrote:
> >>> >>
> >>> >>> Hello every body
> >>> >>>
> >>> >>> i have a big table in my sql server and i want to delete it, it
> also
> >>> >>> have
> >>> >>> some indexes. I tried to "drop table" and "delete" commands but i
> >>> >>> eventually get a time out. Wath can i do with it, does it exist any
> >>> >>> method
> >>> >>> to delete tables quicly?
> >>> >>>
> >>> >>> i know that drop and delete are not equivalent but i want to get
> rid
> >>> of
> >>> >>> all
> >>> >>> information inside
> >>> >>>
> >>> >>> thanks
> >>> >>>
> >>> >>> Pau Marc Muñoz Torres
> >>> >>> skype: pau_marc
> >>> >>> http://www.linkedin.com/in/paumarc
> >>> >>> http://www.researchgate.net/profile/Pau_Marc_Torres3/info/
> >>> >>>
> >>> >>
> >>> >
> >>>
> >>
> >
>
--
--
--
Thanks
Suresh Kuna
Hi Pau,
Would you please paste the timeout error ? If you want to get rid of a
table then the recommendation is to drop the table in non-peak hours.
Thanks
Suresh Kuna
On Sat, May 16, 2015 at 2:00 PM, Pau Marc Muñoz Torres
wrote:
> Hello every body
>
> i have a big table in my sql s
unning fine, but the transactions do not appear to appear on the
> slave.
> > >
> > > I seek suggestions how to 1) find out what goes wrong when the vpn goes
> > > down, and 2) (much more important now) how to find out whether or not
> the
> > > slave is actually replicating or not.
> > >
> > > --bill
> > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:http://lists.mysql.com/mysql
> > >
> > >
> >
>
--
--
Thanks
Suresh Kuna
MySQL Database Consutant & MongoDB DBA
Hadoop Admin
; # Query_time: 120.000259 Lock_time: 0.00 Rows_sent: 1 Rows_examined:
> 0
> SET timestamp=1346443103;
> SELECT SLEEP(120);
>
> And also my slow log is increasing and decided to purge thorogh below
> command :
>
> cat /dev/null > /var/lib/mysql/slow-queries.log
>
>
> Anyone any ideas about this.
>
>
> Thanks
>
--
Thanks
Suresh Kuna
MySQL DBA
fi.ah...@sifycorp.com]
> Sent: Monday, May 21, 2012 2:04 PM
> To: 'Suresh Kuna'
> Cc: 'mysql@lists.mysql.com'; 'shafi...@gmail.com'
> Subject: RE: [Warning] Aborted connection.. (Got timeout reading
> communication packets)
>
> Hi suresh: I have g
Hello Shafi,
The below blog will give you more information on the error -
http://sureshkuna.blogspot.in/2010/12/aborted-connection-31084472-to-db-ms.html
Thanks
Suresh Kuna
On Mon, May 21, 2012 at 1:15 PM, Shafi AHMED wrote:
> Ladies and Gentlemen:
>
> I am getting below errors and
To unsubscribe: http://lists.mysql.com/mysql
>
>
--
Thanks
Suresh Kuna
MySQL DBA
gt; Dotan Cohen
>
> http://gibberish.co.il
> http://what-is-what.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
>
>
--
Thanks
Suresh Kuna
MySQL DBA
/refman/5.0/en/forcing-innodb-recovery.html
Thanks
Suresh Kuna
2012/1/24 Suporte Avanutri
> I've tried this before, but the server stills going down. The first error
> is always this:
>
> Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */* FROM 'usuario': Los
Hi,
Try the 3 options available in the below URL option, i.e ignore built in
innodb and set the default storage engine to another storage engine.
http://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#option_mysqld_ignore-builtin-innodb
Thanks
Suresh Kuna
MySQL DBA
2011/12/24
table1.id=
table2.id AND table1.value=table2.value)
For more details on intersect and minus, check this blog -
http://www.bitbybit.dk/carsten/blog/?p=71
Thanks
Suresh Kuna
On Sun, Oct 16, 2011 at 5:12 PM, Grega Leskovšek wrote:
> WHat is wring with the following three sentences?
>
&g
ata. The tables are going to be fairly simple.
> <<<<<<<<
> Navicat is good for the database work, but not for pretty reports.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
Hi,
The permanent solution is to convert the table into Innodb engine.
Thanks
Suresh Kuna
On Fri, Oct 14, 2011 at 1:00 PM, Mark Goodge wrote:
> On 14/10/2011 08:07, James wrote:
>
>> Hello,
>>
>> I have the following error on my mysql server log and managed to repa
Hello Shafi,
Adding to Prabhat alternatives, you can use --force to the mysqldump command
to ignore the errors and continue taking backup.
Regarding the error, we need to check whether the table is present or not
and the engine type specifically.
Thanks
Suresh Kuna
On Sat, Sep 24, 2011 at 3:31
MB or 512MB x 2 InnoDB log files. 2) dump and import the database
> using innodb_file_per_table so that optimization will free up space.. 3) are
> you running Bacula on the server as well? If so, decrease the buffer pool to
> 1-2GB.. if not bump it up to to 3GB as you need some memory for b
Hi Prabhat,
FYI
On Thu, Sep 15, 2011 at 10:33 AM, Suresh Kuna wrote:
> If the hardware on master and slave, version of mysql server, configuration
> and memory allocations are same then you can do a clean shutdown of mysql on
> slave and copy the files to master. Check if any memories
> if the can data migrated 100% consistent, every sort of export/import
> is per design complexer, slower and maybe unsafer
>
>
>
--
Thanks
Suresh Kuna
MySQL DBA
-file-formats.html
I would go with the Singer suggestions in "What you want to do is" part.
Thanks
Suresh Kuna
On Wed, Sep 14, 2011 at 7:21 AM, Singer X.J. Wang wrote:
> Comments:
> 1) There is no such thing as 15K RPM SSDs... SSDs are NON ROTATIONAL
> STORAGE, therefore RPMS
tional_mem_pool_size = 32M
>
> [mysqldump]
> max_allowed_packet = 16M
>
> [mysql]
> no-auto-rehash
>
> [isamchk]
> key_buffer = 1250M
> sort_buffer_size = 384M
> read_buffer = 8M
> write_buffer = 8M
>
> [myisamchk]
> key_buffer = 1250M
> sort_buffer_size = 384M
> read_buffer = 8M
> write_buffer = 8M
>
> [mysqlhotcopy]
> interactive-timeout
>
>
> Regards
>
> Maria
>
--
Thanks
Suresh Kuna
MySQL DBA
'mysql-bin.002830' at
> position 293541
>
>
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?**
> unsub=sureshkumar...@gmail.com<http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com>
>
>
--
Thanks
Suresh Kuna
MySQL DBA
x27;t giving me much to go in in terms of clues....
>
> Andy.
>
>
> Quoting Suresh Kuna :
>
> Can yo paste the complete error log, Ram memory size and configuration
>> file
>> here and make sure the machine has enough memory to run the services.
>>
>
vance,
>
> Andy.
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?**
> unsub=sureshkumar...@gmail.com<http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com>
>
>
--
Thanks
Suresh Kuna
MySQL DBA
' AND 1;
> +---+
> | 'a' AND 1 |
> +---+
> | 0 |
> +---+
> 1 row in set, 1 warning (0.03 sec)
>
> DB 5.1.58-1-log:(none) mysql> SHOW WARNINGS;
> +-+--+---+
> | Level | Code | Message |
> +-+--+---+
> | Warning | 1292 | Truncated incorrect DOUBLE value: 'a' |
> +-+--+---+
> 1 row in set (0.01 sec)
> --
> Rik Wasmus
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
before and after
> > show variables like 'wait_time%' returns 28800. Most confusing.
> >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/mysql?**
> > unsub=eroomy...@gmail.com<
> http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com>
> >
> >
>
--
Thanks
Suresh Kuna
MySQL DBA
me with the local client.
> >>
> >> Ciao Mad!
> >>
> >> Claudio
> >>
> >>
> >>
> >> 2011/8/23 Andrew Moore
> >>
> >>
> >>>
> >>> That's too bad. How did you configure things? What trouble shooting
> have
> >>> you
> >>> done so far?
> >>> On Aug 23, 2011 9:18 AM, "madu...@gmail.com"
> wrote:
> >>>
> >>>>
> >>>> When I try to start my mysql DB I keep getting the following message:
> >>>> "Can't connect to local MySQL server through socket
> >>>> '/var/run/mysqld/mysqld.sock'"
> >>>>
> >>>> Thanks
> >>>>
> >>>> --
> >>>> MySQL General Mailing List
> >>>> For list archives: http://lists.mysql.com/mysql
> >>>> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com
> >>>>
> >>>>
> >>
> >>
> >>
> >>
> >
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
l & notify us
> > immediately at ad...@sifycorp.com
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=eroomy...@gmail.com
> >
>
--
Thanks
Suresh Kuna
MySQL DBA
General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
.mysql.com/mysql?**
> unsub=sureshkumar...@gmail.com<http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com>
>
>
--
Thanks
Suresh Kuna
MySQL DBA
re elegant way of doing this with
> out the cron job script?
>
>
>
> --
>
> Hez
>
--
Thanks
Suresh Kuna
MySQL DBA
Thu, Jun 16, 2011 at 10:53 AM, Adarsh Sharma wrote:
> How we can create a deadlock manually to test this problem.
>
> Thanks
>
>
> Suresh Kuna wrote:
>
>> Good question Yogesh, I can say the best solution is
>>
>> Create a deadlock and test it, you will c
ock occures and
> both query are waiting to execute. What wil happen in that case?
> 1. Do the connection will wait till deadlock is removed or
> 2. Connection will close after 180 seconds as both queries are ideal and
> waiting for each other.
>
> Thanks,
> Yogesh
>
--
Thanks
Suresh Kuna
MySQL DBA
umint(10) unsigned | NO | PRI | NULL|
> auto_increment |
> | fname | varchar(20)| NO | | NULL|
> |
> | initial | varchar(5) | YES | | NULL|
> |
> | lname | varchar(20)| NO | | NULL |
> |
>
> +-++--+-+-+-
> ---+
> 4 rows in set (0.00 sec)
>
>
> Mimi
>
--
Thanks
Suresh Kuna
MySQL DBA
epair table with use_frm.
>>
>> On 19 May 2011 10:30, Suresh Kuna wrote:
>>
>>> Run this - repair table SystemEvents use_frm ;
>>>
>>>
>>> On Thu, May 19,
Can you paste the table files in the datadir and the execution part of the
below query.
On Thu, May 19, 2011 at 11:11 AM, Ramesh wrote:
>
> Lost all the records once i done the repair table with use_frm.
>
> On 19 May 2011 10:30, Suresh Kuna wrote:
>
>> Run this - repa
SysEvents.frm | repair | error|
> Corrupt|
>
> +--++--++
> 2 rows in set (0.00 sec)
>
> But the SysEvents.frm is there in the datadir.
>
>
>
> On 19 May 2011 09:35, Suresh Kuna wrote:
>
>> use repair table table_name use_f
thinking to take backup in compressed format.
>
> Thanks
>
>
> Suresh Kuna wrote:
>
> It really depends on What kind of backup you performed a month ago rather
> than the type of tables at the moment...
>
> On Thu, May 19, 2011 at 6:50 AM, Michael Dykman
> wrote:
>
unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
9573240; Skipped
> Data records: 82882799
>
> What might be the problem and how to make the table repair successfully.
>
> Guidance needed
>
> Thanks
> Ramesh
>
--
Thanks
Suresh Kuna
MySQL DBA
> --
> - michael dykman
> - mdyk...@gmail.com
>
> May the Source be with you.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
> SELECT `Blogs`.* FROM `Blogs` JOIN `Users` ON `Blogs`.`UserId` =
> `Users`.`Id`
>
> That is, if you already had a table with the joined outcome, you would use
> the WHERE-clause to determine what of it enters into further processing.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
Okie cool, Can you paste the error log details when it came up with force
recovery 6.
On Wed, Apr 20, 2011 at 6:16 PM, Brent Clark wrote:
> On 20/04/2011 10:10, Suresh Kuna wrote:
>
>> It will, try it out.
>>
>
> Thanks for replying.
>
> My Colleague and I, we t
It will, try it out.
On Wed, Apr 20, 2011 at 1:11 PM, Brent Clark wrote:
> Sorry
>
> Would you be so kind as to explain your thinking.
>
> How would upgrading Mysql fix the issue?
>
> Regards
> Brent Clark
>
>
> On 20/04/2011 06:23, Suresh Kuna wrote:
>
>
Install the latest version of mysql on top of the current version and start
the database.
On Tue, Apr 19, 2011 at 9:34 PM, Brent Clark wrote:
> Thanks for replying
>
> 5.1.55
>
>
> On 19/04/2011 13:55, Suresh Kuna wrote:
>
> What is the version of MYSQL you are using cur
ysqld(page_cur_parse_insert_rec+0x580) [0xb7500390]
> mysqld [0xb74ea325]
> mysqld(recv_recover_page+0x502) [0xb74ec2e2]
> mysqld(buf_page_io_complete+0x624) [0xb74a22e4]
> mysqld(fil_aio_wait+0x12d) [0xb74bdb8d]
> mysqld [0xb7533d80]
> /lib/i686/cmov/libpthread.so.0 [0xb6ffd4c0]
> /lib/i686/cmov/libc.so.6(clone+0x5e) [0xb6ded84e]
> The manual page at http://dev.mysql.com/doc/mysql/en/crashing.htmlcontains
> information that should help you find out what is causing the crash
>
>
--
Thanks
Suresh Kuna
MySQL DBA
7;s of members. If I understand the problem, it is caused by
> blob containing a character which is the same character that is used to mark
> the end of a transaction in the bin log.
>
> My questions: 1) Is this a reasonable/correct analysis and 2) how do I work
> around the issue?
>
> Thanks,
>
> Carl
>
>
>
>
>
--
Thanks
Suresh Kuna
MySQL DBA
t; Adarsh Sharma
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
by running it on different ports.
On Tue, Oct 19, 2010 at 10:42 PM, kranthi wrote:
> Hi all,
>
>How to install multiple instances in windows???
>
>
>
> Thank you.
>
>
--
Thanks
Suresh Kuna
MySQL DBA
m it, or the responce back from a select is an error?
> >>
> >>
> >>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
gt; >>
> > >> So what configure options do i need if i want to install mysql
> > >> seperatly in a folder?
> > >> Do i also need --datadir? If yes, where sould my data dir be? In
> > >> /usr/local/mysql-5.1.42/var?
> > >>
> > >> Thanks a lot,
> > >> Mario
> > >>
> > > --
> > > Regards,
> > >
> > > Himanshu Raina
> > > --
> > > Guillotine, n.:
> > >A French chopping center.
> > >
> > >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
> >
> >
>
>
> --
> Claudio
>
--
Thanks
Suresh Kuna
MySQL DBA
> 'time_zone_name'
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=joh...@pixelated.net
> >
> >
>
>
> --
> -
> Johnny Withers
> 601.209.4985
> joh...@pixelated.net
>
--
Thanks
Suresh Kuna
MySQL DBA
, 2010 at 5:45 PM
> Subject: Backing up the InnoDB tables
> To: "[MySQL]"
>
>
> Hi
>
> On a shared MySQL server with access just to my own database, what is the
> recommend backup methods and strategies for the InnoDB tables ?
>
> Cheers
> Neil
>
--
Thanks
Suresh Kuna
MySQL DBA
and recreate the database but still no
> luck. Thanks for any help.
>
>
>
> sangprabv
> sangpr...@gmail.com
> http://www.petitiononline.com/froyo/
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=ekilimc...@gmail.com
> >
> >
> >
> >
> > --
> > Best regards,
> >
> > Eugene Kilimchuk
>
>
--
Thanks
Suresh Kuna
MySQL DBA
s 3.9 GB? Could this
> be because it's filling up space in one of the files before the last
> auto-extending file, which these files are fixed sizes?
>
> Both servers are 5.0.77-log. One server is Cent OS, the other is RHEL.
>
> I'm very confused here.
>
> JW
>
> O
>
> innodb_data_file_path=ibdata1:1G;ibdata2:1G;ibdata3:1G;ibdata4:1G;ibdata5:1G;ibdata6:16G;
> *ibdata7:16G*
>
> Or will that cause MySQL to complain the file size isn't correct the next
> time it starts?
>
>
> Thanks for any help!
>
>
> --
> -
> Johnny Withers
> 601.209.4985
> joh...@pixelated.net
>
--
Thanks
Suresh Kuna
MySQL DBA
sts.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
what should I do?
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net
>>
>>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
unless and until if the variable is read-only, you don't need Lin.
On Mon, May 31, 2010 at 3:17 PM, Lin Chun wrote:
> hi
>
> as the title
>
> thanks
>
> --
> -
> Lin Chun
>
--
Thanks
Suresh Kuna
MySQL DBA
ves: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
, Apr 13, 2010 at 2:21 PM, F.A.I.Z.A.L wrote:
> hi all
>
> what is the difference between
>
> OPTIMIZE TABLE tablename;
>
> and
>
> ANALYZE TABLE tablename;
>
> thank you
>
> Cheers
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
--
Thanks
Suresh Kuna
MySQL DBA
ith a new MySQL 5.x
> server, is it possible?
>
> What do I need to change on my MySQL 5.x server to allow old clients to
> work?
>
> Also, what do I need to change to allow old PHP 4.x code to talk to a MySQL
> 5.x server?
>
> Thanks,
>
> POL.
>
--
Thanks
Suresh Kuna
MySQL DBA
hange the value of the AUTO_INCREMENT counter to be used for new rows,
do this:
ALTER TABLE t2 AUTO_INCREMENT = value;
You cannot reset the counter to a value less than or equal to any that have
already been used.
Thanks
Suresh Kuna
an only connect from that host alone.
--
Thanks
Suresh Kuna
MySQL DBA
2010/3/2 PengXiaoxun
> I create a new account via the following statement:
> CREATE USER 'monty'@'%' IDENTIFIED BY '123456';
> Without any privileges granted, the user 'monty'
Hi Robert,
We can see the functions by using the below command
Show function status ;
--
Suresh Kuna
MySQL DBA
On Mon, Feb 8, 2010 at 10:37 AM, Sir Wally Lewis wrote:
> How do I get a list of all defined UDF's known to the system?
>
>
>
> Kind Regards,
>
>
>
In the mysql prompt, execute the below
use mysql ; select user from user ;
will show all the accounts in a MySQL database.
On Fri, Feb 5, 2010 at 5:27 PM, ishaq gbola wrote:
> Hi Guys,
>
> Which command can allow me view all accounts in a Mysql database
>
>
>
>
-
-u name -p password database_name > backup.sql;
>
> but i am getting error.. i am using windows xp system.. please help me
>
--
Thanks
Suresh Kuna
MySQL DBA
Which OS your are using ?
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 2:25 PM, muralikrishna g
wrote:
> i am working on my pc with mysql-5.0.27-community-nt
>
> i have created several data bases and tables in that.. to take backup, we
> have to use dump., i dont know the correct s
Hi Murali,
We can switch to another user only by a new connection and not possible in
mysql prompt.
Thanks
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 2:24 PM, muralikrishna g
wrote:
> i am working on my pc with mysql-5.0.27-community-nt
> i have created users by using create user and i
and the newly created and old databases use the
same datadir
Thanks
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 9:22 AM, Carlos Proal wrote:
> As Suresh and others said, you have to stop the dbms, move to content of
> the dir and restart the dbms.
>
> Also, if you have a fresh ins
Not a problem as you are doing it from a whole data directory.
Thanks
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 11:56 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi All,
>
>
> I am creating symlinks as database.
>
> I have mysql data directory c
a user to change one's old password, the user needs to supply
the old password apart from the new one as well.
For more details, check the below link
http://code.google.com/p/securich/wiki/Documentation
Thanks,
Suresh Kuna
MySQL DBA
On Fri, Jan 22, 2010 at 11:52 PM, Tompkins Neil <
ne
Suresh Kuna
MySQL DBA
On Mon, Jan 25, 2010 at 6:06 PM, Wagner Bianchi
wrote:
> Hi friends,
>
> Last weekend I made an environment that use a MySQL Server version 4.1 that
> was defined to be the MASTER and other one version 5.1 defined as SLAVE.
>
> Because the application that w
Did you check the server load when it took 10 min.
Check the query log, number of connections and the number of queries in
query log at that time.
We need to analyze the system with the collected data what we have for
monitoring.
Thanks
Suresh Kuna
On Fri, Jan 22, 2010 at 12:25 PM, madunix
ove work
> load.
>
> Thanks,
> Krishna
>
>
> On Thu, Jan 21, 2010 at 4:46 PM, Suresh Kuna wrote:
>
>> Hi Krishna,
>> As table is using MyISAM engine and it acquires a table level lock, the
>> queries will be executed one after one .
>> By converting it int
Hi Krishna,
As table is using MyISAM engine and it acquires a table level lock, the
queries will be executed one after one .
By converting it into Innodb as it acquires a row level lock, doing a select
and delete based on primary key will be faster and the concurrency
increases.
--
Thanks
Suresh
Hi Manasi,
That alone is the difference in this case.
--
Thanks
Suresh Kuna
MySQL DBA
On Tue, Jan 19, 2010 at 10:36 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Dear Carlos,
>
> Thanks for the response. But I haven't gave any privileges besides
>
> innodb_write_io_threads = 16
> innodb_support_xa = false
> innodb_io_capacity = 1
> innodb_max_dirty_pages_pct = 90
>
> concurrent_insert = 2
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
>
>
--
Thanks
Suresh Kuna
MySQL DBA
slave goes to master. is there any parameter
> where I can set this. that after every 60 seconds slave should write data
> from master to its own local database.
> --
> Regards,
> Manasi Save
>
>
>
>
> Quoting Suresh Kuna :
>
>> Hi Manasi,
>> As bo
Hi Manasi,
As both are implemented by replication, there is a possibility for loosing
data.
Thanks
Suresh Kuna
MySQL DBA
On Wed, Jan 13, 2010 at 8:20 PM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi All,
>
>
> I want to implement MySQL Master Master Replicatio
same. Configure the replication
between the two server.
By doing this, We will save the import time in second server.
Thanks
Suresh Kuna
MySQL DBA
On Wed, Jan 13, 2010 at 3:58 AM, Tom Worster wrote:
> Frankly, I didn't entirely understand what you were proposing. I got lost
> ar
;
>
> Cheers
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
>
>
--
Thanks
Suresh Kuna
MySQL DBA
> read_buffer = 2M
> write_buffer = 2M
>
>
> thanks in advance..
>
> Cheers
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
>
> On Thu, Jan 7, 2010 at 11:27 AM, Suresh Kuna wrote:
>
>> Hi Faizal,
>> Max_connections are
Hi Faizal,
Max_connections are the connections for the overall MySQLD server.
Max_user_connections are the connections for the particular user ( i.e for
an account ) of the MySQLD server.
Suresh Kuna
MySQL DBA
On Thu, Jan 7, 2010 at 11:00 AM, F.A.I.Z.A.L wrote:
> Dear all
>
>
me but the data dictionary will get
effected.
Thanks
Suresh Kuna
MySQL DBA
On Thu, Jan 7, 2010 at 9:46 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi Johan,
>
>
> Is it possible to do such manipulation in NDB, the way innodb works.
>
>
> Thanks in advance
Try this : /dev/sda3:10Graw;/dev/sda1:5Graw
Change the newraw to raw and start the MySQL.
and paste the error log ouput.
Thanks
Suresh Kuna
MySQL DBA
On Mon, Jan 4, 2010 at 12:37 PM, Jeetendra Ranjan <
jeetendra.ran...@sampatti.com> wrote:
> Hi Suresh,
> Thanks, this link we
Hi Jeetendra,
Check the below url for details with the raw partition.
http://dev.mysql.com/doc/refman/5.4/en/innodb-raw-devices.html
Thanks
Suresh Kuna
MySQL DBA
On Mon, Jan 4, 2010 at 11:06 AM, Suresh Kuna wrote:
> Jeetendra,
>
> Give the MySQLD user permissions to the new directory
ame changed!! Please use
> '--log-bin=ip-xx-xx-xx-xx-bin' to avoid this problem.
> 100102 1:18:32 InnoDB: Operating system error number 13 in a file
> operation.
> InnoDB: The error means mysqld does not have the access rights to
> InnoDB: the directory.
>
>
> T
Hi Jeetendra,
What is the error it it saying in error log ?
Is this the fresh installation or already installed MySQL ?
Thanks
Suresh Kuna
MySQL DBA
On Mon, Jan 4, 2010 at 10:16 AM, Jeetendra Ranjan <
jeetendra.ran...@sampatti.com> wrote:
> Hi,
>
> I am using MySQL 5.0.85-commun
89 matches
Mail list logo
