…but no data. Here is example: SESSION1: mysql> show tables; +——————–+ | Tables_in_dumptest | +——————–+ | A | | B | | C | +——————–+ …`C`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `C` ( `t…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… other tools used by mysql client, so you might get … on the table. mysql> show processlist; +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ | Id | User | Host | db | Command | Time …
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
… pt-online-schema-change performs the ALTER without any locking. Client applications can continue reading and writing the table with no… the toolkit. We developed it some time ago for a client and quietly included it, without knowing how much it would… Peter will discuss using it to verify upgrades I’ll show how to use it to forecast scalability and performance The…
Comment: Introducing new type of benchmark
February 27, 2012 By 16 Comments
… implemented this in our stresstesting vApus Client. I have described vApus here: http://www.anandtech.com/show/3846/quad-xeon-7500-the… ones you should buy. See here: http://www.anandtech.com/show/5279/the-opteron-6276-a-closer-look/3. We have…
Comment: Percona Server vs MySQL on Intel 320 SSD
March 19, 2012 By 21 Comments
Vadim, Thank you, as always. I would have not thought of having such a large log file size. I thought that would make recovery painfully long? Is the log size you show something that many of your clients are now using and that you would advise? Thanks!
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
…_sent, etc) New command SHOW CLIENT_STATISTICS, which shows statistics per client‘s hostname, not per user FLUSH USER_ and CLIENT_STATISTICS commands Our port includes: INFORMATION_SCHEMA tables – USER_STATISTICS, CLIENT…
Post: SHOW OPEN TABLES - what is in your table cache
December 14, 2008 By 3 Comments
… examine what tables do you have open right now: mysql> show open tables from test; +———-+——-+——–+————-+ | Database | Table | In_use | Name_locked… command lists all non-temporary tables in the table-cache, showing each of them only once (even if table is opened… used. Note however if you’re starting MySQL Command line client without “-A” option it opens all tables in the active…
Comment: Percona RPMS for RedHat 5 / CentOS 5 x86_64
July 31, 2008 By 4 Comments
… Schema to export the output from the monitoring rather than SHOW {TABLE,USER,INDEX}_STATISTICS. That sounds great. We are still… log. And we are trying to add SHOW CLIENT_STATISTICS that will aggregate resource consumption by client IP. That should be out in…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… parallel in the background. So first thing to consider – single client work load does not necessary means single outstanding disk IO… and with some high amount of threads which do not show this effect well. So as you might see tuning IO…
Post: Mail clients and Databases
March 13, 2007 By 14 Comments
… need to have in memory to be able to quickly show list of messages sort them etc is message subject authors…
