Hi!
Use mysql client:
mysql> *SELECT `user`, `host` FROM `mysql`.`user` LIMIT 0, 5;*
2010/2/5 ishaq gbola :
> Hi Guys,
>
> Which command can allow me view all accounts in a Mysql database
>
>
>
>
--
Best regards,
Eugene Kilimchuk
Hello!
If you use *nix sistem. You can use the 'tail' utilit with -f flag.
In the first terminal you use: mysqldump or 'select * into outfile'.
In the second terminal you can use: tail -f file_name.
This is help for monitoring.
2010/2/21 Yang Zhang
> Hi, I'm interested in piping out the contents
http://assets.en.oreilly.com/1/event/27/Linux%20Filesystem%20Performance%20for%20Databases%20Presentation.pdf
2010/3/10 John G. Heim
> Hi,
>
> I am working on configuring a new hardware database server. I'm a little
> confused as to what to do about disk. We have several mysql databases but by
>
If you use *nix, you can use this form:
*echo* "TRUNCATE TABLE you_table_name;" | *mysql* -A your_db_name -ulogin
-ppassword
And:
*cat* your_file.sql | *mysql* -A your_db_name -ulogin -ppassword
2010/3/17 John Oliver
> Is there a way to use mysqladmin (or mysql) to truncate a table as a
> on
Hello!
I use CentOS 5.4 with LAMP. On the server runs heavy cgi-programs. MySQL use
75% (100% = 8GB) of memory. When cgi programs use more than 25% of memory
and all SWAP file (8GB), kernel run OOM-Kiler wich kill mysqld procces.
I use:
echo "0" > /proc/sys/vm/swappiness - This allows to reduce
gt; Walter Heck
> Engineer @ Open Query (http://openquery.com)
>
> On Fri, Aug 6, 2010 at 02:43, Евгений Килимчук
> wrote:
> > Hello!
> >
> > I use CentOS 5.4 with LAMP. On the server runs heavy cgi-programs. MySQL
> use
> > 75% (100% = 8GB) of memory. When cg
I can't write my config parameters now.
5 августа 2010 г. 23:02 пользователь Евгений Килимчук
написал:
> Mysql used 5GB (buffers + 400 connections) of memory, but CGI-script some
> time made heavy load when used many memory and used SWAP. OOM-killer must
> kill new cgi-forks,
ch - you risk it killing off other
> useful/critical things, like SSH daemons, the Apache root, what have you.
>
> Add more memory to the box or split the webserver off to another system,
> I'd say.
>
>
> 2010/8/5 Евгений Килимчук
>
> I can't write my config
select `rating`/100+`id` as result from `your_table_name` order by `rating`
desc LIMIT 5;
++
| result |
++
| 4.5000 |
| 1.2500 |
| 7.2000 |
| 6.1500 |
| 0.1000 |
++
2010/9/28 Tompkins Neil
> Hi
>
> I've a basic table like and want to SUM the top 5 values. For example if
I'm sorry!
SELECT sum(rating) FROM (SELECT rating FROM your_table_name ORDER BY rating
DESC LIMIT 5) AS result;
2010/9/28 Евгений Килимчук
> select `rating`/100+`id` as result from `your_table_name` order by `rating`
> desc LIMIT 5;
>
> ++
> | result |
>
mysqladmin kill id,id,...
2010/9/29 Willy Mularto
> Hi,
> I see so many locked tables and can not be unlocked. Is there any single
> command or tools to kill all processes?
>
>
>
>
> sangprabv
> sangpr...@gmail.com
> http://www.petitiononline.com/froyo/
>
>
>
> --
> MySQL General Mailing List
>
11 matches
Mail list logo
